Training

 

 

Popular Courses

Browse Our Free Resources

  • whitepapers
  • whitepapers
  • webinars
  • blogs

Our Locations

Training Centres

Vancouver, BC
Calgary, AB
Edmonton, AB
Toronto, ON
Ottawa, ON
Montreal, QC
Hunt Valley
Columbia

locations map

Calgary

550 6th Av SW
Suite 475
Calgary, AB
T2P 0S2

Toronto

821A Bloor Street West
Toronto, ON
M6G 1M1

Vancouver

409 Granville St
Suite 902
Vancouver, BC
V6C 1T2

U.S. Office

436 York Road
Suite 1
Jenkintown, PA
19046

Other Locations

Dallas, TX
Miami, FL

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

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

Course#: WA1708

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.

Audience

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.

Prerequisites

None

Duration

Three days.

Outline of WA1708 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.
*Your name:

*Your e-mail:

*Phone:

*Company name:

Additional notes:

We have received your message. A sales representative will contact you soon.

Thank you!.

more details
buy this course

Register for a courseware sample

It's simple, and free.

 

Thank You!

You will receive an email shortly containing a link to download the requested sample of the labs for this course.