Section 1 : What is PLSQL

Lecture 1 Course Introductory Video 00:04:19 Duration
Lecture 2 INTRODUCTION TO BRAINMEASURES PROCTOR SYSTEM
Lecture 3 What is PLSQL and Why to Use 00:05:32 Duration
Lecture 4 PLSQL Architecture 00:09:24 Duration
Lecture 5 The Sample (HR) Schema Used in This Course 00:07:07 Duration
Lecture 6 Bonus Materials Course Material & PLSQL Cheatsheet

Section 2 : Software Installation

Lecture 1 About Certification
Lecture 2 Which Option to Choose to Have a Database 00:08:24 Duration
Lecture 3 Option 1 Having the Database with the Oracle Virtual Box 00:16:29 Duration
Lecture 4 Option 1 How to Install the Virtual Box on Mac OS X
Lecture 5 What is Pluggable Database 00:03:04 Duration
Lecture 6 Option 2 Downloading and Installing the Oracle Database 00:18:05 Duration
Lecture 7 Option 2 Unlocking the HR Schema 00:07:35 Duration
Lecture 8 Option 2 Configuring and Using the SQL Developer 00:22:04 Duration
Lecture 9 About Proctor Testing
Lecture 10 Option 3 About Oracle Live SQL Restrictions

Section 3 : Let's Start Coding!

Lecture 1 Anonymous Blocks 00:13:33 Duration
Lecture 2 PLSQL Outputs 00:08:09 Duration

Section 4 : PLSQL Variables

Lecture 1 What are Variables and Why to Use Them 00:08:37 Duration
Lecture 2 Naming Rules & Naming Conventions 00:04:24 Duration
Lecture 3 Declaring & Initializing & Using Variables - Part 1 00:10:45 Duration
Lecture 4 Declaring & Initializing & Using Variables - Part 2 00:10:23 Duration
Lecture 5 Declaring & Initializing & Using Variables (Code Samples)
Lecture 6 Using %TYPE Attribute 00:07:07 Duration
Lecture 7 Using %Type Attribute (Code Samples)
Lecture 8 PLSQL Delimiters and Commenting Your Code 00:05:37 Duration
Lecture 9 PLSQL Delimiters and Commenting (Code Samples)
Lecture 10 PL SQL Variable Scope 00:11:16 Duration
Lecture 11 PL SQL Variable Scope (Code Samples)
Lecture 12 Using Bind Variables 00:10:54 Duration
Lecture 13 Using Bind Variables (Code Samples)

Section 5 : Control Structures

Lecture 1 What are Control Structures & IF Statements 00:13:50 Duration
Lecture 2 What are Control Structures & IF Statements (Code Samples)
Lecture 3 Case Expressions 00:14:39 Duration
Lecture 4 Case Expressions (Code Samples)
Lecture 5 What are Loops - Basic Loops 00:10:03 Duration
Lecture 6 Basic Loops (Code Samples)
Lecture 7 While Loops 00:05:23 Duration
Lecture 8 While Loops (Code Samples)
Lecture 9 For Loops 00:09:44 Duration
Lecture 10 For Loops (Code Samples)
Lecture 11 Nested Loops & Loop Labeling 00:15:54 Duration
Lecture 12 Nested Loops & Loop Labeling (Code Samples)
Lecture 13 Continue Statement 00:10:14 Duration
Lecture 14 Continue Statement (Code Samples)
Lecture 15 GOTO Statement 00:13:22 Duration
Lecture 16 GOTO Statement (Code Samples)

Section 6 : Using SQL in PLSQL

Lecture 1 Operating with Selected Database Data 00:18:18 Duration
Lecture 2 Operating WIth Selected Queries (Code Samples)
Lecture 3 DML Operations in PLSQL 00:12:38 Duration
Lecture 4 DML Operations in PLSQL (Code Samples)
Lecture 5 Using Sequences in PLSQL
Lecture 6 Using Sequences in PLSQL (Code Samples)
Lecture 7 Bonus - Enabling Server Outputs by Default 00:04:32 Duration

