Oracle PL/SQL Fundamentals & Database Design–3course bundle

Course Curriculum

Chapter 1: Oracle 11g PL/SQL Fundamentals I

Lecture 1: Introduction

Lecture 2: Course Setup

Lecture 3: Selecting the Appropriate Database Tool

Lecture 4: Understanding PL SQL1

Lecture 5: PL SQL Blocks

Lecture 6: Working with SQL Plus

Lecture 7: DECLARE Clause Objects

Lecture 8: PL SQL Available Data Types

Lecture 9: Declaring Simple Data Types and Assignments

Lecture 10: Declaring Complex Data Types and Assignments

Lecture 11: Declaring Complex RowTypes and Assignments

Lecture 12: Declaring Complex Tables

Lecture 13: Declaring Complex Records

Lecture 14: Creating and Declaring User-Defined Types

Lecture 15: What Can Be Included in the BEGIN Clause

Lecture 16: Working with CHAR and VARCHAR2 Variables

Lecture 17: Handling String Literals

Lecture 18: Working with Numeric Variables

Lecture 19: Working with Date Variables

Lecture 20: Assigning and Using Boolean Variables

Lecture 21: Using Comparison Operators

Lecture 22: Using SQL Functions

Lecture 23: SQL DML within PL SQL1

Lecture 24: Using SELECT

Lecture 25: Exceptions and Embedded SQL

Lecture 26: Using Sequences

Lecture 27: Logic Control and Branching

Lecture 28: Using GOTO

Lecture 29: Working with LOOPS

Lecture 30: Creating and Using the Indefinite Loop

Lecture 31: Creating and Using the Conditional Loop

Lecture 32: Using Nested Loops

Lecture 33: Using the If-Then-Else

Lecture 34: Using the CASE Statement

Lecture 35: What Are the Types of Exceptions

Lecture 36: Trapping Exceptions

Lecture 37: Identify Exception Details

Lecture 38: Creating User-Defined Exceptions

Lecture 39: Using SQLCODE and SQLERRM Objects

Lecture 40: Understand the Implicit Cursor

Lecture 41: Creating User-Defined Events

Lecture 42: Understanding the Concept and Purpose of Explicit Cursors

Lecture 43: Learn about Cursor Attributes

Lecture 44: Using the Continue Statement

Lecture 45: Working with Updateable Cursors

Lecture 46: Creating and Using Cursor Parameters

Lecture 47: FOR…LOOP Cursors

Lecture 48: Understanding Nested Blocks

Lecture 49: Understanding the Difference between Global vs Local Objects and Exceptions

Lecture 50: What Are Subprograms and How Are They Different from Nested Blocks

Lecture 51: Course Recap

Chapter 2: Oracle 11g PL/SQL Fundamentals II

Lecture 1: Introduction

Lecture 2: Installing Oracle XE1

Lecture 3: SQL Developer Installation

Lecture 4: Workstation Setup

Lecture 5: Introducing the Database Program Unit

Lecture 6: Creating Stored Procedures and Functions

Lecture 7: Understanding the Parameter Specification

Lecture 8: Executing Procedures and Functions

Lecture 9: Calling Functions from within SQL

Lecture 10: Handling Compilation Errors

Lecture 11: Recompiling and Dropping Programs

Lecture 12: Data Dictionary Storage

Lecture 13: Managing Dependencies

Lecture 14: Tracking Dependencies

Lecture 15: Using the Dependency Tracking Utility

Lecture 16: What is a Package?

Lecture 17: Creating a Package

Lecture 18: Package Definition Information

Lecture 19: Advanced Programming Techniques

Lecture 20: Using Persistent Global Objects

Lecture 21: Including Initialization Logic

Lecture 22: Object Oriented Support within Packages

Lecture 23: Package Maintenance

Lecture 24: Learning to Use Cursor Variables

Lecture 25: Weak Cursor Definitions

Lecture 26: REFCURSOR Cursor Definition

Lecture 27: Using Cursor Expressions

Lecture 28: Using the DBMS OUTPUT () Packages

Lecture 29: Using the UTL_FILE() Package

Lecture 30: Understanding the Database Trigger

Lecture 31: Statement-Level Triggers

Lecture 32: Row-Level Triggers

Lecture 33: Row Level Trigger Example

Lecture 34: Row Level Trigger Example

Lecture 35: Row Level Trigger Example

Lecture 36: Working with the INSTEAD OF Trigger

Lecture 37: Using Triggers within an Application

Lecture 38: Using the CALL Statement

Lecture 39: Trigger Maintenance Tasks

Lecture 40: Working with Multiple Triggers for a Single Table

Lecture 41: Handling Mutating Table Issues

Lecture 42: Using the Compound Trigger

Lecture 43: What is a System Event Trigger?

Lecture 44: Defining Scope

Lecture 45: Identifying Available System Events

Lecture 46: Conclusion

Chapter 3: Database Design Introduction