Advanced Oracle SQL Training on Oracle 11g

Delivery Options

• Live eLearning (4 days): $2,100.00

» Free Demo

» Watch Presentation

» Contact Education Consultant

• Customized Onsite Training (3 days): Request a Proposal

Upcoming Live eLearning Classes

There are currently no upcoming Live eLearning classes. Please contact us if you would like us to schedule a class.

Class Description

Class Overview

Class Goals

• Learn to use the SQL99 join syntax. Also, performing advanced SQL queries using techniques such as grouping and cube operations.
• Move beyond basic table definitions, consideration of defining the full range of database objects, such as advanced table definitions, indexes, sequences, views and others.
• Understand basic database security and object privileges.
• Learn to use the powerful set of built-in SQL functions.
• Learn to protect the database and extending the basic data model using declarative constraints.
• Learn to develop complex SQL*Plus reports and using SQL*Plus scripts.

Class Outline

1. SQL99 Join Techniques
   1. About Ansi/Iso SQL99
   2. Cross Joins
   3. Natural Joins
   4. Inner Joins
   5. Outer Joins
   6. Antijoins
   7. Using Named Subqueries
2. Enhancing Groups With Rollup & Cube
   1. About Enhanced Group Processing
   2. Using Rollup
   3. Using Cube
3. Using The Case Expression
4. SQL Functions (Character)
   1. What Are The SQL Functions?
   2. Character Functions
5. SQL Functions (Non-Character)
   1. Numeric Functions
   2. Date Format Functions
   3. Date Arithmetic Functions
   4. Null Value Functions
6. Database Objects: Relational Views
   1. About Database Objects
   2. About Relational Views
   3. Updating View Data
   4. Maintaining View Definitions
7. Database Objects: Data Dictionary Storage
   1. About The Data Dictionary
   2. Object-Specific Dictionary Views
   3. Understanding The Data Dictionary Structure
8. Database Objects: Indexes
9. Database Objects: Other Objects
   1. Creating An Application Schema
   2. More About Creating Tables
   3. Defining Sequences
   4. About Synonyms
   5. Create Schema Authorization
10. Database Security
    1. About Database Security
    2. User Id Passwords
    3. Object Security
11. Data Integrity Using Constraints
    1. About Constraints
    2. Not Null Constraint
    3. Check Constraint
    4. Unique Constraint
    5. Primary Key Constraint
    6. References Constraint
    7. Defining Constraints On Existing Tables
12. Maintaining Constraint Definitions
    1. Maintaining Constraints
    2. Renaming & Dropping Constraints
    3. Enabling & Disabling Constraints
    4. Validate New Transactions Only
    5. Deferred Enforcement
    6. Managing Constraint Exceptions
    7. Constraints And Views
    8. Data Dictionary Storage
13. Advanced SQL*Plus Reports
    1. About The Report Commands
    2. Break
    3. Compute
    4. Column
    5. Ttitle & Btitle
14. Building SQL*Plus Scripts
    1. About Script Files
    2. Using SQL*Plus Variables
    3. Accept
    4. Prompt
    5. Pause
15. Advanced SQL & SQL*Plus Features

Class Materials

All students receive a course manual or book and all the class examples.

Students in private onsite classes will also receive:

• Technical Reference Library

Class Prerequisites

Experience in the following areas is required:

• Experience with Oracle SQL as taught in our Introduction to Oracle SQL course

Technical Requirements

Our computer technical requirements and setup process is easy, with support just a click away.

• Course technical requirements and setup instructions.