Section 7 : Composite Data Types

Lecture 1 Simple Data Types vs Composite Data Types 00:07:45 Duration
Lecture 2 PLSQL Records - Part 1 00:16:31 Duration
Lecture 3 PLSQL Records - Part 2
Lecture 4 PLSQL Records (Code Samples)
Lecture 5 Easy DML With Records 00:08:09 Duration
Lecture 6 Easy DML With Records (Code Samples)
Lecture 7 What Are Collections
Lecture 8 Varrays & Collection Methods
Lecture 9 Varrays (Code Samples)
Lecture 10 Nested Tables 00:10:49 Duration
Lecture 11 Nested Tables (Code Samples)
Lecture 12 PL&SQL Associative Arrays (Part 1) 00:18:50 Duration
Lecture 13 PL&SQL Associative Arrays (Part 2) 00:14:43 Duration
Lecture 14 Associative Arrays (Code Samples)
Lecture 15 Storing Collections in Tables - (Part 1) 00:13:56 Duration
Lecture 16 Storing Collections in Tables - (Part 2) 00:11:08 Duration
Lecture 17 Storing Collections in Tables (Code Samples)

Section 8 : PLSQL Cursors

Lecture 1 What are Cursors and Cursor Types in PL SQL 00:07:58 Duration
Lecture 2 Using Explicit Cursors 00:11:06 Duration
Lecture 3 Using Explicit Cursors (Code Samples)
Lecture 4 Using Cursors with Records 00:06:04 Duration
Lecture 5 Cursors with Records (Code Samples)
Lecture 6 Looping with Cursors 00:12:08 Duration
Lecture 7 Looping with Cursors (Code Samples)
Lecture 8 PL SQL Cursors with Parameters 00:13:25 Duration
Lecture 9 PL SQL Cursors with Parameters (Code Samples)
Lecture 10 PL SQL Cursor Attributes 00:08:21 Duration
Lecture 11 PL SQL Cursor Attributes (Code Samples)
Lecture 12 For Update Clause 00:20:25 Duration
Lecture 13 For Update Clause (Code Samples)
Lecture 14 Where Current Of Clause 00:09:46 Duration
Lecture 15 Where Current Of Clause (Code Samples)
Lecture 16 Reference Cursors 00:24:03 Duration
Lecture 17 Reference Cursors - (Code Samples)

Section 9 : PLSQL Exceptions

Lecture 1 What are the Exceptions 00:09:08 Duration
Lecture 2 What are the Exceptions (Code Sample)
Lecture 3 Handling the Exceptions! 00:17:48 Duration
Lecture 4 Handling the Exceptions (Code Samples)
Lecture 5 Handling the Nonpredefined Exceptions 00:06:17 Duration
Lecture 6 Handling Nonpredefined Exceptions (Code Sample)
Lecture 7 Handling & Raising User-Defined Exceptions 00:07:46 Duration
Lecture 8 Handling & Raising User-Defined Exceptions (Code Samples)
Lecture 9 Using RAISE_APPLICATION_ERROR() Procedure 00:07:42 Duration
Lecture 10 Using RAISE_APPLICATION_ERROR() Procedure (Code Samples)

Section 10 : PLSQL Functions & Procedures

