back to Course Categories | back | print
Oracle9iR2: SQL Programming          

Duration: 5 days

Description 
This class will develop database-programming skills using SQL. Relational and Object concepts will be covered. Students will learn complex SQL programming skills in Oracle9i. Oracle9i database features and tools will be introduced to students. This course will prepare you for the Introduction to Oracle9i: SQL Programming certification test(#1Z0-007).

Topics

  • Oracle data types
  • Using the data dictionary
  • DML statements
  • Transactions
  • The UNION, INTERSECT, and MINUS operators
  • SAMPLE clause, GROUPING function, CUBE and ROLLUP operators
  • Introduction to Analytical functions
  • The WITH clause
  • Complex data retrieval using equi-joins, Cartesian-joins, self-joins, outer-joins, subqueries, correlated subqueries, hierarchical and tree-structured queries
  • Oracle character, date, numeric and conversion functions
  • SQL*Plus application and report writing using parameters, substitution variables, calculations, groups, breaks, summaries, headers and footers, Web reports
  • Schema objects
  • Constraints
  • ANSI SQL features
  • Multi-table INSERT statement
  • Merge statement
  • Object-relational types
  • Globalization
  • Rule and Cost based optimization concepts
  • The basics of performance tuning skills using Explain Plan and Autotrace.
  • Using SQL to generate SQL
  • Using iSQL*Plus

Prerequisites

  • A background in data processing, relational database concepts and programming is strongly recommended.


 
 
 

Trubix Inc. P.O. Box 2235 Littleton, CO 80161 | 1.866.4-TRUBIX • 303.730.6800
email: info@trubix.com
....................................................................................................................................................................

Training Service | Consulting / Mentoring | Public Schedule | Course Listings | Tru iLearning | About Us | Contact Us
Oracle DBA Classes | Oracle Dev Classes | Oracle App Server Classes | Linux / Unix Classes
SQL Server / .NET / Tools / DB2 Classes / Public Classes

 

 
all content property © 2006, 2007Trubix Inc.| site design by Art Z design