Delegates: |
Anyone who needs to use the more advanced features of SQL to improve their productivity in querying and updating an Oracle database Together with the SQL course, this course covers the major topics required for the following Oracle examinations:
Introduction to Oracle9i: SQL Oracle Certified Professional examination (1Z0-007)
Oracle Database SQL Expert (IZ0-047)
|
Objectives: |
By the end of this course, the delegate will be able to:
- Use SQL Developer as an alternative to SQL*Plus
- Manage Schema Objects with Data Dictionary Views
- Write Multiple Column Subqueries
- Manage Large Data Sets with Subqueries
- Construct Hierarchical Queries
- Use the ROLLUP, CUBE and GROUPING SETS Group By Extensions
- Manage Data in Different Time Zones
- Use Regular Expression Functions
- Control User Access to Database Objects
|
Note: |
|
Exams are not included as part of the course. Before taking any exam, delegates must ensure they have the recommended experience.
|
Topics Covered:
|
- SQL Developer
- Hierarchical Queries
- Enhanced Grouping Extensions and Functions
- TIMESTAMP, TIMEZONE and INTERVAL Datatypes
- TIMESTAMP and INTERVAL Functions and Literals
- POSIX Compliant Regular Expression Notation
- Regular Expression Functions
- Enhanced Subquery Functions
- Multitable Insert Statements
- Merge Rows in a Table
- External Tables
- Flashback Operations
- Control User Access
|
Requirements:
|
|
Delegates should have attended the SQL course or have a similar level of experience.
|
