ORACLE (Paper I) SQL
Description
Oracle9i is a Relational Database Management System(RDBMS) with Object Relational Database Management(ORDBMS) futures. Oracle9i is the latest technology, which has many new features over previous versions like 8i and 8. Oracle9i comes with new SQL enhancements.
Curriculum For This Course
+ ORACLE (50)
| 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. |