Introduction to Oracle 9i: SQL Training

Course #:WA1276

Introduction to Oracle 9i: SQL Training

The foundation for all Oracle professionals is the SQL language along with Oracle's SQL*Plus extensions. A detailed consideration of these languages includes such topics as creating and maintaining table definitions in the data dictionary, specifying data types, manipulating tables and developing sophisticated queries quickly and accurately.

Objective

At course completion, students will:

  • Understand the concepts of relational databases.
  • Create and alter table definitions including column data type declarations.
  • Maintain data within tables using INSERT, DELETE and UPDATE statements.
  • Build queries using both basic and advanced SQL techniques.

Audience

All Oracle professionals including developers, database administrators, designers and analysts. 

Prerequisites

A basic understanding of computer programming concepts is helpful

Duration

Three days.

Outline of Introduction to Oracle 9i: SQL Training

1. SQL Data Definition Language

  • create table statement
  • select
  • not null
  • default
  • alter, drop
  • describe, rename

2. Using The Sql*Plus Tool

  • interactive sql with sql*plus
  • graphical sql*plus
  • exit or quit
  • host or $
  • spool
  • start or @
  • list, save, get
  • run or /
  • edit, append, change, del, input

3. SQL Data Manipulation Language

  • about sql dml
  • select, insert
  • insert using select
  • delete, update
  • about transactions
  • rollback, commit, savepoint
  • complex table references

4. Introduction To SQL Queries

  • select
  • distinct
  • alias names

5. Building A Where Clause

  • equality, inequality
  • boolean
  • null and between
  • is [not] null
  • [not] between
  • [not] like
  • in

6. Ordering The Result Table

  • about the order by clause
  • including multiple columns
  • specifying the sort sequence
  • null values and order by
  • sorting by un-selected columns
  • referring to column aliases

7. Pseudo Columns And Functions

  • Working with Joins
  • the pseudo columns
  • rownum, sysdate, user & uid
  • the dual table

8. Joining Tables

  • equi-join
  • reflexive join
  • non key-join
  • outer join

9. Using Set Operators Upon Tables

  • set operator examples
  • union, intersect, minus
  • performing a full outer join

10. About Summary Functions

11. Using Subqueries

12. Creating & Selecting Groups

  • group by example
  • selecting data from the base tables
  • having

13. Creating & Using Views

14. Indexes & Synonyms

15. Understanding The Data Dictionary

  • about the data dictionary
  • query dd: user_tables, user_tab_columns, user_objects

16. Build Simple Sql*Plus Reports

  • about the data dictionary
  • query dd: user_tables, user_tab_columns, user_objects
We regularly offer classes in these and other cities. Atlanta, Austin, Baltimore, Calgary, Chicago, Cleveland, Dallas, Denver, Detroit, Houston, Jacksonville, Miami, Montreal, New York City, Orlando, Ottawa, Philadelphia, Phoenix, Pittsburgh, Seattle, Toronto, Vancouver, Washington DC.