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

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.

$24.99 $32.49

Curriculum For This Course

4 lectures 27m
  • 1. Course Introductory Video
    4m
  • 2. What is PL/SQL and Why to Use?
    6m
  • 3. PL/SQL Architecture
    10m
  • 4. The Sample (HR) Schema Used in This Course
    7m

7 lectures 1h 24m
  • 1. Which Option to Have a Database?
    9m
  • 2. Option 1: Having the Database with the Oracle Virtual Box
    16m
  • 3. What is Pluggable Database?
    3m
  • 4. Option 2: Downloading and Installing the Oracle Database
    18m
  • 5. Option 2: Unlocking the HR Schema
    8m
  • 6. Option 2: Configuring and Using the SQL Developer
    22m
  • 7. Option 3: Using Oracle Live SQL
    8m

2 lectures 22m
  • 1. Anonymous Blocks
    14m
  • 2. PL/SQL Outputs
    8m

8 lectures 1h 9m
  • 1. What are Variables and Why to Use Them?
    9m
  • 2. Naming Rules & Naming Conventions
    4m
  • 3. Declaring & Initializing & Using Variables - Part 1
    11m
  • 4. Declaring & Initializing & Using Variables - Part 2
    10m
  • 5. Using %TYPE Attribute
    7m
  • 6. PL/SQL Delimiters and Commenting Your Code
    6m
  • 7. PL SQL Variable Scope
    11m
  • 8. Using Bind Variables
    11m

8 lectures 1h 35m
  • 1. What are Control Structures & IF Statements
    14m
  • 2. Case Expressions
    15m
  • 3. What are Loops - Basic Loops
    10m
  • 4. While Loops
    6m
  • 5. For Loops
    10m
  • 6. Nested Loops & Loop Labeling
    16m
  • 7. Continue Statement
    10m
  • 8. GOTO Statement
    14m

4 lectures 49m
  • 1. Operating with Selected Database Data..
    18m
  • 2. DML Operations in PL/SQL
    13m
  • 3. Using Sequences in PL/SQL
    13m
  • 4. Bonus - Enabling Server Outputs by Default.
    5m

11 lectures 2h 29m
  • 1. Simple Data Types vs Composite Data Types
    8m
  • 2. PL/SQL Records - Part 1
    17m
  • 3. PL/SQL Records - Part 2
    17m
  • 4. Easy DML With Records
    8m
  • 5. What Are Collections?
    6m
  • 6. Varrays & Collection Methods
    23m
  • 7. Nested Tables
    11m
  • 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

9 lectures 1h 54m
  • 1. What are Cursors and Cursor Types in PL SQL?
    8m
  • 2. Using Explicit Cursors
    11m
  • 3. Using Cursors with Records
    6m
  • 4. Looping with Cursors
    12m
  • 5. PL SQL Cursors with Parameters
    14m
  • 6. PL SQL Cursor Attributes
    8m
  • 7. For Update Clause
    21m
  • 8. Where Current Of Clause
    10m
  • 9. Reference Cursors
    24m

5 lectures 49m
  • 1. What are the Exceptions?
    9m
  • 2. Handling the Exceptions!
    18m
  • 3. Handling the Nonpredefined Exceptions
    6m
  • 4. Handling & Raising User-Defined Exceptions
    8m
  • 5. Using RAISE_APPLICATION_ERROR() Procedure
    8m

11 lectures 2h 40m
  • 1. What are Functions & Procedures and Why We Use?
    9m
  • 2. Creating and Using Stored Procedures
    17m
  • 3. Using IN & OUT Parameters
    15m
  • 4. Named & Mixed Notations and Default Option
    16m
  • 5. Creating and Using Functions (Part 1)
    17m
  • 6. Creating and Using Functions (Part 2)
    7m
  • 7. Local Subprograms
    15m
  • 8. Overloading the Subprograms
    13m
  • 9. Handling the Exceptions in Subprograms
    20m
  • 10. Finding & Removing the Subprograms
    11m
  • 11. Regular & Pipelined Table Functions
    20m

10 lectures 2h 20m
  • 1. What Are Packages?
    10m
  • 2. Creating & Using & Modifying & Removing the Packages
    27m
  • 3. Visibility of Package Objects
    11m
  • 4. Illegal Object Reference & Forward Declaration
    7m
  • 5. Package Initialization
    9m
  • 6. Persistent State of Packages - Part 1
    19m
  • 7. Persistent State of Packages - Part 2
    14m
  • 8. Using Collections in Packages - Part 1
    26m
  • 9. Using Collections in Packages - Part 2
    10m
  • 10. How Can I Find the Packages?
    7m

15 lectures 3h 23m
  • 1. What are Triggers & Trigger Types
    10m
  • 2. Understanding DML Triggers
    11m
  • 3. Specifying the Timing of Triggers
    19m
  • 4. Statement & Row Level Triggers
    13m
  • 5. Using New & Old Qualifiers in Triggers
    19m
  • 6. Using Conditional Predicates
    10m
  • 7. Using RAISE_APPLICATION_ERROR Procedure in Triggers
    6m
  • 8. Using Update Of Event in Triggers
    6m
  • 9. Using WHEN Clause in Triggers
    7m
  • 10. INSTEAD OF Triggers
    20m
  • 11. Exploring & Managing the Triggers
    8m
  • 12. Creating Disabled Triggers
    5m
  • 13. Additional Real-World Examples for DML Triggers
    21m
  • 14. Compound Triggers
    28m
  • 15. Handling Mutating Table Errors
    20m

4 lectures 37m
  • 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 Blocks
    6m
Hot Exams
VTSimu
VTSimu Exam Simulator
How to open .dumpsarena files

Use Free VTSimu Exam Simulator to open .dumpsarena files

VTSimu Exam Simulator

Windows Mac Learn More
Satisfaction Guaranteed

98.4% DumpsArena users pass

Our team is dedicated to delivering top-quality exam practice questions. We proudly offer a hassle-free satisfaction guarantee.

Why choose DumpsArena?

23,812+

Satisfied Customers Since 2018

  • Always Up-to-Date
  • Accurate and Verified
  • Free Regular Updates
  • 24/7 Customer Support
  • Instant Access to Downloads
Secure Experience

Guaranteed safe checkout.

At DumpsArena, your shopping security is our priority. We utilize high-security SSL encryption, ensuring that every purchase is 100% secure.

SECURED CHECKOUT
Need Help?

Feel free to contact us anytime!

Contact Support