Oracle Database 12c: Advanced PL/SQL Video Course

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

Your Oracle 1z0-148 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-148 certification test. Ace your Oracle 1z0-148 at the first attempt and obtain the Oracle Database 12c: Advanced PL/SQL credential with ease.

# of Students
116
# of Lectures
98
Course Length
19 h
Course Rating
4.5
Price $32.99
Today $29.99

Curriculum for 1z0-148 Video Course

What is PL/SQL ?

  Video Name Time
  1. Course Introductory Video 4:00
  2. What is PL/SQL and Why to Use? 6:00
  3. PL/SQL Architecture 10:00
  4. The Sample (HR) Schema Used in This Course 7:00
  Video Name Time
  1. Which Option 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. Using Collections in Packages - Part 2 10:00
  10. 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

Student Feedback

5 Stars
4 Stars
3 Stars
2 Stars
1 Star
4.5
Rating: 4.5
Overall Rating: Good.

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.

  • Trusted by 1.2M IT Certification Candidates Every Month
  • Hundreds Hours of Videos
  • Instant download After Registration

Already Member? Click here to Login

A confirmation link will be sent to this email address to verify your login

1200+ IT Certification Exams available: Get a free sample of any exam right now!
Try Free Demo

Try Free Demo

  • ABA
  • ACAMS
  • ACFE
  • ACI
  • ACSM
  • Adobe
  • AHIMA
  • AHIP
  • AHLEI
  • AICPA
  • AIWMI
  • Alfresco
  • AMA
  • Amazon
  • AndroidATC
  • APBM
  • API
  • APICS
  • Apple
  • Arista
  • Aruba
  • ASIS
  • ASQ
  • Atlassian
  • Autodesk
  • Avaya
  • Axis Communications
  • BACB
  • BCS
  • BICSI
  • Blockchain
  • Blue Coat
  • Blue Prism
  • C++ Institute
  • CA Technologies
  • Checkpoint
  • CIMA
  • Cisco
  • Citrix
  • CIW
  • Cloudera
  • CNCF
  • CompTIA
  • CSA
  • CWNP
  • CyberArc
  • Dell
  • DMI
  • DSCI
  • EMC
  • Esri
  • Exin
  • Extreme Networks
  • F5
  • FileMaker
  • FINRA
  • Fortinet
  • GAQM
  • GARP
  • Genesys
  • GIAC
  • Google
  • Guidance Software
  • H3C
  • HFMA
  • HIPAA
  • Hitachi
  • HP
  • HRCI
  • Huawei
  • IAPP
  • IBM
  • IFPUG
  • IIA
  • IIBA
  • Informatica
  • Isaca
  • iSAQB
  • ISC
  • iSQI
  • ISTQB
  • ITIL
  • Juniper
  • Lenovo
  • Linux Foundation
  • Logical Operations
  • LPI
  • Magento
  • Marketo
  • McAfee
  • Microsoft
  • Mulesoft
  • NACVA
  • NCMA
  • Network Appliance
  • NI
  • Nokia
  • Novell
  • Nuage Networks
  • Nutanix
  • OMG
  • Oracle
  • Palo Alto Networks
  • Pegasystems
  • PEOPLECERT
  • PMI
  • PRINCE2
  • Python Institute
  • QlikView
  • RedHat
  • Riverbed
  • RSA
  • Salesforce
  • SANS
  • SAP
  • SAS Institute
  • Scrum
  • SDI
  • ServiceNow
  • Six Sigma
  • SNIA
  • SOA
  • Software Certifications
  • SolarWinds
  • Splunk
  • SpringSource
  • Symantec
  • Teradata
  • Test Prep
  • The Open Group
  • Tibco
  • Unity Certification
  • VCE
  • Veeam
  • Veritas
  • Vmedu
  • VMware
  • WatchGuard
  • WorldatWork
  • Zend
Next Step
Next Step

Try Free Demo

  • Oracle
Next Step
Next Step

Summer Sale! Get 25% Discount on All Your Purchases!

Passguide Products

Enter Your Email Address to Receive Your 25%
OFF
Discount Code Plus... Our Exclusive Weekly Deals

* We value your privacy. We will not rent or sell your email address