Certification training

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

Prepare for your Oracle exam with a structured video course built for focused study, topic review, and repeatable progress before exam day.

110Lectures
22h 56mDuration
OracleVendor
1z0-149: Oracle Database Program with PL/SQL course cover Best seller
Oracle certification training 1z0-149 110 lessons arranged in a guided course path
Course overview

Study with a clear path.

Move through focused sections, review lecture timing, and return directly to the objectives that need more work.

Sequenced lessons

Follow the course in order or jump directly to the section you need to revisit.

Video-first prep

Use concise lecture blocks for technical review before moving into exam practice.

Fast access

Your purchased course becomes available in the member area after confirmed payment.

Curriculum

Course sections.

15 sections, 110 lessons, and lecture-level duration details.

01 What is PL/SQL and Why to Use? 6m
02 PL/SQL Architecture 10m

01 Which Option to Choose to Have a Database? 9m
02 Option 1: Having the Database with the Oracle Virtual Box 16m
03 What is Pluggable Database? 3m
04 Option 2: Downloading and Installing the Oracle Database 18m
05 Option 2: Unlocking the HR Schema 8m
06 Option 2: Configuring and Using the SQL Developer 22m
07 Option 3: Using Oracle Live SQL 8m

01 Anonymous Blocks 14m
02 PL/SQL Outputs 8m

01 What are Variables and Why to Use Them? 9m
02 Naming Rules & Naming Conventions 4m
03 Declaring & Initializing & Using Variables - Part 1 11m
04 Declaring & Initializing & Using Variables - Part 2 10m
05 Using %TYPE Attribute 7m
06 PL/SQL Delimiters and Commenting Your Code 6m
07 PL SQL Variable Scope 11m
08 Using Bind Variables 11m

01 What are Control Structures & IF Statements 14m
02 Case Expressions 15m
03 What are Loops - Basic Loops 10m
04 While Loops 6m
05 For Loops 10m
06 Nested Loops & Loop Labeling 16m
07 Continue Statement 10m
08 GOTO Statement 14m

01 Operating with Selected Database Data.. 18m
02 DML Operations in PL/SQL 13m
03 Using Sequences in PL/SQL 13m
04 Bonus - Enabling Server Outputs by Default. 5m

01 Simple Data Types vs Composite Data Types 8m
02 PL/SQL Records - Part 1 17m
03 PL/SQL Records - Part 2 17m
04 Easy DML With Records 8m
05 What Are Collections? 6m
06 Varrays & Collection Methods 23m
07 Nested Tables 11m
08 PL&SQL Associative Arrays (Part 1) 19m
09 PL&SQL Associative Arrays (Part 2) 15m
10 Storing Collections in Tables - (Part 1) 14m
11 Storing Collections in Tables - (Part 2) 11m

01 What are Cursors and Cursor Types in PL SQL? 8m
02 Using Explicit Cursors 11m
03 Using Cursors with Records 6m
04 Looping with Cursors 12m
05 PL SQL Cursors with Parameters 14m
06 PL SQL Cursor Attributes 8m
07 For Update Clause 21m
08 Where Current Of Clause 10m
09 Reference Cursors 24m

01 What are the Exceptions? 9m
02 Handling the Exceptions! 18m
03 Handling the Nonpredefined Exceptions 6m
04 Handling & Raising User-Defined Exceptions 8m
05 Using RAISE_APPLICATION_ERROR() Procedure 8m

01 What are Functions & Procedures and Why We Use? 9m
02 Creating and Using Stored Procedures 17m
03 Using IN & OUT Parameters 15m
04 Named & Mixed Notations and Default Option 16m
05 Creating and Using Functions (Part 1) 17m
06 Creating and Using Functions (Part 2) 7m
07 Local Subprograms 15m
08 Overloading the Subprograms 13m
09 Handling the Exceptions in Subprograms 20m
10 Finding & Removing the Subprograms 11m
11 Regular & Pipelined Table Functions 20m

01 What Are Packages? 10m
02 Creating & Using & Modifying & Removing the Packages 27m
03 Visibility of Package Objects 11m
04 Illegal Object Reference & Forward Declaration 7m
05 Package Initialization 9m
06 Persistent State of Packages - Part 1 19m
07 Persistent State of Packages - Part 2 14m
08 Using Collections in Packages - Part 1 26m
09 How Can I Find the Packages? 7m

01 What are Triggers & Trigger Types 10m
02 Understanding DML Triggers 11m
03 Specifying the Timing of Triggers 19m
04 Statement & Row Level Triggers 13m
05 Using New & Old Qualifiers in Triggers 19m
06 Using Conditional Predicates 10m
07 Using RAISE_APPLICATION_ERROR Procedure in Triggers 6m
08 Using Update Of Event in Triggers 6m
09 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

01 PL/SQL Debugging: Debugging Your Subprograms - (Part 1) 11m
02 PL/SQL Debugging: Debugging Your Subprograms - (Part 2) 11m
03 PL/SQL Debugging: Debugging Your Subprograms - (Part 3) 9m
04 PL/SQL Debugging: Debugging the Anonymous Blocks 6m

01 Introduction to Dynamic SQL and Dynamic PL/SQL 13m
02 Native Dynamic SQL, PL/SQL 11m
03 EXECUTE IMMEDIATE Statement 11m
04 EXECUTE IMMEDIATE STATEMENT with the USING Clause 15m
05 EXECUTE IMMEDIATE STATEMENT with the USING and INTO Clauses 13m
06 EXECUTE IMMMEDIATE with BULK COLLECT INTO Clause 6m
07 Dynamic PL/SQL Blocks 12m
08 OPEN - FOR, FETCH Statements 7m
09 Using the DMBS_SQL Package (The Method 4) 24m

01 Using the DBMS_OUTPUT Package 14m
02 Using the UTL_FILE Package (Part 1) 16m
03 Using the UTL_FILE Package (Part 2) 18m
04 Using the UTL_FILE Package (Part 3) 12m
05 Using the UTL_MAIL Package (Part 1) 13m
06 Using the UTL_MAIL Package (Part 2) 14m
Continue preparing

Connect the lessons to exam-day practice.

Use the course for structured review, then move into current questions, timed simulator sessions, and a broader vendor catalog.

VTSimu exam simulatorRehearse pacing in focused desktop sessions.
Unlimited AccessBuild a practice library across vendors and formats.
More video coursesExplore every available certification training track.