Section 1 : What is PLSQL

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

Section 2 : Software Installation

Lecture 7 About Certification Pdf
Lecture 8 Which Option to Choose to Have a Database 8:24
Lecture 9 Option 1 Having the Database with the Oracle Virtual Box 16:29
Lecture 10 Option 1 How to Install the Virtual Box on Mac OS X Text
Lecture 11 What is Pluggable Database 3:4
Lecture 12 Option 2 Downloading and Installing the Oracle Database 18:5
Lecture 13 Option 2 Unlocking the HR Schema 7:35
Lecture 14 Option 2 Configuring and Using the SQL Developer 22:4
Lecture 15 About Proctor Testing Pdf
Lecture 16 Option 3 About Oracle Live SQL Restrictions Text

Section 3 : Let's Start Coding!

Lecture 17 Anonymous Blocks 13:33
Lecture 18 PLSQL Outputs 8:9

Section 4 : PLSQL Variables

Lecture 19 What are Variables and Why to Use Them 8:37
Lecture 20 Naming Rules & Naming Conventions 4:24
Lecture 21 Declaring & Initializing & Using Variables - Part 1 10:45
Lecture 22 Declaring & Initializing & Using Variables - Part 2 10:23
Lecture 23 Declaring & Initializing & Using Variables (Code Samples) Text
Lecture 24 Using %TYPE Attribute 7:7
Lecture 25 Using %Type Attribute (Code Samples) Text
Lecture 26 PLSQL Delimiters and Commenting Your Code 5:37
Lecture 27 PLSQL Delimiters and Commenting (Code Samples) Text
Lecture 28 PL SQL Variable Scope 11:16
Lecture 29 PL SQL Variable Scope (Code Samples) Text
Lecture 30 Using Bind Variables 10:54
Lecture 31 Using Bind Variables (Code Samples) Text

Section 5 : Control Structures

Lecture 32 What are Control Structures & IF Statements 13:50
Lecture 33 What are Control Structures & IF Statements (Code Samples) Text
Lecture 34 Case Expressions 14:39
Lecture 35 Case Expressions (Code Samples) Text
Lecture 36 What are Loops - Basic Loops 10:3
Lecture 37 Basic Loops (Code Samples) Text
Lecture 38 While Loops 5:23
Lecture 39 While Loops (Code Samples) Text
Lecture 40 For Loops 9:44
Lecture 41 For Loops (Code Samples) Text
Lecture 42 Nested Loops & Loop Labeling 15:54
Lecture 43 Nested Loops & Loop Labeling (Code Samples) Text
Lecture 44 Continue Statement 10:14
Lecture 45 Continue Statement (Code Samples) Text
Lecture 46 GOTO Statement 13:22
Lecture 47 GOTO Statement (Code Samples) Text

Section 6 : Using SQL in PLSQL

Lecture 48 Operating with Selected Database Data 18:18
Lecture 49 Operating WIth Selected Queries (Code Samples) Text
Lecture 50 DML Operations in PLSQL 12:38
Lecture 51 DML Operations in PLSQL (Code Samples) Text
Lecture 52 Using Sequences in PLSQL
Lecture 53 Using Sequences in PLSQL (Code Samples) Text
Lecture 54 Bonus - Enabling Server Outputs by Default 4:32

Section 7 : Composite Data Types

Lecture 55 Simple Data Types vs Composite Data Types 7:45
Lecture 56 PLSQL Records - Part 1 16:31
Lecture 57 PLSQL Records - Part 2
Lecture 58 PLSQL Records (Code Samples) Text
Lecture 59 Easy DML With Records 8:9
Lecture 60 Easy DML With Records (Code Samples) Text
Lecture 61 What Are Collections
Lecture 62 Varrays & Collection Methods
Lecture 63 Varrays (Code Samples) Text
Lecture 64 Nested Tables 10:49
Lecture 65 Nested Tables (Code Samples) Text
Lecture 66 PL&SQL Associative Arrays (Part 1) 18:50
Lecture 67 PL&SQL Associative Arrays (Part 2) 14:43
Lecture 68 Associative Arrays (Code Samples) Text
Lecture 69 Storing Collections in Tables - (Part 1) 13:56
Lecture 70 Storing Collections in Tables - (Part 2) 11:8
Lecture 71 Storing Collections in Tables (Code Samples) Text

Section 8 : PLSQL Cursors

