Delegates: |
|
Anyone who needs to use the more advanced features of SQL to improve their productivity in querying and updating an Oracle database. The more advanced topics are covered in this course for the Introduction to Oracle9i: SQL Oracle Certified Professional examination (1Z0-007).
|
Objectives: |
By the end of this course, the delegate will be able to:
- Use iSQLPlus
- Implement ANSI-Compliant Table Joins
- Develop Hierarchical Queries
- Use the ROLLUP, CUBE and GROUPING SETS Group By Extensions
- Use the GROUPING and GROUPING_ID Functions
- Handle DATE, TIMESTAMP and INTERVAL Datatypes and Functions
- Create Queries to Rank Data by Value
- Create Queries to Calculate Percentiles
- Use Reporting and Windowing Aggregate Functions
- Understand Regular Expression Notation
- Use Regular Expression Functions
- Implement CASE Expressions in SQL Statements
- Implement Enhanced Table Handling Features
|
Note: |
|
Before taking any exam, ensure you have the recommended experience.
|
Topics Covered: |
- How to use iSQLPlus
- ANSI-Compliant Inner Joins
- ANSI-Compliant Outer and Self Joins
- Hierarchical Queries
- Enhanced Grouping Extensions and Functions
- TIMESTAMP, TIMEZONE and INTERVAL Datatypes
- TIMESTAMP and INTERVAL Functions and Literals
- Overview of Analytic Functions
- Ranking Data by Value and Percentile
- Providing Cumulative, Moving and Centered Aggregates
- POSIX Compliant Regular Expression Notation
- Regular Expression Functions
- Enhanced Subquery Functions
- CASE Expressions
- Extended Insert and Merge Operations on Tables
- Creating and Using External Tables
|
Requirements:
|
|
Delegates should have attended the SQL course or have a similar level of experience.
|
