Print this Page

Introduction to Oracle

Abstract
(5 Days)

This course offers a thorough introduction to the Oracle Database Management system.  This includes adhoc, interactive database manipulations, data definition and programming.  Upon completion of the course, students will be able to make efficient use of the Oracle Database system.

Audience

This course is intended for application programmers.  No previous database knowledge is expected.

Topics

• Basic relational database principles

• Components of Oracle

• Oracle datatypes and functions

• Interactive access via SQL*PLUS

• SQL as a Data Manipulation Language

  • SELECT clauses

  • FROM clauses

  • WHERE clauses

  • NULLs

  • ORDER BY clauses

  • EXISTS

  • ANY/ALL

  • Outer joins

  • Column functions

  • GROUP BY clauses

  • HAVING clauses

  • Hierarchical SELECTs

  • UNION, MINUS and INTERSECT

  • INSERT

  • UPDATE

  • DELETE

• SQL as a Data Manipulation Language - table, index and view definition, modification and deletion

• Referential Integrity

• Oracle system tables

• transaction processing under Oracle - COMMIT and ROLLBACK

• Locking in Oracle

• Security and authorization principles

• Embedding SQL in application programs

• Implementing cursors in application programs

• PL/SQL programming

• Triggers

• Stored procedures

• Loading data via SQL*Loader

Supervised Exercises

Each 1/2-day class session will be accompanied by exercises to reinforce the classroom material.  This will include SQL exercises, small application programs and PL/SQL programs.