Lecture 72 What are Cursors and Cursor Types in PL SQL 7:58
Lecture 73 Using Explicit Cursors 11:6
Lecture 74 Using Explicit Cursors (Code Samples) Text
Lecture 75 Using Cursors with Records 6:4
Lecture 76 Cursors with Records (Code Samples) Text
Lecture 77 Looping with Cursors 12:8
Lecture 78 Looping with Cursors (Code Samples) Text
Lecture 79 PL SQL Cursors with Parameters 13:25
Lecture 80 PL SQL Cursors with Parameters (Code Samples) Text
Lecture 81 PL SQL Cursor Attributes 8:21
Lecture 82 PL SQL Cursor Attributes (Code Samples) Text
Lecture 83 For Update Clause 20:25
Lecture 84 For Update Clause (Code Samples) Text
Lecture 85 Where Current Of Clause 9:46
Lecture 86 Where Current Of Clause (Code Samples) Text
Lecture 87 Reference Cursors 24:3
Lecture 88 Reference Cursors - (Code Samples) Text

Section 9 : PLSQL Exceptions

Lecture 89 What are the Exceptions 9:8
Lecture 90 What are the Exceptions (Code Sample) Text
Lecture 91 Handling the Exceptions! 17:48
Lecture 92 Handling the Exceptions (Code Samples) Text
Lecture 93 Handling the Nonpredefined Exceptions 6:17
Lecture 94 Handling Nonpredefined Exceptions (Code Sample) Text
Lecture 95 Handling & Raising User-Defined Exceptions 7:46
Lecture 96 Handling & Raising User-Defined Exceptions (Code Samples) Text
Lecture 97 Using RAISE_APPLICATION_ERROR() Procedure 7:42
Lecture 98 Using RAISE_APPLICATION_ERROR() Procedure (Code Samples) Text

Section 10 : PLSQL Functions & Procedures

Lecture 99 What are Functions & Procedures and Why We Use 8:28
Lecture 100 What are Functions & Procedures and Why We Use (Code Samples) Text
Lecture 101 Creating and Using Stored Procedures 16:44
Lecture 102 Creating and Using Stored Procedures (Code Samples) Text
Lecture 103 Using IN & OUT Parameters 14:24
Lecture 104 Using IN & OUT Parameters (Code Samples) Text
Lecture 105 Named & Mixed Notations and Default Option 16:17
Lecture 106 Named & Mixed Notations and Default Option (Code Samples) Text
Lecture 107 Creating and Using Functions (Part 1) 16:22
Lecture 108 Creating and Using Functions (Part 2) 7:12
Lecture 109 Creating and Using PLSQL Functions (Code Samples) Text
Lecture 110 Local Subprograms 14:40
Lecture 111 Local Subprograms (Code Samples) Text
Lecture 112 Overloading the Subprograms 13:2
Lecture 113 Overloading the Subprograms (Code Samples) Text
Lecture 114 Handling the Exceptions in Subprograms 19:33
Lecture 115 Handling the Exceptions in Subprograms (Code Samples) Text
Lecture 116 Finding & Removing the Subprograms 10:55
Lecture 117 Regular & Pipelined Table Functions 19:24
Lecture 118 Regular & Pipelined Table Functions (Code Samples) Text

Section 11 : PLSQL Packages

Lecture 119 What Are Packages 9:28
Lecture 120 Creating & Using & Modifying & Removing the Packages 27:8
Lecture 121 Creating & Using & Modifying & Removing the Packages (Code Samples) Text
Lecture 122 Visibility of Package Objects 11:12
Lecture 123 Visibility of Package Objects (Code Samples) Text
Lecture 124 Illegal Object Reference & Forward Declaration 7:20
Lecture 125 Package Initialization 8:37
Lecture 126 Persistent State of Packages - Part 1
Lecture 127 Persistent State of Packages - Part 2 13:50
Lecture 128 Persistent State of Packages (Code Samples) Text
Lecture 129 Using Collections in Packages - Part 1 26:6
Lecture 130 Using Collections in Packages - Part 2 9:36
Lecture 131 Using Collections in Packages (Code Samples) Text
Lecture 132 How Can I Find the Packages 7:20

Section 12 : PLSQL Triggers