Lecture 1 What are Functions & Procedures and Why We Use 00:08:28 Duration
Lecture 2 What are Functions & Procedures and Why We Use (Code Samples)
Lecture 3 Creating and Using Stored Procedures 00:16:44 Duration
Lecture 4 Creating and Using Stored Procedures (Code Samples)
Lecture 5 Using IN & OUT Parameters 00:14:24 Duration
Lecture 6 Using IN & OUT Parameters (Code Samples)
Lecture 7 Named & Mixed Notations and Default Option 00:16:17 Duration
Lecture 8 Named & Mixed Notations and Default Option (Code Samples)
Lecture 9 Creating and Using Functions (Part 1) 00:16:22 Duration
Lecture 10 Creating and Using Functions (Part 2) 00:07:12 Duration
Lecture 11 Creating and Using PLSQL Functions (Code Samples)
Lecture 12 Local Subprograms 00:14:40 Duration
Lecture 13 Local Subprograms (Code Samples)
Lecture 14 Overloading the Subprograms 00:13:02 Duration
Lecture 15 Overloading the Subprograms (Code Samples)
Lecture 16 Handling the Exceptions in Subprograms 00:19:33 Duration
Lecture 17 Handling the Exceptions in Subprograms (Code Samples)
Lecture 18 Finding & Removing the Subprograms 00:10:55 Duration
Lecture 19 Regular & Pipelined Table Functions 00:19:24 Duration
Lecture 20 Regular & Pipelined Table Functions (Code Samples)

Section 11 : PLSQL Packages

Lecture 1 What Are Packages 00:09:28 Duration
Lecture 2 Creating & Using & Modifying & Removing the Packages 00:27:08 Duration
Lecture 3 Creating & Using & Modifying & Removing the Packages (Code Samples)
Lecture 4 Visibility of Package Objects 00:11:12 Duration
Lecture 5 Visibility of Package Objects (Code Samples)
Lecture 6 Illegal Object Reference & Forward Declaration 00:07:20 Duration
Lecture 7 Package Initialization 00:08:37 Duration
Lecture 8 Persistent State of Packages - Part 1
Lecture 9 Persistent State of Packages - Part 2 00:13:50 Duration
Lecture 10 Persistent State of Packages (Code Samples)
Lecture 11 Using Collections in Packages - Part 1 00:26:06 Duration
Lecture 12 Using Collections in Packages - Part 2 00:09:36 Duration
Lecture 13 Using Collections in Packages (Code Samples)
Lecture 14 How Can I Find the Packages 00:07:20 Duration

Section 12 : PLSQL Triggers

Lecture 1 What are Triggers & Trigger Types 00:09:51 Duration
Lecture 2 Understanding DML Triggers 00:11:11 Duration
Lecture 3 Specifying the Timing of Triggers 00:18:53 Duration
Lecture 4 Specifying the Timing of Triggers (Code Samples)
Lecture 5 Statement & Row Level Triggers 00:13:22 Duration
Lecture 6 Statement & Row Level Triggers (Code Samples)
Lecture 7 Using New & Old Qualifiers in Triggers 00:19:23 Duration
Lecture 8 Using New & Old Qualifiers in Triggers (Code Samples)
Lecture 9 Using Conditional Predicates 00:10:18 Duration
Lecture 10 Using Conditional Predicates (Code Samples)
Lecture 11 Using RAISE_APPLICATION_ERROR Procedure in Triggers 00:05:25 Duration
Lecture 12 Using RAISE_APPLICATION_ERROR Procedure in Triggers (Code Samples)
Lecture 13 Using Update Of Event in Triggers 00:06:21 Duration
Lecture 14 Using Update Of Event in Triggers (Code Samples)
Lecture 15 Using WHEN Clause in Triggers 00:07:02 Duration
Lecture 16 Using When Clause in Triggers (Code Samples)
Lecture 17 INSTEAD OF Triggers 00:19:37 Duration
Lecture 18 Instead of Triggers (Code Samples)
Lecture 19 Exploring & Managing the Triggers 00:08:14 Duration
Lecture 20 Creating Disabled Triggers 00:04:59 Duration
Lecture 21 Creating Disabled Triggers (Code Samples)
Lecture 22 Additional Real-World Examples for DML Triggers 00:21:16 Duration
Lecture 23 Additional Real-World Examples for DML Triggers (Code Samples)
Lecture 24 Compound Triggers 00:27:32 Duration
Lecture 25 Compound Triggers (Code Samples)
Lecture 26 Handling Mutating Table Errors 00:20:10 Duration
Lecture 27 Handling Mutating Table Errors (Code Samples)

