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 9i > Introduction to Oracle 9i: SQL Training

Introduction to Oracle 9i: SQL Training

Course#: WA1276

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 WA1276 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.
*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
Other Details

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.