Course Content
Introduction to SQL
- Introduction
- Writing a Basic SQL statement
- Restricting and Sorting Data
- Single Row Functions
- Displaying Data from Multiple Tables
- Aggregating Data by using Group functions
- Writing Sub queries
- Producing Readable Output with iSQL *Plus
- Manipulating Data
- Creating and Managing Tables
- Including Constraints
- Creating Views
- Other Database Objects
- Controlling User Access
- SQL Workshop
- Using Set Operators
- Oracle Date time Functions
- Enhancements to GROUP By clause
- Advanced Sub queries
- Hierarchical Retrieval
- Oracle Extensions to DML and DDL Statements