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. |