Oracle Database SQL – Advanced

3 day course

The purpose of this course is to consider advanced subjects and techniques pertaining to the SQL database language. Even professionals experienced in other implementations of the industry-standard SQL language will benefit from the advanced and Oracle-specific features of SQL discussed in this course. Topics covered include learning to use the SQL99 join syntax, performing advanced SQL queries using techniques such as grouping and cube operations, moving beyond basic table definitions, consideration of defining the full range of database objects, understanding basic database security and object privileges, using the powerful set of built-in SQL functions, protecting the database and extending the basic data model using declarative constraints, and developing complex SQL*Plus reports and using SQL*Plus scripts.

Overview of Course Topics:
(for a full detailed outline, visit our PDF link above)

• SQL99 Join Techniques
• Enhancing Groups with ROLLUP & CUBE
• Using the CASE Expression
• SQL Functions: Numeric
• SQL Functions: Date
• Database Objects: Relational Views
• Database Objects: Data dictionary Storage
• Database Objects: Indexes
• Database Objects: Other Objects
• Database Objects: Security
• Data Integrity Using Constraints
• Managing Constraint Definitions
• Advanced SQL*Plus Reports
• Building SQL*Plus Scripts