| Oracle Topics Covered | 
                
                 |  | 
                
                 | ~ 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. |