Writing Basic SQL Select Statement. Restricting and Sorting Data. Displaying Data from Multiple Tables. Aggregating Data Using Group Functions. 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. Date time Functions Enhancements to Group by Clause. Advanced Sub queries. Hierarchical Retrieval. Extensions to DML and DDL Statements.