Section 13 : PLSQL Debugging Debugging Your Codes & Subprograms

Lecture 1 PLSQL Debugging Debugging Your Subprograms - (Part 1) 00:10:44 Duration
Lecture 2 PLSQL Debugging Debugging Your Subprograms - (Part 2) 00:11:06 Duration
Lecture 3 PLSQL Debugging Debugging Your Subprograms - (Part 3) 00:08:33 Duration
Lecture 4 Granting Debug Privileges to a User
Lecture 5 PLSQL Debugging Debugging the Anonymous Blocks 00:05:40 Duration
Lecture 6 Source Code Debugging the Anonymous Blocks

Section 14 : Using Dynamic SQL & PLSQL in PLSQL!

Lecture 1 Introduction to Dynamic SQL and Dynamic PLSQL 00:12:32 Duration
Lecture 2 Native Dynamic SQL, PLSQL 00:11:05 Duration
Lecture 3 EXECUTE IMMEDIATE Statement 00:10:42 Duration
Lecture 4 Execute Immediate Statement (Code Samples)
Lecture 5 EXECUTE IMMEDIATE STATEMENT with the USING Clause 00:15:05 Duration
Lecture 6 EXECUTE IMMEDIATE STATEMENT with the USING Clause (Code Samples)
Lecture 7 EXECUTE IMMEDIATE STATEMENT with the USING and INTO Clauses 00:12:19 Duration
Lecture 8 EXECUTE IMMEDIATE STATEMENT with the USING and INTO Clauses (Code Samples)
Lecture 9 EXECUTE IMMMEDIATE with BULK COLLECT INTO Clause 00:05:47 Duration
Lecture 10 Execute Immediate with Bulk Collect (Code Samples)
Lecture 11 Dynamic PLSQL Blocks 00:11:35 Duration
Lecture 12 Dynamic PLSQL Blocks (Code Sample)
Lecture 13 OPEN - FOR, FETCH Statements 00:07:03 Duration
Lecture 14 OPEN - FOR, FETCH Statements (Code Sample)
Lecture 15 Using the DMBS_SQL Package (The Method 4) 00:23:48 Duration
Lecture 16 Using the DBMS_SQL Package (Code Samples)

Section 15 : Using Oracle-Supplied Packages

Lecture 1 What are Oracle Supplied Packages 00:06:58 Duration
Lecture 2 Using the DBMS_OUTPUT Package 00:13:48 Duration
Lecture 3 Using the DBMS_OUTPUT Package (Code Samples)
Lecture 4 Using the UTL_FILE Package (Part 1) 00:15:48 Duration
Lecture 5 Using the UTL_FILE Package (Part 2) 00:17:29 Duration
Lecture 6 Using the UTL_FILE Package (Part 3) 00:11:30 Duration
Lecture 7 Using the UTL_FILE Package (Code Samples)
Lecture 8 Using the UTL_MAIL Package (Part 1) 00:12:54 Duration
Lecture 9 Using the UTL_MAIL Package (Part 2) 00:13:45 Duration
Lecture 10 Using the UTL_MAIL Package (Code Samples)
Lecture 11 For Your Attention!

Section 16 : Bonus (+) Section

Lecture 1 Bonus Lecture Exclusive Offers for Our Existing Students!

Section 17 : Appendix

Lecture 1 Appendix 1 Oracle Database 12c Installation into Your Computer 00:09:00 Duration
Lecture 2 Appendix 2 How to Unlock the HR Schema in the Oracle Database 12c
Lecture 3 Appendix 3 Configuring and Using Oracle SQL Developer for Oracle Database 12c 00:09:54 Duration