Oracle Database 11g: Introduction to SQL, CMP998
This course introduces Oracle Database 11g technology and the relational database concepts and the powerful SQL programming language. 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
-
Audience:
- Database Administrators
- PL/SQL Developer
- Forms Developer
- System Analysts
- Technical Consultant
-
Course Objectives:
- Search data using advanced sub queries
- Retrieve row and column data from tables with the SELECT statement
- Employ SQL functions to generate and retrieve customized data
- Run data manipulation statements (DML) to update data in the Oracle Database
- Control user access and manage schema objects
Course Topics:
- Introduction
- Retrieving Data Using the SQL SELECT Statement
- Restricting and Sorting Data
- Using Single Row Functions to Customize Reports
- Reporting Aggregated Data Using the Group Functions
- Displaying Data From Multiple Tables
- Using Sub queries to Solve Queries
- Using the SET Operators
- Manipulating Data
- Using DDL Statements to Create and Manage Tables
- Creating Other Schema Objects
- Managing Objects with Data Dictionary Views
- Controlling User Access
- Manage Schema Objects
- Manipulating Large Data Sets
- Generating Data in Different Time Zones
- Searching Data Using Advanced Sub queries
- Hierarchical Data Retrieval
- Performing Regular Expression Support and Case Insensitive