Course Outline of course content

Section 1 Fundamentals
  • Introduction to PL/SQL
  • Quiz: Introduction to PL/SQL
  • Benefits of PL/SQL
  • Quiz: Benefits of PL/SQL
  • Creating PL/SQL Blocks
  • Quiz: Creating PL/SQL Blocks
  • Review of SQL Select Statements
  • Quiz: Review of SQL Select Statements
  • Review of SQL Single-Row Functions
  • Quiz: Review of SQL Single-Row Functions
 Section 2 Variables and Datatypes
  • Using Variables in PL/SQL
  • Quiz: Using Variables in PL/SQL
  • Recognizing PL/SQL Lexical Units
  • Quiz: Recognizing PL/SQL Lexical Units
  • Recognizing Data Types
  • Quiz: Recognizing Data Types
  • Using Scalar Data Types
  • Quiz: Using Scalar Data Types
  • Review of SQL Joins
  • Quiz: Review of SQL Joins
  • Review of SQL Group Functions and Subqueries
  • Quiz: Review of SQL Group Functions and Subqueries
  • Writing PL/SQL Executable Statements
  • Quiz: Writing PL/SQL Executable Statements
  • Nested Blocks and Variable Scope
  • Quiz: Nested Blocks and Variable Scope
  • Good Programming Practices
  • Quiz: Good Programming Practices
Section 3 SQL in PL/SQL
  • Review of SQL DML
  • Quiz: Review of SQL DML
  • Retrieving Data in PL/SQL
  • Quiz: Retrieving Data in PL/SQL
  • Manipulating Data in PL/SQL
  • Quiz: Manipulating Data in PL/SQL
  • Using Transaction Control Statements
  • Quiz: Using Transaction Control Statements
Section 4 Program Structure
  • Conditional Control: IF Statements
  • Quiz: Conditional Control: If Statements
  • Conditional Control: Case Statements
  • Quiz: Conditional Control: Case Statements
  • Iterative Control: Basic Loops
  • Quiz: Iterative Control: Basic Loops
  • Iterative Control: While and For Loops
  • Quiz: Iterative Control: While and For Loops
  • Iterative Control: Nested Loops
  • Quiz: Iterative Control: Nested Loops
Section 5 Cursors
  • Introduction to Explicit Cursors
  • Quiz: Introduction to Explicit Cursors
  • Using Explicit Cursor Attributes
  • Quiz: Using Explicit Cursor Attributes
  • Cursor FOR Loops
  • Quiz: Cursor FOR Loops
  • Cursors with Parameters
  • Quiz: Cursors with Parameters
  • Using Cursors for Update
  • Quiz: Using Cursors for Update
  • Using Multiple Cursors
  • Quiz: Using Multiple Cursors
Mid Term Semester 1 Exam Review
Mid Term Semester 1 Exam
Section 6 Exceptions Handling
  • Handling Exceptions
  • Quiz: Handling Exceptions
  • Trapping Oracle Server Exceptions
  • Quiz: Trapping Oracle Server Exceptions
  • Trapping User-Defined Exceptions
  • Quiz: Trapping User-Defined Exceptions
  • Recognizing the Scope of Variables
  • Quiz: Recognizing the Scope of Variables
Section 7 Procedures
  • Creating Procedures
  • Quiz: Creating Procedures
  • Using Parameters in Procedures
  • Quiz: Using Parameters in Procedures
  • Passing Parameters
  • Quiz: Passing Parameters
Section 8 Functions
  • Creating Functions
  • Quiz: Creating Functions
  • Using Functions in SQL Statements
  • Quiz: Using Functions in SQL Statements
  • Review of Data Dictionary
  • Quiz: Review of Data Dictionary
  • Managing Procedures and Functions
  • Quiz: Managing Procedures and Functions
  • Review of Object Privileges
  • Quiz: Review of Object Privileges
  • Using Invoker's Rights
  • Quiz: Using Invoker's Rights
Final Exam Semester 1 Review
 Final Exam Semester 1
 Section 9 Packages
  • Creating Packages
  • Quiz: Creating Packages
  • Managing Package Concepts
  • Quiz: Managing Package Concepts
  • Advanced Package Concepts
  • Quiz: Advanced Package Concepts
  • Persistent State of Package Variables
  • Quiz: Persistent State of Package Variables
  • Using Oracle-Supplied Packages
  • Quiz: Using Oracle-Supplied Packages
  • Dynamic SQL
  • Quiz: Dynamic SQL
 Section 10 Triggers
  • Introduction to Triggers
  •  Quiz: Introduction to Triggers
  • Creating DML Triggers: Part I
  •  Quiz: Creating DML Triggers Part I
  • Creating DML Triggers: Part II
  • Quiz: Creating DML Triggers Part II
  • Creating DDL and Database Event Triggers
  • Quiz: Creating DDL and Database Event Triggers
  • Managing Triggers
  • Quiz: Managing Triggers
 Mid Term Semester 2 Exam Review
 Mid Term Semester 2 Exam
 Section 11 Advanced Data Types
  • Using Large Object Data Types
  •  Quiz: Using Large Object Data Types
  •  Managing Bfiles
  • Quiz: Managing Bfiles
  • User-Defined Records
  • Quiz: User-Defined Records
  • Index By Tables of Records
  •  Quiz: Index By Tables of Records
 Section 12 Dependencies
  • Understanding Dependencies
  • Quiz: Understanding Dependencies
Final Exam Semester 2 Review
Final Exam Semester 2
Certification Preparation

  (course_outline_08.htm)
 last update:  08/10/2008