back to Course Categories | back | print
Introduction to Oracle9iR2: SQL and PL/SQL          

Duration: 5 days

Description 
This class will develop Oracle9i database programming skills using SQL and PL/SQL. Students will learn the Oracle9i architecture, simple and complex query skills, ANSI SQL features and basic PL/SQL programming skills. This class is intended for analysts, developers, designers, administrators and managers new to Oracle9i or database programming. This class will prepare you for the Introduction to Oracle: SQL and PL/SQL certification test (#1Z0-001).

Topics

  • Review relational concepts
  • The Oracle9i architecture and data dictionary
  • Relational versus object-relational features
  • DML statements
  • CROSS, NATURAL, INNER and OUTER join syntax
  • Object-relational features
  • Set operators
  • Oracle9i tables and views
  • DROP, RENAME and TRUNCATE commands
  • Joins and sub-queries
  • Creating, using and managing views
  • Limiting and sorting data
  • Using ROLLUP and CUBE with GROUP BY for subtotals and cross-tab totals
  • The GROUPING SETS and GROUPING functions
  • The WITH clause
  • Sequences
  • Synonyms
  • Oracle9i Built-in functions
  • Privileges, roles and user access control
  • SQL*Plus
  • Inline views
  • Using scripts to generate scripts
  • Top N Analysis
  • PL/SQL fundamentals
  • Cursors
  • Handling exceptions
  • Stored procedures and functions

Prerequisites

  • Relational database design and 3GL programming experience.


 
 
 

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