1z0-149: Oracle Database Program with PL/SQL
Your Oracle 1z0-149 exam is just around the corner, right? So, it's high time to find an effective preparation tool! Our training course is what you really need! This is a series of videos led by the experienced IT instructors who will provide you with a detailed overview of the 1z0-149 certification test. Ace your Oracle 1z0-149 at the first attempt and obtain the Oracle Database Program with PL/SQL credential with ease.
Curriculum for 1z0-149 Video Course
What is PL/SQL ?
| Video Name | Time | |
|---|---|---|
| 1. What is PL/SQL and Why to Use? | 6:00 | |
| 2. PL/SQL Architecture | 10:00 |
| 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 |
| Video Name | Time | |
|---|---|---|
| 1. Anonymous Blocks | 14:00 | |
| 2. PL/SQL Outputs | 8:00 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
Student Feedback
Similar Courses
Only Registered Members can View Training Courses
Please fill out your email address below in order to view Training Courses. Registration is Free and Easy, You Simply need to provide an email address.
Try Free Demo
Try Free Demo
