Limited Time Discount Offer
60% Off - Ends in

1Z0-148 - Oracle Database 12c: Advanced PL/SQL

Looking for Latest and MOST Updated 1Z0-148 - Oracle Database 12c: Advanced PL/SQL Practice Exam Questions.
Read below what is included in the 1Z0-148 - Oracle Database 12c: Advanced PL/SQL Testing Engines !!

Verified by Certified Authors
1Z0-148 Bundle
You Save $53.99

1Z0-148 Oracle Bundle Sale

$89.98$35.99
    1Z0-148 Up To Date Practice Exam 112 Questions & Answers. Last Updated: Jun 7, 2021
    1Z0-148 PDF and Testing Engine Included
    1Z0-148 Video Training Course With 98 Lectures
    FREE Updates For 6 Months
    No Need To Purchase Software To Run Testing Engine
    Instant Download After Purchase

Purchase Individually

PDF and Testing Engine 112 Q&As

Last Updated: Jun 7, 2021

$74.98 $29.99

Buy Now

Training Course 98 Lectures

Last Updated: Jun 7, 2021

$34.98 $13.99

Buy Now
1Z0-148 - Oracle Database 12c: Advanced PL/SQL
Best Seller
$34.98$13.99

1Z0-148 - Oracle Database 12c: Advanced PL/SQL

  • Students: 203
  • Lectures: 98
  • Duration: 19h

About This Course


Passing the 1Z0-148 exam could be a real challenge, and when you don’t have time to prepare for the exam, you need quality study guides, tutorials and practice exam questions. Created by certified Oracle Specialists, the 98 Online Course Tutorial for the 1Z0-148 - Oracle Database 12c: Advanced PL/SQL exam is a must. The 1Z0-148 Video Tutorial is a great addition to your studies which are a plus, due to the visual and audio aid in the 1Z0-148 Online Course Tutorial.

The 1Z0-148 - Oracle Database 12c: Advanced PL/SQL covers all the exam objectives you will be tested on for the 1Z0-148 exam. The 1Z0-148 Online Course offers a complete curriculum with in-depth knowledge, labs and relevant examples to better prepare yourself for the Oracle 1Z0-148 exam. The 1Z0-148 - Oracle Database 12c: Advanced PL/SQL Online Course is ready to use as soon as you complete the purchase and can be played from your Members Area. Excellent Add-On to the 1Z0-148 practice exam to better prepare you for the 1Z0-148 exam.

Curriculum For This Course

1. Course Introductory Video 00:04:28
2. What is PL-SQL and Why to Use? 00:05:35
3. PL-SQL Architecture 00:09:34
4. The Sample (HR) Schema Used in This Course 00:07:14

1. Which Option to Have a Database? 00:09:09
2. Option 1 - Having the Database with the Oracle Virtual Box 00:16:29
3. What is Pluggable Database? 00:03:14
4. Option 2 - Downloading and Installing the Oracle Database 00:18:18
5. Option 2 - Unlocking the HR Schema 00:07:34
6. Option 2 - Configuring and Using the SQL Developer 00:22:14
7. Option 3 - Using Oracle Live SQL 00:07:40

1. Anonymous Blocks 00:13:42
2. PL-SQL Outputs 00:08:19

1. What are Variables and Why to Use Them? 00:08:37
2. Naming Rules and Naming Conventions 00:04:24
3. Declaring and Initializing and Using Variables - Part 1 00:10:45
4. Declaring and Initializing and Using Variables - Part 2 00:10:23
5. Using %TYPE Attribute 00:07:07
6. PL-SQL Delimiters and Commenting Your Code 00:05:36
7. PL-SQL Variable Scope 00:11:15
8. Using Bind Variables 00:10:54

1. What are Control Structures and IF Statements 00:13:58
2. Case Expressions 00:14:48
3. What are Loops - Basic Loops 00:10:12
4. While Loops 00:05:32
5. For Loops 00:09:54
6. Nested Loops and Loop Labeling 00:16:00
7. Continue Statement 00:10:23
8. GOTO Statement 00:13:30

