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
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
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!
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 |