Industry recognized certification enables you to add this credential to your resume upon completion of all courses

Need Custom Training for Your Team?
Get Quote
Call Us

Toll Free (844) 397-3739

Inquire About This Course
Intellezy Trainers, Instructor - Oracle 11g PL/SQL Part 1

Intellezy Trainers

Improving individual or company performance begins with the right training resources. Keep your team’s Microsoft and Adobe skills fresh with our engaging, short-segment videos. Intellezy’s training is delivered by certified instructors and industry experts. Their friendly, engaging style breaks down complex ideas into bite-sized learning nuggets. And, because they never leave the screen, the learner’s attention is held longer. Start watching and find out how valuable 3 minutes can be.

An introduction to the PL/SQL database programming language

  • Prepare your environment.
  • Work with Oracle database tools.
  • Understand and work with language features.

Duration: 9h 40m

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


Module 1: Preparing Your Environment

Lecture 1 Preparing Your Environment
Resource 1 Student Data Files

Module 2: Preparing Your Environment

Lecture 2 Course Setup

Module 3: Working with Oracle Database Tools

Lecture 3 Selecting the Appropriate Database Tool

Module 4: Language Features

Lecture 4 Understanding PL SQL
Lecture 5 PL SQL Blocks1
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 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

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

Module 9: Nested Blocks

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

Module 11: Conclusion

Lecture 51 Course Recap