1. Operating with Selected Database Data 00:18:26
2. DML Operations in PL/SQL 00:12:46
3. Using Sequences in PL/SQL 00:12:37
4. Bonus - Enabling Server Outputs by Default 00:04:39

1. Simple Data Types vs Composite Data Types 00:07:52
2. PL-SQL Records - Part 1 00:16:40
3. PL-SQL Records - Part 2 00:16:30
4. Easy DML With Records 00:08:15
5. What Are Collections? 00:06:14
6. Varrays and Collection Methods 00:22:59
7. Nested Tables 00:10:57
8. PL and SQL Associative Arrays (Part 1) 00:18:54
9. PL and SQL Associative Arrays (Part 2) 00:14:53
10. Storing Collections in Tables - (Part 1) 00:14:07
11. Storing Collections in Tables - (Part 2 00:11:15

1. What are Cursors and Cursor Types in PL SQL? 00:08:05
2. Using Explicit Cursors 00:11:13
3. Using Cursors with Records 00:06:11
4. Looping with Cursors 00:12:16
5. PL SQL Cursors with Parameters 00:13:33
6. PL SQL Cursor Attributes 00:08:28
7. For Update Clause 00:20:32
8. Where Current Of Clause 00:09:53
9. Reference Cursors 00:24:10

1. What are the Exceptions? 00:09:15
2. Handling the Exceptions! 00:17:55
3. Handling the Nonpredefined Exceptions 00:06:25
4. Handling and Raising User-Defined Exceptions 00:07:54
5. Using RAISE_APPLICATION_ERROR() Procedure 00:07:49

1. What are Functions and Procedures and Why We Use? 00:08:36
2. Creating and Using Stored Procedures 00:16:52
3. Using IN and OUT Parameters 00:14:34
4. Named and Mixed Notations and Default Option 00:16:25
5. Creating and Using Functions (Part 1) 00:16:31
6. Creating and Using Functions (Part 2) 00:07:21
7. Local Subprograms 00:14:48
8. Overloading the Subprograms 00:13:11
9. Handling the Exceptions in Subprograms 00:19:42
10. Finding and Removing the Subprograms 00:11:02
11. Regular and Pipelined Table Functions 00:19:32

1. What Are Packages? 00:09:37
2. Creating, Using, Modifying and Removing the Packages 00:27:16
3. Visibility of Package Objects 00:11:23
4. Illegal Object Reference and Forward Declaration 00:07:27
5. Package Initialization 00:08:45
6. Persistent State of Packages - Part 1 00:19:13
7. Persistent State of Packages - Part 2 00:13:59
8. Using Collections in Packages - Part 1 00:26:13
9. Using Collections in Packages - Part 2 00:09:43
10. How Can I Find the Packages? 00:07:28

1. What are Triggers and Trigger Types 00:10:00
2. Understanding DML Triggers 00:11:20
3. Specifying the Timing of Triggers 00:19:02
4. Statement and Row Level Triggers 00:13:29
5. Using New and Old Qualifiers in Triggers 00:19:22
6. Using Conditional Predicates 00:10:26
7. Using RAISE_APPLICATION_ERROR Procedure in Triggers 00:05:32
8. Using Update Of Event in Triggers 00:06:28
9. Using WHEN Clause in Triggers 00:07:10
10. INSTEAD OF Triggers 00:19:45
11. Exploring and Managing the Triggers 00:08:20
12. Creating Disabled Triggers 00:05:05
13. Additional Real-World Examples for DML Triggers 00:21:27
14. Compound Triggers 00:27:39
15. Handling Mutating Table Errors 00:20:17

1. PL-SQL Debugging: Debugging Your Subprograms - (Part 1) 00:10:53
2. PL-SQL Debugging: Debugging Your Subprograms - (Part 2) 00:11:16
3. PL-SQL Debugging: Debugging Your Subprograms - (Part 3) 00:08:42
4. PL-SQL Debugging: Debugging the Anonymous Blocks 00:05:49