Curriculum For This Course
-
What is PL/SQL ?
2 Lectures Time 00:16:00 -
Software Installation
7 Lectures Time 01:24:00 -
Let's Start Coding!..
2 Lectures Time 00:22:00 -
PL/SQL Variables
8 Lectures Time 01:09:00 -
Control Structures
8 Lectures Time 01:35:00 -
Using SQL in PL/SQL
4 Lectures Time 00:49:00 -
Composite Data Types
11 Lectures Time 02:29:00 -
PL/SQL Cursors
9 Lectures Time 01:54:00 -
PL/SQL Exceptions
5 Lectures Time 00:49:00 -
PL/SQL Functions & Procedures
11 Lectures Time 02:40:00 -
PL/SQL Packages
9 Lectures Time 02:10:00 -
PL/SQL Triggers
15 Lectures Time 03:23:00 -
PL/SQL Debugging: Debugging Your Codes & Subprograms
4 Lectures Time 00:37:00 -
Using Dynamic SQL & PL/SQL
9 Lectures Time 01:52:00 -
Using Oracle-Supplied Packages
6 Lectures Time 01:27:00
Video tutorials list
-
What is PL/SQL ?
Video Name Time 1. What is PL/SQL and Why to Use? 6:00 2. PL/SQL Architecture 10:00 -
Software Installation
Video Name Time 1. Which Option to Choose to Have a Database? 9:00 2. Option 1: Having the Database with the Oracle Virtual Box 16:00 3. What is Pluggable Database? 3:00 4. Option 2: Downloading and Installing the Oracle Database 18:00 5. Option 2: Unlocking the HR Schema 8:00 6. Option 2: Configuring and Using the SQL Developer 22:00 7. Option 3: Using Oracle Live SQL 8:00 -
Let's Start Coding!..
Video Name Time 1. Anonymous Blocks 14:00 2. PL/SQL Outputs 8:00 -
PL/SQL Variables
Video Name Time 1. What are Variables and Why to Use Them? 9:00 2. Naming Rules & Naming Conventions 4:00 3. Declaring & Initializing & Using Variables - Part 1 11:00 4. Declaring & Initializing & Using Variables - Part 2 10:00 5. Using %TYPE Attribute 7:00 6. PL/SQL Delimiters and Commenting Your Code 6:00 7. PL SQL Variable Scope 11:00 8. Using Bind Variables 11:00 -
Control Structures
Video Name Time 1. What are Control Structures & IF Statements 14:00 2. Case Expressions 15:00 3. What are Loops - Basic Loops 10:00 4. While Loops 6:00 5. For Loops 10:00 6. Nested Loops & Loop Labeling 16:00 7. Continue Statement 10:00 8. GOTO Statement 14:00 -
Using SQL in PL/SQL
Video Name Time 1. Operating with Selected Database Data.. 18:00 2. DML Operations in PL/SQL 13:00 3. Using Sequences in PL/SQL 13:00 4. Bonus - Enabling Server Outputs by Default. 5:00 -
Composite Data Types
Video Name Time 1. Simple Data Types vs Composite Data Types 8:00 2. PL/SQL Records - Part 1 17:00 3. PL/SQL Records - Part 2 17:00 4. Easy DML With Records 8:00 5. What Are Collections? 6:00 6. Varrays & Collection Methods 23:00 7. Nested Tables 11:00 8. PL&SQL Associative Arrays (Part 1) 19:00 9. PL&SQL Associative Arrays (Part 2) 15:00 10. Storing Collections in Tables - (Part 1) 14:00 11. Storing Collections in Tables - (Part 2) 11:00 -
PL/SQL Cursors
Video Name Time 1. What are Cursors and Cursor Types in PL SQL? 8:00 2. Using Explicit Cursors 11:00 3. Using Cursors with Records 6:00 4. Looping with Cursors 12:00 5. PL SQL Cursors with Parameters 14:00 6. PL SQL Cursor Attributes 8:00 7. For Update Clause 21:00 8. Where Current Of Clause 10:00 9. Reference Cursors 24:00 -
PL/SQL Exceptions
Video Name Time 1. What are the Exceptions? 9:00 2. Handling the Exceptions! 18:00 3. Handling the Nonpredefined Exceptions 6:00 4. Handling & Raising User-Defined Exceptions 8:00 5. Using RAISE_APPLICATION_ERROR() Procedure 8:00 -
PL/SQL Functions & Procedures
Video Name Time 1. What are Functions & Procedures and Why We Use? 9:00 2. Creating and Using Stored Procedures 17:00 3. Using IN & OUT Parameters 15:00 4. Named & Mixed Notations and Default Option 16:00 5. Creating and Using Functions (Part 1) 17:00 6. Creating and Using Functions (Part 2) 7:00 7. Local Subprograms 15:00 8. Overloading the Subprograms 13:00 9. Handling the Exceptions in Subprograms 20:00 10. Finding & Removing the Subprograms 11:00 11. Regular & Pipelined Table Functions 20:00 -
PL/SQL Packages
Video Name Time 1. What Are Packages? 10:00 2. Creating & Using & Modifying & Removing the Packages 27:00 3. Visibility of Package Objects 11:00 4. Illegal Object Reference & Forward Declaration 7:00 5. Package Initialization 9:00 6. Persistent State of Packages - Part 1 19:00 7. Persistent State of Packages - Part 2 14:00 8. Using Collections in Packages - Part 1 26:00 9. How Can I Find the Packages? 7:00 -
PL/SQL Triggers
Video Name Time 1. What are Triggers & Trigger Types 10:00 2. Understanding DML Triggers 11:00 3. Specifying the Timing of Triggers 19:00 4. Statement & Row Level Triggers 13:00 5. Using New & Old Qualifiers in Triggers 19:00 6. Using Conditional Predicates 10:00 7. Using RAISE_APPLICATION_ERROR Procedure in Triggers 6:00 8. Using Update Of Event in Triggers 6:00 9. Using WHEN Clause in Triggers 7:00 10. INSTEAD OF Triggers 20:00 11. Exploring & Managing the Triggers 8:00 12. Creating Disabled Triggers 5:00 13. Additional Real-World Examples for DML Triggers 21:00 14. Compound Triggers 28:00 15. Handling Mutating Table Errors 20:00 -
PL/SQL Debugging: Debugging Your Codes & Subprograms
Video Name Time 1. PL/SQL Debugging: Debugging Your Subprograms - (Part 1) 11:00 2. PL/SQL Debugging: Debugging Your Subprograms - (Part 2) 11:00 3. PL/SQL Debugging: Debugging Your Subprograms - (Part 3) 9:00 4. PL/SQL Debugging: Debugging the Anonymous Blocks 6:00 -
Using Dynamic SQL & PL/SQL
Video Name Time 1. Introduction to Dynamic SQL and Dynamic PL/SQL 13:00 2. Native Dynamic SQL, PL/SQL 11:00 3. EXECUTE IMMEDIATE Statement 11:00 4. EXECUTE IMMEDIATE STATEMENT with the USING Clause 15:00 5. EXECUTE IMMEDIATE STATEMENT with the USING and INTO Clauses 13:00 6. EXECUTE IMMMEDIATE with BULK COLLECT INTO Clause 6:00 7. Dynamic PL/SQL Blocks 12:00 8. OPEN - FOR, FETCH Statements 7:00 9. Using the DMBS_SQL Package (The Method 4) 24:00 -
Using Oracle-Supplied Packages
Video Name Time 1. Using the DBMS_OUTPUT Package 14:00 2. Using the UTL_FILE Package (Part 1) 16:00 3. Using the UTL_FILE Package (Part 2) 18:00 4. Using the UTL_FILE Package (Part 3) 12:00 5. Using the UTL_MAIL Package (Part 1) 13:00 6. Using the UTL_MAIL Package (Part 2) 14:00
Add Comment