Oracle Database 10g: Introduction To SQL - Part II Training

Course #:WA1708

Oracle Database 10g: Introduction To SQL - Part II Training

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.

What you will learn

Among the specific subjects discussed in this course are:

  • Learn to use the SQL99 join syntax. Also, 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, such as advanced table definitions, indexes, sequences, views and others.
  • 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.
  • Developing complex SQL*Plus reports and using SQL*Plus scripts.


The target audience for this course is all Oracle professionals. Further, this course is well suited for non-Oracle professionals already experienced in the SQL but who wish to become acquainted with the unique and advanced features of Oracle SQL. Among the specific groups for whom this course will be helpful are application developers and database administrators.




Three days.

Outline of Oracle Database 10g: Introduction To SQL - Part II Training

1. SQL99 join techniques

  • Cross joins
  • Natural joins
  • Inner joins
  • Outer joins
  • Anti joins
  • Using named subqueries

2. Enhancing groups with rollup & cube

3. Using the case expression

4. SQL functions: character

  • What are the SQL functions?
  • Character functions
  • About greatest(), least()

5. SQL functions: numeric

6. SQL functions: date

  • Date format functions
  • Date arithmetic functions

7. Database objects: relational views

  • About relational views
  • Updating view data
  • Maintaining view definitions
  • Alter view
  • Drop view

8. Database objects: data dictionary storage

  • User_updatable_columns
  • Understanding the data dictionary structure

9. Database objects: indexes

  • About indexes
  • Use b-tree indexes

10. Database objects: other objects

  • Creating an application schema
  • More about creating tables
  • Defining sequences
  • Alter sequence & drop sequence
  • Alter sequence
  • Drop sequence
  • About synonyms
  • Drop synonym
  • Create schema authorization

11. Database objects: security

  • User id passwords
  • Object security

12. Data integrity using constraints

  • Not null constraint
  • Check constraint
  • Unique constraint
  • Primary key constraint
  • References constraint

13. Managing constraint definitions

  • Managing constraints
  • Renaming & dropping constraints
  • Enabling & disabling constraints
  • Deferred enforcement
  • Set constraints
  • Handling constraint exceptions
  • Data dictionary storage

14. Optional – advanced SQL*plus reports

  • Break
  • Compute
  • Column
  • Ttitle & btitle

15. Optional – building SQL*plus scripts

  • Using SQL*plus variables
  • Define & undefine
  • Accept
  • Prompt
  • Paus
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.