1z0-148: Oracle Database 12c: Advanced PL/SQL
BEST SELLER
98 Lectures
19h 58m
Prepare for your Oracle examination with our training course. The 1z0-148 course contains a complete batch of videos that will provide you with profound and thorough knowledge related to Oracle certification exam. Pass the Oracle 1z0-148 test with flying colors.
$14.99
$19.49
Curriculum For This Course
-
1. Course Introductory Video4m
-
2. What is PL/SQL and Why to Use?6m
-
3. PL/SQL Architecture10m
-
4. The Sample (HR) Schema Used in This Course7m
-
1. Which Option to Have a Database?9m
-
2. Option 1: Having the Database with the Oracle Virtual Box16m
-
3. What is Pluggable Database?3m
-
4. Option 2: Downloading and Installing the Oracle Database18m
-
5. Option 2: Unlocking the HR Schema8m
-
6. Option 2: Configuring and Using the SQL Developer22m
-
7. Option 3: Using Oracle Live SQL8m
-
1. Anonymous Blocks14m
-
2. PL/SQL Outputs8m
-
1. What are Variables and Why to Use Them?9m
-
2. Naming Rules & Naming Conventions4m
-
3. Declaring & Initializing & Using Variables - Part 111m
-
4. Declaring & Initializing & Using Variables - Part 210m
-
5. Using %TYPE Attribute7m
-
6. PL/SQL Delimiters and Commenting Your Code6m
-
7. PL SQL Variable Scope11m
-
8. Using Bind Variables11m
-
1. What are Control Structures & IF Statements14m
-
2. Case Expressions15m
-
3. What are Loops - Basic Loops10m
-
4. While Loops6m
-
5. For Loops10m
-
6. Nested Loops & Loop Labeling16m
-
7. Continue Statement10m
-
8. GOTO Statement14m
-
1. Operating with Selected Database Data..18m
-
2. DML Operations in PL/SQL13m
-
3. Using Sequences in PL/SQL13m
-
4. Bonus - Enabling Server Outputs by Default.5m
-
1. Simple Data Types vs Composite Data Types8m
-
2. PL/SQL Records - Part 117m
-
3. PL/SQL Records - Part 217m
-
4. Easy DML With Records8m
-
5. What Are Collections?6m
-
6. Varrays & Collection Methods23m
-
7. Nested Tables11m
-
8. PL&SQL Associative Arrays (Part 1)19m
-
9. PL&SQL Associative Arrays (Part 2)15m
-
10. Storing Collections in Tables - (Part 1)14m
-
11. Storing Collections in Tables - (Part 2)11m
-
1. What are Cursors and Cursor Types in PL SQL?8m
-
2. Using Explicit Cursors11m
-
3. Using Cursors with Records6m
-
4. Looping with Cursors12m
-
5. PL SQL Cursors with Parameters14m
-
6. PL SQL Cursor Attributes8m
-
7. For Update Clause21m
-
8. Where Current Of Clause10m
-
9. Reference Cursors24m
-
1. What are the Exceptions?9m
-
2. Handling the Exceptions!18m
-
3. Handling the Nonpredefined Exceptions6m
-
4. Handling & Raising User-Defined Exceptions8m
-
5. Using RAISE_APPLICATION_ERROR() Procedure8m
-
1. What are Functions & Procedures and Why We Use?9m
-
2. Creating and Using Stored Procedures17m
-
3. Using IN & OUT Parameters15m
-
4. Named & Mixed Notations and Default Option16m
-
5. Creating and Using Functions (Part 1)17m
-
6. Creating and Using Functions (Part 2)7m
-
7. Local Subprograms15m
-
8. Overloading the Subprograms13m
-
9. Handling the Exceptions in Subprograms20m
-
10. Finding & Removing the Subprograms11m
-
11. Regular & Pipelined Table Functions20m
-
1. What Are Packages?10m
-
2. Creating & Using & Modifying & Removing the Packages27m
-
3. Visibility of Package Objects11m
-
4. Illegal Object Reference & Forward Declaration7m
-
5. Package Initialization9m
-
6. Persistent State of Packages - Part 119m
-
7. Persistent State of Packages - Part 214m
-
8. Using Collections in Packages - Part 126m
-
9. Using Collections in Packages - Part 210m
-
10. How Can I Find the Packages?7m
-
1. What are Triggers & Trigger Types10m
-
2. Understanding DML Triggers11m
-
3. Specifying the Timing of Triggers19m
-
4. Statement & Row Level Triggers13m
-
5. Using New & Old Qualifiers in Triggers19m
-
6. Using Conditional Predicates10m
-
7. Using RAISE_APPLICATION_ERROR Procedure in Triggers6m
-
8. Using Update Of Event in Triggers6m
-
9. Using WHEN Clause in Triggers7m
-
10. INSTEAD OF Triggers20m
-
11. Exploring & Managing the Triggers8m
-
12. Creating Disabled Triggers5m
-
13. Additional Real-World Examples for DML Triggers21m
-
14. Compound Triggers28m
-
15. Handling Mutating Table Errors20m
-
1. PL/SQL Debugging: Debugging Your Subprograms - (Part 1)11m
-
2. PL/SQL Debugging: Debugging Your Subprograms - (Part 2)11m
-
3. PL/SQL Debugging: Debugging Your Subprograms - (Part 3)9m
-
4. PL/SQL Debugging: Debugging the Anonymous Blocks6m
