Take this
course

Software Development / Programming Languages

Oracle PL/SQL Fundamentals Vol. I & II

In this Oracle 11g PL/SQL Bundle you will receive introduction training on the PL/SQL database programming language. This Oracle 11g course will prepare students for the Oracle certification exams (OCP).

Description

In this Oracle 11g PL/SQL Bundle you will receive introduction training on PL/SQL database programming language covering syntax, structure and features of the language within the context of database applications and programming. In volume II students will dive into topics such as understanding the basic form and structure of program units stored within the database, building and maintaining stored procedures, functions, packaged programs, and database triggers. Additional topics include taking advantage of advanced programming techniques such as cursor variables and cursor expressions. This Oracle 11g course will prepare students for the Oracle certification exams (OCP). 


 Instructor: Timothy Miles 

Full details

Curriculum

  • Introduction Vol. I
    Introduction
    3:07
  • Preparing Your Environment
    Course Setup
    37:04
    Vol. I Data 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 Variables
    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
    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
    What Are Subprograms and How Are They Different from Nested Blocks
    17:38
  • Vol I. Conclusion
    Vol. I Course Recap
    3:53
  • Introduction Vol. II
    Introduction
    2:41
    Vol. II Data Files
  • Preparing Your Environment
    Install Oracle XE
    11:00
    SQL Developer Installation
    19:48
  • Database Program Units
    Introducing the Database Program Unit
    19:06
  • Working with Stored Procedures and Functions
    Creating Stored Procedures and Functions
    18:45
    Understanding the Parameter Specification
    22:58
    Executing Procedures and Functions
    26:12
    Calling Functions from within SQL
    13:06
    Handling Compilation Errors - No Animation
    8:20
  • Maintaining Stored Procedures and Functions
    Recompiling and Dropping Programs
    16:07
    Data Dictionary Storage
    24:48
    Managing Dependencies
    12:53
    Tracking Dependencies
    8:26
    Using the Dependency Tracking Utility
    9:26
  • Creating and Maintaining Packages
    What Is a Package
    10:03
    Creating a Package
    19:05
    Package Definition Information
    7:53
    Advanced Programming Techniques
    6:07
    Using Persistent Global Objects
    3:37
    Including Initialization Logic
    15:18
    Object Oriented Support within Packages
    13:45
    Package Maintenance
    17:48
  • Advanced Cursor Techniques
    Learning to Use Cursor Variables
    23:39
    Weak Cursor Definitions
    16:11
    REFCURSOR Cursor Definition
    5:07
    Using Cursor Expressions
    13:37
  • Using System Supplied Packages
    Using the DBMS OUTPUT () Package
    11:39
    Using the UTL_FILE() Package
    29:30
  • Creating Database Triggers
    Understanding the Database Trigger
    23:19
    Statement-Level Triggers
    22:36
    Row-Level Triggers
    12:05
    Row Level Trigger Example 1
    11:09
    Row Level Trigger Example 2
    7:25
    Row Level Trigger Example 3
    7:36
    Working with the INSTEAD OF Trigger
    10:54
    Using Triggers within an Application
    8:48
  • Trigger Maintenance
    Using the CALL Statement
    9:09
    Trigger Maintenance Tasks
    12:16
    Working with Multiple Triggers for a Single Table
    10:47
    Handling Mutating Table Issues
    22:10
    Using the Compound Trigger
    5:35
  • Working with System Event Triggers
    What Is a System Event Trigger
    5:26
    Defining Scope
    3:37
    Identifying Available System Events
    12:13
  • Conclusion Vol. II
    Course Recap
    1:32

Skills

  • Oracle
  • Structured Query Language (SQL)

Similar Courses

More Courses by this Instructor