Take this
course

Software Development / Programming Languages

Oracle 11g PL/SQL Part 1

An introduction to the PL/SQL database programming language.

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: Timothy Miles

Full details

Curriculum

  • Introduction
    Introduction
    3:07
  • Preparing Your Environment
    Course Setup
    37:04
    Course Exercise Files
  • Working with Oracle Database Tools
    Selecting the Appropriate Database Tool
    30:46
  • Language Features
    Understanding PL SQL
    18:00
    PL SQL Blocks
    15:20
    Working with SQL Plus
    11:01
  • The DECLARE Clause
    DECLARE Clause Objects
    16:26
    PL SQL Available Data Types
    16:56
    Declaring Simple Data Types and Assignments
    12:17
    Declaring Complex Data Types and Assignments
    10:39
    Declaring Complex RowTypes and Assignments
    7:03
    Declaring Complex Tables
    7:45
    Declaring Complex Records
    8:13
    Creating and Declaring User-Defined Types
    8:49
  • The BEGIN Clause
    What Can Be Included in the BEGIN Clause
    7:03
    Working with CHAR and VARCHAR2 Variable
    7:31
    Handling String Literals
    7:42
    Working with Numeric Variables
    6:41
    Working with Date Variables
    6:01
    Assigning and Using Boolean Variables
    7:45
    Using Comparison Operators
    7:25
    Using SQL Functions
    6:05
    SQL DML within PL SQL
    15:06
    Using SELECT
    6:33
    Exceptions and Embedded SQL
    11:17
    Using Sequences
    14:29
    Logic Control and Branching
    6:59
    Using GOTO
    5:53
    Working with LOOPS
    18:54
    Creating and Using the Indefinite Loop
    7:00
    Creating and Using the Conditional Loop
    8:49
    Using Nested Loops
    11:34
    Using the If-Then-Else
    18:55
    Using the CASE Statement
    17:44
  • The EXCEPTION Clause
    What Are the Types of Exceptions
    5:32
    Trapping Exceptions
    5:33
    Identify Exception Details
    10:58
    Creating User-Defined Exceptions
    10:50
    Using SQLCODE and SQLERRM Objects
    8:30
    Understand the Implicit Cursor - No Animation
    14:38
    Creating User-Defined Events
    12:27
  • Explicit Cursors
    Understanding the Concept and Purpose of Explicit Cursors
    18:11
    Learn about Cursor Attributes
    10:13
    Using the Continue Statement
    5:45
    Working with Updateable Cursors
    19:26
    Creating and Using Cursor Parameters
    14:46
    FOR...LOOP Cursors
    6:54
  • Nested Blocks
    Understanding Nested Blocks
    10:47
    Understanding the Difference between Global vs Local Objects and Exceptions
    12:36
  • Declared Subprograms
    Subprograms: How They Differ from Nested Blocks
    17:38
  • Conclusion
    Course Recap
    3:53

Skills

  • Structured Query Language (SQL)
  • Oracle

Similar Courses

More Courses by this Instructor