1z0-149: Oracle Database Program with PL/SQL

1z0-149: Oracle Database Program with PL/SQL

Get ready for your exam by enrolling in our comprehensive training course. This course includes a full set of instructional videos designed to equip you with in-depth knowledge essential for passing the certification exam with flying colors.

$14.99 / $24.99

What is PL/SQL ?

  • 1. What is PL/SQL and Why to Use?
    6m
  • 2. PL/SQL Architecture
    10m

Software Installation

  • 1. Which Option to Choose to Have a Database?
    9m
  • 2. Option 1: Having the Database with the Oracle Virtual Box
    16m
  • 3. What is Pluggable Database?
    3m
  • 4. Option 2: Downloading and Installing the Oracle Database
    18m
  • 5. Option 2: Unlocking the HR Schema
    8m
  • 6. Option 2: Configuring and Using the SQL Developer
    22m
  • 7. Option 3: Using Oracle Live SQL
    8m

Let's Start Coding!..

  • 1. Anonymous Blocks
    14m
  • 2. PL/SQL Outputs
    8m

PL/SQL Variables

  • 1. What are Variables and Why to Use Them?
    9m
  • 2. Naming Rules & Naming Conventions
    4m
  • 3. Declaring & Initializing & Using Variables - Part 1
    11m
  • 4. Declaring & Initializing & Using Variables - Part 2
    10m
  • 5. Using %TYPE Attribute
    7m
  • 6. PL/SQL Delimiters and Commenting Your Code
    6m
  • 7. PL SQL Variable Scope
    11m
  • 8. Using Bind Variables
    11m

Control Structures

  • 1. What are Control Structures & IF Statements
    14m
  • 2. Case Expressions
    15m
  • 3. What are Loops - Basic Loops
    10m
  • 4. While Loops
    6m
  • 5. For Loops
    10m
  • 6. Nested Loops & Loop Labeling
    16m
  • 7. Continue Statement
    10m
  • 8. GOTO Statement
    14m

Using SQL in PL/SQL

  • 1. Operating with Selected Database Data..
    18m
  • 2. DML Operations in PL/SQL
    13m
  • 3. Using Sequences in PL/SQL
    13m
  • 4. Bonus - Enabling Server Outputs by Default.
    5m

Composite Data Types

  • 1. Simple Data Types vs Composite Data Types
    8m
  • 2. PL/SQL Records - Part 1
    17m
  • 3. PL/SQL Records - Part 2
    17m
  • 4. Easy DML With Records
    8m
  • 5. What Are Collections?
    6m
  • 6. Varrays & Collection Methods
    23m
  • 7. Nested Tables
    11m
  • 8. PL&SQL Associative Arrays (Part 1)
    19m
  • 9. PL&SQL Associative Arrays (Part 2)
    15m
  • 10. Storing Collections in Tables - (Part 1)
    14m
  • 11. Storing Collections in Tables - (Part 2)
    11m

PL/SQL Cursors

  • 1. What are Cursors and Cursor Types in PL SQL?
    8m
  • 2. Using Explicit Cursors
    11m
  • 3. Using Cursors with Records
    6m
  • 4. Looping with Cursors
    12m
  • 5. PL SQL Cursors with Parameters
    14m
  • 6. PL SQL Cursor Attributes
    8m
  • 7. For Update Clause
    21m
  • 8. Where Current Of Clause
    10m
  • 9. Reference Cursors
    24m

PL/SQL Exceptions

  • 1. What are the Exceptions?
    9m
  • 2. Handling the Exceptions!
    18m
  • 3. Handling the Nonpredefined Exceptions
    6m
  • 4. Handling & Raising User-Defined Exceptions
    8m
  • 5. Using RAISE_APPLICATION_ERROR() Procedure
    8m

PL/SQL Functions & Procedures

  • 1. What are Functions & Procedures and Why We Use?
    9m
  • 2. Creating and Using Stored Procedures
    17m
  • 3. Using IN & OUT Parameters
    15m
  • 4. Named & Mixed Notations and Default Option
    16m
  • 5. Creating and Using Functions (Part 1)
    17m
  • 6. Creating and Using Functions (Part 2)
    7m
  • 7. Local Subprograms
    15m
  • 8. Overloading the Subprograms
    13m
  • 9. Handling the Exceptions in Subprograms
    20m
  • 10. Finding & Removing the Subprograms
    11m
  • 11. Regular & Pipelined Table Functions
    20m

PL/SQL Packages

  • 1. What Are Packages?
    10m
  • 2. Creating & Using & Modifying & Removing the Packages
    27m
  • 3. Visibility of Package Objects
    11m
  • 4. Illegal Object Reference & Forward Declaration
    7m
  • 5. Package Initialization
    9m
  • 6. Persistent State of Packages - Part 1
    19m
  • 7. Persistent State of Packages - Part 2
    14m
  • 8. Using Collections in Packages - Part 1
    26m
  • 9. How Can I Find the Packages?
    7m

PL/SQL Triggers

  • 1. What are Triggers & Trigger Types
    10m
  • 2. Understanding DML Triggers
    11m
  • 3. Specifying the Timing of Triggers
    19m
  • 4. Statement & Row Level Triggers
    13m
  • 5. Using New & Old Qualifiers in Triggers
    19m
  • 6. Using Conditional Predicates
    10m
  • 7. Using RAISE_APPLICATION_ERROR Procedure in Triggers
    6m
  • 8. Using Update Of Event in Triggers
    6m
  • 9. Using WHEN Clause in Triggers
    7m
  • 10. INSTEAD OF Triggers
    20m
  • 11. Exploring & Managing the Triggers
    8m
  • 12. Creating Disabled Triggers
    5m
  • 13. Additional Real-World Examples for DML Triggers
    21m
  • 14. Compound Triggers
    28m
  • 15. Handling Mutating Table Errors
    20m

PL/SQL Debugging: Debugging Your Codes & Subprograms

  • 1. PL/SQL Debugging: Debugging Your Subprograms - (Part 1)
    11m
  • 2. PL/SQL Debugging: Debugging Your Subprograms - (Part 2)
    11m
  • 3. PL/SQL Debugging: Debugging Your Subprograms - (Part 3)
    9m
  • 4. PL/SQL Debugging: Debugging the Anonymous Blocks
    6m

Using Dynamic SQL & PL/SQL

  • 1. Introduction to Dynamic SQL and Dynamic PL/SQL
    13m
  • 2. Native Dynamic SQL, PL/SQL
    11m
  • 3. EXECUTE IMMEDIATE Statement
    11m
  • 4. EXECUTE IMMEDIATE STATEMENT with the USING Clause
    15m
  • 5. EXECUTE IMMEDIATE STATEMENT with the USING and INTO Clauses
    13m
  • 6. EXECUTE IMMMEDIATE with BULK COLLECT INTO Clause
    6m
  • 7. Dynamic PL/SQL Blocks
    12m
  • 8. OPEN - FOR, FETCH Statements
    7m
  • 9. Using the DMBS_SQL Package (The Method 4)
    24m

Using Oracle-Supplied Packages

  • 1. Using the DBMS_OUTPUT Package
    14m
  • 2. Using the UTL_FILE Package (Part 1)
    16m
  • 3. Using the UTL_FILE Package (Part 2)
    18m
  • 4. Using the UTL_FILE Package (Part 3)
    12m
  • 5. Using the UTL_MAIL Package (Part 1)
    13m
  • 6. Using the UTL_MAIL Package (Part 2)
    14m