Lecture 133 What are Triggers & Trigger Types 9:51
Lecture 134 Understanding DML Triggers 11:11
Lecture 135 Specifying the Timing of Triggers 18:53
Lecture 136 Specifying the Timing of Triggers (Code Samples) Text
Lecture 137 Statement & Row Level Triggers 13:22
Lecture 138 Statement & Row Level Triggers (Code Samples) Text
Lecture 139 Using New & Old Qualifiers in Triggers 19:23
Lecture 140 Using New & Old Qualifiers in Triggers (Code Samples) Text
Lecture 141 Using Conditional Predicates 10:18
Lecture 142 Using Conditional Predicates (Code Samples) Text
Lecture 143 Using RAISE_APPLICATION_ERROR Procedure in Triggers 5:25
Lecture 144 Using RAISE_APPLICATION_ERROR Procedure in Triggers (Code Samples) Text
Lecture 145 Using Update Of Event in Triggers 6:21
Lecture 146 Using Update Of Event in Triggers (Code Samples) Text
Lecture 147 Using WHEN Clause in Triggers 7:2
Lecture 148 Using When Clause in Triggers (Code Samples) Text
Lecture 149 INSTEAD OF Triggers 19:37
Lecture 150 Instead of Triggers (Code Samples) Text
Lecture 151 Exploring & Managing the Triggers 8:14
Lecture 152 Creating Disabled Triggers 4:59
Lecture 153 Creating Disabled Triggers (Code Samples) Text
Lecture 154 Additional Real-World Examples for DML Triggers 21:16
Lecture 155 Additional Real-World Examples for DML Triggers (Code Samples) Text
Lecture 156 Compound Triggers 27:32
Lecture 157 Compound Triggers (Code Samples) Text
Lecture 158 Handling Mutating Table Errors 20:10
Lecture 159 Handling Mutating Table Errors (Code Samples) Text

Section 13 : PLSQL Debugging Debugging Your Codes & Subprograms

Lecture 160 PLSQL Debugging Debugging Your Subprograms - (Part 1) 10:44
Lecture 161 PLSQL Debugging Debugging Your Subprograms - (Part 2) 11:6
Lecture 162 PLSQL Debugging Debugging Your Subprograms - (Part 3) 8:33
Lecture 163 Granting Debug Privileges to a User Text
Lecture 164 PLSQL Debugging Debugging the Anonymous Blocks 5:40
Lecture 165 Source Code Debugging the Anonymous Blocks Text

Section 14 : Using Dynamic SQL & PLSQL in PLSQL!

Lecture 166 Introduction to Dynamic SQL and Dynamic PLSQL 12:32
Lecture 167 Native Dynamic SQL, PLSQL 11:5
Lecture 168 EXECUTE IMMEDIATE Statement 10:42
Lecture 169 Execute Immediate Statement (Code Samples) Text
Lecture 170 EXECUTE IMMEDIATE STATEMENT with the USING Clause 15:5
Lecture 171 EXECUTE IMMEDIATE STATEMENT with the USING Clause (Code Samples) Text
Lecture 172 EXECUTE IMMEDIATE STATEMENT with the USING and INTO Clauses 12:19
Lecture 173 EXECUTE IMMEDIATE STATEMENT with the USING and INTO Clauses (Code Samples) Text
Lecture 174 EXECUTE IMMMEDIATE with BULK COLLECT INTO Clause 5:47
Lecture 175 Execute Immediate with Bulk Collect (Code Samples) Text
Lecture 176 Dynamic PLSQL Blocks 11:35
Lecture 177 Dynamic PLSQL Blocks (Code Sample) Text
Lecture 178 OPEN - FOR, FETCH Statements 7:3
Lecture 179 OPEN - FOR, FETCH Statements (Code Sample) Text
Lecture 180 Using the DMBS_SQL Package (The Method 4) 23:48
Lecture 181 Using the DBMS_SQL Package (Code Samples) Text

Section 15 : Using Oracle-Supplied Packages

Lecture 182 What are Oracle Supplied Packages 6:58
Lecture 183 Using the DBMS_OUTPUT Package 13:48
Lecture 184 Using the DBMS_OUTPUT Package (Code Samples) Text
Lecture 185 Using the UTL_FILE Package (Part 1) 15:48
Lecture 186 Using the UTL_FILE Package (Part 2) 17:29
Lecture 187 Using the UTL_FILE Package (Part 3) 11:30
Lecture 188 Using the UTL_FILE Package (Code Samples) Text
Lecture 189 Using the UTL_MAIL Package (Part 1) 12:54
Lecture 190 Using the UTL_MAIL Package (Part 2) 13:45
Lecture 191 Using the UTL_MAIL Package (Code Samples) Text
Lecture 192 For Your Attention! Text

Section 16 : Bonus (+) Section

Lecture 193 Bonus Lecture Exclusive Offers for Our Existing Students! Text

Section 17 : Appendix

Lecture 194 Appendix 1 Oracle Database 12c Installation into Your Computer 9:0
Lecture 195 Appendix 2 How to Unlock the HR Schema in the Oracle Database 12c Text
Lecture 196 Appendix 3 Configuring and Using Oracle SQL Developer for Oracle Database 12c 9:54