Follow Us on Facebook, Montgomery College, Information Technology Institute

Oracle Database 11g: Introduction to SQL, CMP998

Register for a Class

Be introduced to the Oracle Database 11g technology. Learn relational database concepts and SQL programming language in great detail. The concepts related to data warehousing and related applications are also covered. This class is applicable to Oracle8i, Oracle 9i, and Oracle Database 10g users.

Textbook: Special Instructions. Students need to go to the Rockville Bookstore and purchase these texts. Once processed by Oracle, they are sent to you via e-mail.

For further detailed information about this class visit the Oracle web site

Course Topics:
  1. Introduction
  2. Retrieving Data Using the SQL SELECT Statement
  3. Restricting and Sorting Data
  4. Using Single Row Functions to Customize Reports
  5. Reporting Aggregated Data Using the Group Functions
  6. Displaying Data From Multiple Tables
  7. Using Sub queries to Solve Queries
  8. Using the SET Operators
  9. Manipulating Data
  10. Using DDL Statements to Create and Manage Tables
  11. Creating Other Schema Objects
  12. Managing Objects with Data Dictionary Views
  13. Controlling User Access
  14. Manage Schema Objects
  15. Manipulating Large Data Sets
  16. Generating Data in Different Time Zones
  17. Searching Data Using Advanced Sub queries
  18. Hierarchical Data Retrieval
  19. Performing Regular Expression Support and Case Insensitive