Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Udemy

The Complete PL/SQL Bootcamp : "Beginner to Advanced PL/SQL"

via Udemy

Overview

A Comprehensive Guide to Make You a Job-Ready PL/SQL Developer.Also Covers Oracle 1Z0-144 and 1Z0-149 PL SQL Exam Topics

What you'll learn:
  • Pass the Oracle 1Z0-149 : Program with PL/SQL Certification Exam - on your first try!
  • Pass the Oracle 1Z0-148 : Advanced PL/SQL Certification Exam - on your first try!
  • Anything You Need for Coding PL/SQL From Beginner Level to Advanced Level
  • Every Subject is Explained from the Easiest to the Most Advanced.
  • Real-World Examples for Every Section
  • Some Advanced SQL Techniques
  • Use SQL Developer Efficiently for PL/SQL
  • Learn PL/SQL Architecture Very Well
  • Improve Performance of SQL& PL/SQL Codes
  • Create Your Dynamic SQL & PL/SQL Queries
  • Learn PL/SQL Object Oriented Programming
  • Learn PL/SQL Tuning for Performance
  • Learn & Master PL/SQL by Coding with Hundreds of Practical Examples!
  • Become a Job-Ready Oracle PL/SQL Developer Certified Professional!

Latest Course Updates:

  • (Aug2024) : "Oracle-Supplied PL/SQLPackages" section was added!

  • (Jun 2024): "Using Dynamic SQL & PL/SQL in PL/SQL" section is added!

  • (May 2024) : High-Quality Closed-Captions are added!

  • (Apr 2024): New Quiz Questions are added!

Become an Oracle Database PL/SQL Developer Certified Professional!

This comprehensive PL/SQLProgramming Bootcamp is created for Real Beginner to Advanced PL/SQL Subjects with hundreds of Real-World Examples. Every subject starts from the simplest for non-programmers and goes until the most advanced parts for the students who already know PL/SQL. Every student who wants to learn or Become a Hero in PL/SQL will find everything that they are looking for.

Students will learn and improve their:

  • PL/SQLCoding Skills

  • SQL & PL/SQL Performance

  • PL/SQLScalability

  • Portability and Security of Database and PL/SQL Programming

And also our students will be prepared for:

  • (NEW!) Exam Number: 1Z0-149 Oracle Database 19c: Program with PL/SQL Oracle Certification Exam

  • Exam Number: 1Z0-148 Oracle Database 12c: Advanced PL/SQL | Oracle Certification Exam

  • Exam Number: 1Z0-144 Oracle Database 12c: Program with PL/SQL | Oracle Certification Exam

  • Exam Number: 1Z0-144 Oracle Database 11g: Program with PL/SQL | Oracle Certification Exam

Our PL/SQLProgramming Bootcamp Covers:

  • PL/SQL Terminologies

  • PL/SQLArchitecture

  • PL/SQL Variables

  • PL/SQLControl Structures

    • If-Then-Else Structure

    • Case Expressions

    • Loops

      • While Loop

      • For Loop

      • Nested Loop

      • Loop Labeling

      • Continue Statement

      • GOTOStatement

  • Using SQL inside PL/SQL

  • PL/SQLCursors

  • Using PL/SQLProgram Units (Functions & Procedures)

  • PL/SQLPackages

  • PL/SQLExceptions &Exception Handling

  • PL/SQL Debugging

  • Dynamic SQL & PL/SQL

  • PL/SQLComposite Data Types (Collections)

    • Associative Arrays

    • Nested Tables

    • Varrays

    • Records

  • PL/SQLTriggers

  • Oracle-Supplied Packages

  • Using Large Objects in PL/SQL(LOBs)

  • Using PL/SQL Object Oriented

  • Using PL/SQL Compiler

  • PL/SQLPerformance &Tuning

  • PL/SQLCaching

  • PL/SQLSecurity

  • PL/SQLFine-Grained Access Control (VPD)

  • PL/SQL Hints

  • PL/SQL Object Dependencies

  • Designing Better PL/SQL

  • Using Java/C in PL/SQL

  • Managing Dependencies

Important Note: This course will be continuously getting updated with more lectures, quizzes, assessments to enhance your knowledge of Oracle PL/SQL

See you in the first lecture!

Taught by

Oracle Master Training • 150,000+ Students Worldwide and Code Star Academy

Reviews

5.0 rating, based on 1 Class Central review

4.5 rating at Udemy based on 16571 ratings

Start your review of The Complete PL/SQL Bootcamp : "Beginner to Advanced PL/SQL"

  • Anonymous
    The best course in oracle PL/SQL ever seen. I like it a lot. I read many books and saw a lot of videos but this course was the best

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.