Course Description
The primary objective of this Oracle 11g training course is to provide an introduction to the PL/SQL database programming language covering syntax, structure and features of the language within the context of database applications, and programming.This Oracle 11g course will prepare students for the Oracle certification exams (OCP).
Instructor: Tim Miles
What am I going to get from this course?
- Prepare your environment
- Work with Oracle database tools
- Understand and work with language features
- Work with the DECLARE clause
- Work with the BEGIN clause
- Work with the EXCEPTION clause
- Use explicit cursors
- Understand and use nested blocks
- Understand the difference between nested blocks and subprograms
Prerequisites and Target Audience
What will students need to know or do before starting this course?
Familiarity with database and programming principles
Who should take this course? Who should not?
- Application designers and developers
- Database administrators
- Business users and non-technical senior end users
Curriculum
Module 1: Preparing Your Environment
Lecture 1
Preparing Your Environment
Resource 1
Student Data Files
Module 2: Preparing Your Environment
Module 3: Working with Oracle Database Tools
Lecture 3
Selecting the Appropriate Database Tool
Module 4: Language Features
Lecture 4
Understanding PL SQL
Lecture 6
Working with SQL Plus
Module 5: The DECLARE Clause
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
Module 6: The BEGIN Clause
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 SQL
Lecture 25
Exceptions and Embedded SQL
Lecture 26
Using Sequences
Lecture 27
Logic Control and Branching
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
Module 7: The EXCEPTION Clause
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
Module 8: Explicit Cursors
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
Module 10: Declared Subprograms
Lecture 50
What Are Subprograms and How Are They Different from Nested Blocks
