Oracle 11g PL/SQL Fundamentals I

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Chapter 2: Preparing Your Environment

Lecture 1: Course Setup

Chapter 3: Working with Oracle Database Tools

Lecture 1: Selecting the Appropriate Database Tool

Chapter 4: Language Features

Lecture 1: Understanding PL/SQL

Lecture 2: PL/SQL Blocks

Lecture 3: Working with SQL Plus

Chapter 5: The DECLARE Clause

Lecture 1: DECLARE Clause Objects

Lecture 2: PL/SQL Available Data Types

Lecture 3: Declaring Simple Data Types and Assignments

Lecture 4: Declaring Complex Data Types and Assignments

Lecture 5: Declaring Complex RowTypes and Assignments

Lecture 6: Declaring Complex Tables

Lecture 7: Declaring Complex Records

Lecture 8: Creating and Declaring User-Defined Types

Chapter 6: The BEGIN Clause

Lecture 1: What Can Be Included in the BEGIN Clause

Lecture 2: Working with CHAR and VARCHAR2 Variables

Lecture 3: Handling String Literals

Lecture 4: Working with Numeric Variables

Lecture 5: Working with Date Variables

Lecture 6: Assigning and Using Boolean Variables

Lecture 7: Using Comparison Operators

Lecture 8: Using SQL Functions

Lecture 9: SQL DML within PL/SQL

Lecture 10: Using SELECT

Lecture 11: Exceptions and Embedded SQL

Lecture 12: Using Sequences

Lecture 13: Logic Control and Branching

Lecture 14: Using GOTO

Lecture 15: Working with LOOPS

Lecture 16: Creating and Using the Indefinite Loop

Lecture 17: Creating and Using the Conditional Loop

Lecture 18: Using Nested Loops

Lecture 19: Using the If-Then-Else

Lecture 20: Using the CASE Statement

Chapter 7: The EXCEPTION Clause

Lecture 1: What Are the Types of Exceptions

Lecture 2: Trapping Exceptions

Lecture 3: Identify Exception Details

Lecture 4: Creating User-Defined Exceptions

Lecture 5: Using SQLCODE and SQLERRM Objects

Lecture 6: Understand the Implicit Cursor

Lecture 7: Creating User-Defined Events

Chapter 8: Explicit Cursors

Lecture 1: Understanding the Concept and Purpose of Explicit Cursors

Lecture 2: Learn about Cursor Attributes

Lecture 3: Using the Continue Statement

Lecture 4: Working with Updateable Cursors

Lecture 5: Creating and Using Cursor Parameters

Lecture 6: FOR…LOOP Cursors

Chapter 9: Nested Blocks

Lecture 1: Understanding Nested Blocks

Lecture 2: Difference between Global vs Local Objects and Exceptions

Chapter 10: Declared Subprograms

Lecture 1: Subprograms: How They Differ from Nested Blocks

Chapter 11: Conclusion

Lecture 1: Conclusion