IT Corporate Training

Oracle 9i SQL and PL/SQL 

Pre-requisites	Duration : 5 day
No Prior knowlegde of Oracle or any other database product is required for this training

Module 1: Introduction to Oracle as a relational database management syste

Introduction to SQL

Module 2: Creating tables

Data Types Table and column level constraints Inserting, updating and deleting data from tables

Module 3: Retrieving data through SELECT queries

Conditional retrieval Joins between multiple tables Ordering selected data Aggregate functions Arithmetic, character and date functions

Module 4: Nested queries

Transaction processing Set operations: Intersect, Union, Minus

Module 5: Views

Synonyms Sequences

Module 6: Introdcution to PL/SQL

PL/SQL blocks and sections Data types Variables and constants

Module 7: Conditional statements

Looping constructs

Module 8: Cursors

Cursors attributes

Module 9: Oracle objects

Object types Nested tables

Module 10: Database Triggers

Packages :Package specifications and package body Exception handling

Module 11: Stored procedures and functions

Module 12: Brief Introdcution to Oracle Architecture