‘The Complete PL/SQL Bootcamp: “Beginner to Advanced PL/SQL”’ course is a comprehensive guide to make you a job-ready PL/SQL Developer and also covers Oracle 1Z0-144 and 1Z0-149 PL SQL Exam Topics.
The course explains every subject from the easiest to the most advanced. The course is usually available for INR 2,799 on Udemy but you can click on the link and get the ‘The Complete PL/SQL Bootcamp : “Beginner to Advanced PL/SQL’ for INR 499.
Who all can opt for this course?
- Anyone who wants to learn PL/SQL Programming Language
- Anyone who is looking for Beginner PL/SQL Subjects
- Students who are looking for Advanced PL/SQL Subjects
- Anyone who wants to pass “Oracle 1Z0-144 Program with PL/SQL” Exam
- Students who wants to pass “Oracle 1Z0-148 Advanced PL/SQL” Exam
- Students who wants to pass “Oracle 1Z0-149: Program with PL/SQL” Exam with Oracle Database 19c
- Beginner & Intermediate PL/SQL Developers
- Database Administrators, Application Designers, and SQL Developers (All Levels)
Course Highlights
| Key Highlights | Details |
|---|---|
| Registration Link | Apply Now! |
| Price | INR 499 ( |
| Duration | 25 Hours |
| Rating | 4.5/5 |
| Student Enrollment | 62,278 students |
| Instructor | Oracle Master Training |
| Topics Covered | PL/SQL Architecture, PL/SQL Functions & Procedures |
| Course Level | Intermediate |
| Total Student Reviews | 11,617 |
Learning Outcomes
- Pass the Oracle 1Z0-149: Program with PL/SQL Certification Exam.
- Pass the Oracle 1Z0-148: Advanced PL/SQL Certification Exam.
- From beginner level to advanced level, everything you need to code in PL/SQL.
- Every topic is explained from the simplest to the most complex.
- Examples from the real World in each section.
- A few sophisticated SQL techniques.
- For PL/SQL, effectively utilise SQL Developer.
- Learn PL/SQL Architecture Extremely Well.
- Enhance the efficiency of SQL and PL/SQL codes.
- Build Own Dynamic SQL & PL/SQL Queries.
- Learn object-oriented programming in PL/SQL.
- Become familiar with PL/SQL tuning for Performance.
- Study PL/SQL by coding with hundreds of real-world examples and master it.
- Become a Job-Ready Oracle PL/SQL developer and certified professional.
Course Content
| S.No. | Module (Duration) | Topics |
|---|---|---|
| 1. | What is PL/SQL ? (35 minutes) | Course Introductory Video |
| UDEMY 101: How to Use Udemy? +Some Useful Tips | ||
| What is PL/SQL and Why to Use? | ||
| PL/SQL Architecture | ||
| What is Pluggable Database? | ||
| The Sample (HR) Schema Used in This Course | ||
| Welcoming Gifts: Course Material & PL/SQL Cheatsheet | ||
| Quiz 1 | ||
| 2. | Software Installation (02 hours 36 minutes) | About the Database Installation |
| The Ways to Get a Database | ||
| Option 1: Installing VMware and VirtualBox on Windows | ||
| Option 1: How to Install the Virtual Box on Mac OS X? | ||
| Option 1: Downloading Virtual Machine Image | ||
| Option 1: Configuring the VMware Virtualization Software | ||
| Option 1: Configuring the Oracle VirtualBox Virtualization Software | ||
| Option 1: Configuring SQL Developer inside of the Virtual Machine | ||
| Important Note | ||
| Option 2: Downloading and Installing the Oracle Database | ||
| Option 2: Unlocking the HR Schema | ||
| Option 2: Configuring and Using the SQL Developer | ||
| Option 2: Installing Sample Schemas in Oracle Database | ||
| Option 2: HR Schema Create Code (if you could not get the HR user in other ways) | ||
| Option 3: Using Oracle Live SQL | ||
| Option 3: About Oracle Live SQL Restrictions | ||
| 3. | Let’s Start Coding! (22 minutes) | Anonymous Blocks |
| PL/SQL Outputs | ||
| Quiz (First Steps) | ||
| 4. | PL/SQL Variables (01 hour 10 minutes) | What are Variables and Why to Use Them? |
| Naming Rules & Naming Conventions | ||
| Declaring & Initializing & Using Variables – Part 1 | ||
| Declaring & Initializing & Using Variables – Part 2 | ||
| Declaring & Initializing & Using Variables (Code Samples) | ||
| Using %TYPE Attribute | ||
| Using %Type Attribute (Code Samples) | ||
| PL/SQL Delimiters and Commenting Your Code | ||
| PL/SQL Delimiters and Commenting (Code Samples) | ||
| PL SQL Variable Scope | ||
| PL SQL Variable Scope (Code Samples) | ||
| Using Bind Variables | ||
| Using Bind Variables (Code Samples) | ||
| Quiz (Variables) | ||
| 5. | Control Structures (01 hour 37 minutes) | What are Control Structures & IF Statements |
| What are Control Structures & IF Statements (Code Samples) | ||
| Case Expressions | ||
| Case Expressions (Code Samples) | ||
| What are Loops – Basic Loops | ||
| Basic Loops (Code Samples) | ||
| While Loops | ||
| While Loops (Code Samples) | ||
| For Loops | ||
| For Loops (Code Samples) | ||
| Nested Loops & Loop Labeling | ||
| Nested Loops & Loop Labeling (Code Samples) | ||
| Continue Statement | ||
| Continue Statement (Code Samples) | ||
| GOTO Statement | ||
| GOTO Statement (Code Samples) | ||
| Quiz (Control Structures) | ||
| 6. | Using SQL in PL/SQL (49 minutes) | Operating with Selected Database Data.. |
| Operating With Selected Queries (Code Samples) | ||
| DML Operations in PL/SQL | ||
| DML Operations in PL/SQL (Code Samples) | ||
| Using Sequences in PL/SQL | ||
| Using Sequences in PL/SQL (Code Samples) | ||
| Extra – Enabling Server Outputs by Default | ||
| Quiz (Using SQL in PL/SQL) | ||
| 7. | Composite Data Types (02 hours 36 minutes) | Simple Data Types vs Composite Data Types |
| PL/SQL Records – Part 1 | ||
| PL/SQL Records – Part 2 | ||
| PL/SQL Records (Code Samples) | ||
| Easy DML With Records | ||
| Easy DML With Records (Code Samples) | ||
| What Are Collections? | ||
| Varrays & Collection Methods | ||
| Varrays (Code Samples) | ||
| Nested Tables | ||
| Nested Tables (Code Samples) | ||
| PL&SQL Associative Arrays (Part 1) | ||
| PL&SQL Associative Arrays (Part 2) | ||
| Associative Arrays (Code Samples) | ||
| Storing Collections in Tables – (Part 1) | ||
| Storing Collections in Tables – (Part 2) | ||
| Storing Collections in Tables (Code Samples) | ||
| Quiz (Composite Data Types) | ||
| 8. | PL/SQL Cursors (02 hours 00 minutes) | What are Cursors and Cursor Types in PL SQL? |
| Using Explicit Cursors | ||
| Using Explicit Cursors (Code Samples) | ||
| Using Cursors with Records | ||
| Cursors with Records (Code Samples) | ||
| Looping with Cursors | ||
| Looping with Cursors (Code Samples) | ||
| PL SQL Cursors with Parameters | ||
| PL SQL Cursors with Parameters (Code Samples) | ||
| PL SQL Cursor Attributes | ||
| PL SQL Cursor Attributes (Code Samples) | ||
| For Update Clause | ||
| For Update Clause (Code Samples) | ||
| Where Current Of Clause | ||
| Where Current Of Clause (Code Samples) | ||
| Reference Cursors | ||
| Reference Cursors – (Code Samples) | ||
| Quiz (Cursors) | ||
| 9. | PL/SQL Exceptions (52 minutes) | What are the Exceptions? |
| What are the Exceptions (Code Sample) | ||
| Handling the Exceptions! | ||
| Handling the Exceptions (Code Samples) | ||
| Handling the Nonpredefined Exceptions | ||
| Handling Nonpredefined Exceptions (Code Sample) | ||
| Handling & Raising User-Defined Exceptions | ||
| Handling & Raising User-Defined Exceptions (Code Samples) | ||
| Using RAISE_APPLICATION_ERROR() Procedure | ||
| Using RAISE_APPLICATION_ERROR() Procedure (Code Samples) | ||
| Quiz (Exceptions) | ||
| 10. | PL/SQL Functions & Procedures (02 hours 44 minutes) | What are Functions & Procedures and Why We Use? |
| What are Functions & Procedures and Why We Use (Code Samples) | ||
| Creating and Using Stored Procedures | ||
| Creating and Using Stored Procedures (Code Samples) | ||
| Using IN & OUT Parameters | ||
| Using IN & OUT Parameters (Code Samples) | ||
| Named & Mixed Notations and Default Option | ||
| Named & Mixed Notations and Default Option (Code Samples) | ||
| Creating and Using Functions (Part 1) | ||
| Creating and Using Functions (Part 2) | ||
| Creating and Using PL/SQL Functions (Code Samples) | ||
| Local Subprograms | ||
| Local Subprograms (Code Samples) | ||
| Overloading the Subprograms | ||
| Overloading the Subprograms (Code Samples) | ||
| Handling the Exceptions in Subprograms | ||
| Handling the Exceptions in Subprograms (Code Samples) | ||
| Finding & Removing the Subprograms | ||
| Regular & Pipelined Table Functions | ||
| Regular & Pipelined Table Functions (Code Samples) | ||
| Quiz (PL/SQL Functions & Procedures) | ||
| 11. | PL/SQL Packages (02 hours 24 minutes) | What Are Packages? |
| Creating & Using & Modifying & Removing the Packages | ||
| Creating & Using & Modifying & Removing the Packages (Code Samples) | ||
| Visibility of Package Objects | ||
| Visibility of Package Objects (Code Samples) | ||
| Illegal Object Reference & Forward Declaration | ||
| Package Initialization | ||
| Persistent State of Packages – Part 1 | ||
| Persistent State of Packages – Part 2 | ||
| Persistent State of Packages (Code Samples) | ||
| Using Collections in PL/SQL Packages – Part 1 | ||
| Using Collections in PL/SQL Packages – Part 2 | ||
| Using Collections in PL/SQL Packages (Code Samples) | ||
| How Can I Find the Packages? | ||
| Quiz (Packages) | ||
| 12. | PL/SQL Triggers (03 hours 31 minutes) | What are Triggers & Trigger Types |
| Understanding DML Triggers | ||
| Specifying the Timing of Triggers | ||
| Specifying the Timing of Triggers (Code Samples) | ||
| Statement & Row Level Triggers | ||
| Statement & Row Level Triggers (Code Samples) | ||
| Using New & Old Qualifiers in Triggers | ||
| Using New & Old Qualifiers in Triggers (Code Samples) | ||
| Using Conditional Predicates | ||
| Using Conditional Predicates (Code Samples) | ||
| Using RAISE_APPLICATION_ERROR Procedure in Triggers | ||
| Using RAISE_APPLICATION_ERROR Procedure in Triggers (Code Samples) | ||
| Using Update Of Event in Triggers | ||
| Using Update Of Event in Triggers (Code Samples) | ||
| Using WHEN Clause in Triggers | ||
| Using When Clause in Triggers (Code Samples) | ||
| INSTEAD OF Triggers | ||
| Instead of Triggers (Code Samples) | ||
| Exploring & Managing the Triggers | ||
| Creating Disabled Triggers | ||
| Creating Disabled Triggers (Code Samples) | ||
| Additional Real-World Examples for DML Triggers | ||
| Additional Real-World Examples for DML Triggers (Code Samples) | ||
| Compound Triggers | ||
| Compound Triggers (Code Samples) | ||
| Handling Mutating Table Errors | ||
| Handling Mutating Table Errors (Code Samples) | ||
| Quiz (Triggers) | ||
| 13. | PL/SQL Debugging: Debugging Your Codes & Subprograms (37 minutes) | PL/SQL Debugging: Debugging Your Subprograms – (Part 1) |
| PL/SQL Debugging: Debugging Your Subprograms – (Part 2) | ||
| PL/SQL Debugging: Debugging Your Subprograms – (Part 3) | ||
| Granting Debug Privileges to a User | ||
| PL/SQL Debugging: Debugging the Anonymous Blocks | ||
| Source Code: Debugging the Anonymous Blocks | ||
| 14. | Using Dynamic SQL & PL/SQL in PL/SQL! (01 hour 57 minutes) | Introduction to Dynamic SQL and Dynamic PL/SQL |
| Native Dynamic SQL, PL/SQL | ||
| EXECUTE IMMEDIATE Statement | ||
| Execute Immediate Statement (Code Samples) | ||
| EXECUTE IMMEDIATE STATEMENT with the USING Clause | ||
| EXECUTE IMMEDIATE STATEMENT with the USING Clause (Code Samples) | ||
| EXECUTE IMMEDIATE STATEMENT with the USING and INTO Clauses | ||
| EXECUTE IMMEDIATE STATEMENT with the USING and INTO Clauses (Code Samples) | ||
| EXECUTE IMMMEDIATE with BULK COLLECT INTO Clause | ||
| Execute Immediate with Bulk Collect (Code Samples) | ||
| Dynamic PL/SQL Blocks | ||
| Dynamic PL/SQL Blocks (Code Sample) | ||
| OPEN – FOR, FETCH Statements | ||
| OPEN – FOR, FETCH Statements (Code Sample) | ||
| Using the DMBS_SQL Package (The Method 4) | ||
| Using the DBMS_SQL Package (Code Samples) | ||
| Quiz (Dynamic SQL) | ||
| 15. | Using Oracle-Supplied Packages (01 hour 37 minutes) | What are Oracle Supplied Packages? |
| Using the DBMS_OUTPUT Package | ||
| Using the DBMS_OUTPUT Package (Code Samples) | ||
| Using the UTL_FILE Package (Part 1) | ||
| Using the UTL_FILE Package (Part 2) | ||
| Using the UTL_FILE Package (Part 3) | ||
| Using the UTL_FILE Package (Code Samples) | ||
| Using the UTL_MAIL Package (Part 1) | ||
| Using the UTL_MAIL Package (Part 2) | ||
| Using the UTL_MAIL Package (Code Samples) | ||
| 16. | Miscellaneous PL/SQL Topics & Concepts (26 minutes) | Managing Security for Definer’s Rights and Invoker’s Rights (Part 1) |
| Managing Security for Definer’s Rights and Invoker’s Rights (Part 2) | ||
| Managing Security for Definer’s Rights and Invoker’s Rights (Code Samples) | ||
| 17. | Appendix (21 minutes) | Appendix 1: Oracle Database 12c Installation into Your Computer |
| Appendix 2: How to Unlock the HR Schema in the Oracle Database 12c? | ||
| Appendix 3: Configuring and Using Oracle SQL Developer for Oracle Database 12c | ||
| How to remove the database? | ||
| 18. | Bonus (29 seconds) | Bonus Lecture |
Resources Required
- Basic knowledge of Oracle SQL is needed.
Featured Review
Francisco Orquera Lorda (4/5) : The course was excellent and the explanation and examples were great!
Pros
- Jorge Ricardo Escobar Carrasco (5/5) : Best course on Oracle’s PL/SQL ever! This is indeed the Oracle master! — Update after completing the course.
- Jorge Ricardo Escobar Carrasco (5/5) : I just finished the course and now I do have superpowers at work, now I just need to find a way to give myself PERMISSIONS to install the MAIL package and send some awesome reports via email.
- David Martin (5/5) : Especially liked explanations of types, packages and subprograms and exception handling.
- Xiaogang Zhang (5/5) : This is the best course that i have took from udemy.
Cons
- David Ryan (1/5) : Even with CC it’s difficult to tell what is being said.
- Logan Black (1/5) : This should be stated in the title or at least at the beginning of the description.
- Timothy Parker (1/5) : If I wasn’t focusing so hard on what he was writing I would have no idea what he was talking about.
- Aaron Lewis (1/5) : I am having a hard time understanding the presenter due to his accent.
About the Author
The instructor of this course is Oracle Master Training which is a Oracle Architect & Best Selling Academy. With 4.5 Academy Rating and 43,921 Reviews on Udemy, Oracle Master Training offers 7 Courses and has taught 193,475 Students so far.
- Oracle Master Training Academy have more than 28 years of experience developing software using a variety of programming languages (such as C, C++, Java, C#, Python, PHP, etc.
- Oracle Master Training Academy have about 25+ years of experience using Oracle Technologies to programme SQL and PL/SQL.
- Oracle Master Training Academy manage a large database with over 20 million active users while also instructing students in a variety of programming languages, including Python, C, Java, PHP, and PL/SQL.
Comparison Table
| Parameters | The Complete PL/SQL Bootcamp : “Beginner to Advanced PL/SQL” | Advanced SQL : The Ultimate Guide | The Complete Oracle SQL Bootcamp (2023) |
|---|---|---|---|
| Offers | INR 499 ( | INR 455 ( | INR 455 ( |
| Duration | 26.5 hours | 14.5 hours | 38.5 hours |
| Rating | 4.5/5 | 4.3/5 | 4.6/5 |
| Student Enrollments | 62,267 | 37,754 | 68,798 |
| Instructors | Oracle Master Training | 200,000+ Students Worldwide | Oracle Master Training | 200,000+ Students Worldwide | Oracle Master Training | 200,000+ Students Worldwide |
| Register Here | Apply Now! | Apply Now! | Apply Now! |
Leave feedback about this