PL/SQL

Course Description:

This course is designed to give users an understanding of Oracle SQL and Oracle PL/SQL languages using Oracle’s SQL*Plus and iSQL*Plus tools. The course covers SQL commands for DML, DDL, Query, and Transaction Control operations. Students are also introduced to procedural programming using PL/SQL. The course topics are applicable to all versions of Oracle through Oracle 10g.

Course Outline:

Chapter 1: Database Design
Chapter 2: Oracle Standard Interfaces
Chapter 3: The Sample Database
Chapter 4: Data Definition Language
Chapter 5: Data Manipulation Language
Chapter 6: Transaction Control
Chapter 7: SQL Operators
Chapter 8: SQL FUNCTIONS
Chapter 9: Joining Tables
Chapter 10: Set Operators
Chapter 11: SQL Subqueries
Chapter 12: Groups
Chapter 13: More Database Objects
Chapter 14: Reports
Chapter 15: Introduction
Chapter 16: Declarations and Data Types
Chapter 17: Language Components
Chapter 18: Cursors
Chapter 19: Exceptions
Chapter 20: Functions and Procedures