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
