1-877-WEBUCATE
(1-877-932-8228)
info@webucator.com
 
Microsoft Training
Java Training
XML Training
Database & SQL Training
PHP, Perl, ASP, Groovy, Grails, Ruby on Rails Training
HTML, JavaScript, Ajax & CSS Training
Adobe Training
◊ PUBLIC ORACLE TRAINING
Watch a 3-minute presentation
on our live instructor-led
online classes

How about taking a class directly from your home or office with a live instructor?
When you register for one of our instructor-led online Oracle classes, we send you a computer headset, the courseware for class, and some other goodies. At the time of class, you simply put your headset on and log in to our web conferencing software. You can hear everything the instructor says, see the complete presentation, and ask questions at any time. Classes are small, generally 2-6 students, full of hands-on exercises, and are never cancelled due to low enrollment.

To have someone contact you about our instructor-led online classes, please fill out the form below. We will also email you a class schedule and pricing.

* (Required)
* (Required)
* (Required)
* (Required)
* (Required)
(The number of people requiring training)
* (Required)
(For Federal Government Pricing)

Advanced Oracle SQL Training on Oracle 10g (4 days)


Classes for individuals are delivered via the Web by a Webucator instructor over a live web conference. For more information on how these classes are delivered click here or call us toll free at 877-932-8228.

Click here for our private onsite Oracle classes

Date Range Price Register
January 12-15, 2009
(Start time: 10:00 AM ET)
$1,695.00
February 9-12, 2009
(Start time: 10:00 AM ET)
$1,695.00
March 9-12, 2009
(Start time: 10:00 AM ET)
$1,695.00
May 11-14, 2009
(Start time: 10:00 AM ET)
$1,695.00
You may also register by calling 1-877-932-8228.

Advanced Oracle SQL Course Overview

The primary objective 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.

Advanced Oracle SQL Course 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.

Advanced Oracle SQL Course Prerequisites

Experience in the following areas is required:

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

Advanced Oracle SQL Course 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

Advanced Oracle SQL Course Materials

Each student will receive a comprehensive set of materials, including course notes and all the programming examples.

Advanced Oracle SQL Course Technical Requirements and Setup Instructions

Click here for technical requirements and setup instructions

home - onsite classes - instructor-led online courses - self-paced online courses - why webucator - partners - contact - sitemap
© 2009 Webucator. All rights reserved. info@webucator.com | Toll Free: 877-WEBUCATE (877-932-8228) | From Outside the USA: 315-849-2724 | Fax: 315-410-5320
Phoenix, AZ | Santa Clara, CA | Santa Clara, CA | Los Angeles, CA | Sacramento, CA | Washington, DC | Atlanta, GA | Chicago, IL | Indianapolis, IN | Muncie, IN
New Orleans, LA Boston, MA | Cambridge, MA | Charlestown, MA | Framingham, MA | Ipswich, MA | Lincoln, MA | Wellesley, MA | Worcester, MA | Bangor, ME | Detroit, MI
Raleigh, NC Winston-Salem, NC | Lincoln, NE | East Hanover, NJ | Eatontown, NJ | Madison, NJ | Parsippany, NJ | Trenton, NJ | Albany, NY | Buffalo, NY | Rochester, NY
New York City, NY | Syracuse, NY | West Babylon, NY | Dayton, OH | Bethlehem, PA | Philadelphia, PA | Pittsburgh, PA | Pittsburgh, PA | State College, PA
Middletown, RI | Rapid City, SD | Austin, TX | Dallas, TX | Houston, TX | Arlington, VA | McLean, VA | Seattle, WA | Toronto, Canada | Ottawa, Canada | Calgary, CA