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)

Introduction to 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
February 9-12, 2009
(Start time: 10:00 AM ET)		 $1,695.00
March 2-5, 2009
(Start time: 10:00 AM ET)		 $1,695.00
May 4-7, 2009
(Start time: 10:00 AM ET)		 $1,695.00
You may also register by calling 1-877-932-8228.

Introduction to Oracle SQL Course Overview

The objective of this course is to provide an introduction to the SQL database language within the context of an Oracle database.

Introduction to Oracle SQL Course Goals

  • Learn basic relational database principles
  • Learn to use the iSQL*Plus web-based database interface and other traditional interfaces
  • Learn to write simple SQL queries and moderately complex SQL queries using various join techniques
  • Learn to summarize, group and sort data
  • Learn advanced query techniques such as correlated subqueries
  • Learn to develop simple SQL*Plus reports
  • Learn to create and maintain database tables
  • Learn to insert, update, and delete records from a database

Introduction to Oracle SQL Course Outline

  1. Relational Databases & SQL
    1. About Relational Databases
    2. Elements Of SQL
  2. Using SQL*Plus
    1. About SQL*Plus
    2. Using The Ms Windows SQL*Plus Tool
    3. Using The ISQL*Plus Web Tool
    4. Entering Commands & Syntax
  3. Building A Select Statement
    1. About The Select Statement
    2. Selecting Columns
    3. Using Alias Names
  4. Building A Where Clause
    1. About Logical Operators
    2. Equality Operator
    3. Boolean Operators
    4. Null & Between Operators
    5. Finding Text Strings
    6. In Operator
  5. Ordering The Result Table
    1. About The Order By Clause
    2. Multiple Column Sorts
    3. Specifying The Sort Sequence
    4. About Null Values Within Sorts
    5. Using Column Aliases
  6. Pseudo Columns & Functions
    1. About Pseudo Columns & Functions
    2. Using Rowid
    3. Using Rownum
    4. Using The Functions
    5. Using The Dual Table
    6. Sessiontimezone Function
  7. Joining Tables
    1. About Joins
    2. Inner Join
    3. Reflexive Join
    4. Non-Key Join
    5. Outer Join
  8. Using Set Operators
    1. About The Set Operators
    2. Set Operator Examples
  9. Summary Functions
    1. About Summary Functions
    2. Summary Functions With Distinct
  10. Using Subqueries
    1. About Subqueries
    2. Standard Subqueries
    3. Correlated Subqueries
  11. Creating & Selecting Groups
    1. About Summary Groups
    2. Finding Groups Within The Base Tables
    3. Selecting Data From The Base Tables
    4. Selecting Groups From The Result Table
  12. SQL*Plus Commands
    1. About SQL*Plus Commands
    2. More About Script Files
    3. Invoking Operating System Commands
    4. Saving Session Output
  13. Build Simple SQL*Plus Reports
    1. About The SQL*Plus Report Features
    2. Session Output With Set
    3. Format Column Output With Column
    4. Defining Report Breaks With Break
    5. Produce Subtotals With Compute
  14. SQL Data Definition Language
    1. About SQL DDL
    2. Create Table Statement
    3. Alter Table Statement
    4. Drop Table Statement
    5. Supportive Statements
  15. SQL Data Manipulation Language
    1. About SQL DML
    2. About The Insert Statement
    3. About The Delete Statement
    4. About The Update Statement
    5. About Transactions
    6. Truncate Table
    7. Complex Table References

Introduction to Oracle SQL Course Materials

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

Introduction to 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