The Complete PLSQL Bootcamp - "Beginner to Advanced PLSQL"

The Complete PL/SQL Bootcamp : Beginner to Advanced PL/SQL, available at $149.99, has an average rating of 4.5, with 208 lectures, 15 quizzes, based on 16126 reviews, and has 88094 subscribers.

You will learn about 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! This course is ideal for individuals who are Anyone who wants to learn PL/SQL Programming Language or Anyone who is looking for Beginner PL/SQL Subjects or Anyone who is looking for Advanced PL/SQL Subjects or Anyone who wants to pass Oracle 1Z0-144 Program with PL/SQL Exam or Anyone who wants to pass Oracle 1Z0-148 Advanced PL/SQL Exam or Anyone who wants to pass Oracle 1Z0-149: Program with PL/SQL Exam with Oracle Database 19c or SQL Developers (All Levels) or Beginner & Intermediate PL/SQL Developers or Database Administrators or Application Designers or Software Developers It is particularly useful for Anyone who wants to learn PL/SQL Programming Language or Anyone who is looking for Beginner PL/SQL Subjects or Anyone who is looking for Advanced PL/SQL Subjects or Anyone who wants to pass Oracle 1Z0-144 Program with PL/SQL Exam or Anyone who wants to pass Oracle 1Z0-148 Advanced PL/SQL Exam or Anyone who wants to pass Oracle 1Z0-149: Program with PL/SQL Exam with Oracle Database 19c or SQL Developers (All Levels) or Beginner & Intermediate PL/SQL Developers or Database Administrators or Application Designers or Software Developers.

Enroll now: The Complete PL/SQL Bootcamp : Beginner to Advanced PL/SQL

Summary

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

Price: $149.99

Average Rating: 4.5

Number of Lectures: 208

Number of Quizzes: 15

Number of Published Lectures: 207

Number of Published Quizzes: 14

Number of Curriculum Items: 225

Number of Published Curriculum Objects: 221

Original Price: $199.99

Quality Status: approved

Status: Live

What You Will 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!

Who Should Attend

Anyone who wants to learn PL/SQL Programming Language

Anyone who is looking for Beginner PL/SQL Subjects

Anyone who is looking for Advanced PL/SQL Subjects

Anyone who wants to pass Oracle 1Z0-144 Program with PL/SQL Exam

Anyone who wants to pass Oracle 1Z0-148 Advanced PL/SQL Exam

Anyone who wants to pass Oracle 1Z0-149: Program with PL/SQL Exam with Oracle Database 19c

SQL Developers (All Levels)

Beginner & Intermediate PL/SQL Developers

Database Administrators

Application Designers

Software Developers

Target Audiences

Anyone who wants to learn PL/SQL Programming Language

Anyone who is looking for Beginner PL/SQL Subjects

Anyone who is looking for Advanced PL/SQL Subjects

Anyone who wants to pass Oracle 1Z0-144 Program with PL/SQL Exam

Anyone who wants to pass Oracle 1Z0-148 Advanced PL/SQL Exam

Anyone who wants to pass Oracle 1Z0-149: Program with PL/SQL Exam with Oracle Database 19c

SQL Developers (All Levels)

Beginner & Intermediate PL/SQL Developers

Database Administrators

Application Designers

Software Developers

Latest Course Updates:

(Aug 2024) : “Oracle-Supplied PL/SQL Packages” 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/SQL Programming 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/SQL Coding Skills

SQL & PL/SQL Performance

PL/SQL Scalability

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/SQL Programming Bootcamp Covers:

PL/SQL Terminologies

PL/SQL Architecture

PL/SQL Variables

PL/SQL Control Structures

If-Then-Else Structure

Case Expressions

Loops

While Loop

For Loop

Nested Loop

Loop Labeling

Continue Statement

GOTO Statement

Using SQL inside PL/SQL

PL/SQL Cursors

Using PL/SQL Program Units (Functions & Procedures)

PL/SQL Packages

PL/SQL Exceptions & Exception Handling

PL/SQL Debugging

Dynamic SQL & PL/SQL

PL/SQL Composite Data Types (Collections)

Associative Arrays

Nested Tables

Varrays

Records

PL/SQL Triggers

Oracle-Supplied Packages

Using Large Objects in PL/SQL (LOBs)

Using PL/SQL Object Oriented

Using PL/SQL Compiler

PL/SQL Performance &Tuning

PL/SQL Caching

PL/SQL Security

PL/SQL Fine-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!

Course Curriculum

Chapter 1: What is PL/SQL ?

Lecture 1: Course Introductory Video

Lecture 2: UDEMY 101: How to Use Udemy? +Some Useful Tips

Lecture 3: What is PL/SQL and Why to Use?

Lecture 4: PL/SQL Architecture

Lecture 5: What is Pluggable Database?

Lecture 6: The Sample (HR) Schema Used in This Course

Lecture 7: Welcoming Gifts: Course Material & PL/SQL Cheatsheet

Chapter 2: Software Installation

Lecture 1: About the Database Installation

Lecture 2: The Ways to Get a Database

Lecture 3: Option 1: Installing VMware and VirtualBox on Windows

Lecture 4: Option 1: How to Install the Virtual Box on Mac OS X?

Lecture 5: Option 1: Downloading Virtual Machine Image(19c)

Lecture 6: Option 1: Downloading Virtual Machine Image(If the previous lecture didnt work)

Lecture 7: Option 1: Configuring the VMware Virtualization Software

Lecture 8: Option 1: Configuring the Oracle VirtualBox Virtualization Software

Lecture 9: Option 1: Configuring SQL Developer inside of the Virtual Machine

Lecture 10: Important Note

Lecture 11: Option 2: Downloading and Installing the Oracle Database

Lecture 12: Option 2: Unlocking the HR Schema

Lecture 13: Option 2: Configuring and Using the SQL Developer

Lecture 14: Option 2: Installing Sample Schemas in Oracle Database

Lecture 15: Option 2: HR Schema Create Code (if you could not get the HR user in other ways)

Lecture 16: Option 3: Using Oracle Live SQL

Lecture 17: Option 3: About Oracle Live SQL Restrictions

Chapter 3: Lets Start Coding!

Lecture 1: Anonymous Blocks

Lecture 2: PL/SQL Outputs

Chapter 4: PL/SQL Variables

Lecture 1: What are Variables and Why to Use Them?

Lecture 2: Naming Rules & Naming Conventions

Lecture 3: Declaring & Initializing & Using Variables – Part 1

Lecture 4: Declaring & Initializing & Using Variables – Part 2

Lecture 5: Declaring & Initializing & Using Variables (Code Samples)

Lecture 6: Using %TYPE Attribute

Lecture 7: Using %Type Attribute (Code Samples)

Lecture 8: PL/SQL Delimiters and Commenting Your Code

Lecture 9: PL/SQL Delimiters and Commenting (Code Samples)

Lecture 10: PL SQL Variable Scope

Lecture 11: PL SQL Variable Scope (Code Samples)

Lecture 12: Using Bind Variables

Lecture 13: Using Bind Variables (Code Samples)

Chapter 5: Control Structures

Lecture 1: What are Control Structures & IF Statements

Lecture 2: What are Control Structures & IF Statements (Code Samples)

Lecture 3: Case Expressions

Lecture 4: Case Expressions (Code Samples)

Lecture 5: What are Loops – Basic Loops

Lecture 6: Basic Loops (Code Samples)

Lecture 7: While Loops

Lecture 8: While Loops (Code Samples)

Lecture 9: For Loops

Lecture 10: For Loops (Code Samples)

Lecture 11: Nested Loops & Loop Labeling

Lecture 12: Nested Loops & Loop Labeling (Code Samples)

Lecture 13: Continue Statement

Lecture 14: Continue Statement (Code Samples)

Lecture 15: GOTO Statement

Lecture 16: GOTO Statement (Code Samples)

Chapter 6: Using SQL in PL/SQL

Lecture 1: Operating with Selected Database Data..

Lecture 2: Operating With Selected Queries (Code Samples)

Lecture 3: DML Operations in PL/SQL

Lecture 4: DML Operations in PL/SQL (Code Samples)

Lecture 5: Using Sequences in PL/SQL

Lecture 6: Using Sequences in PL/SQL (Code Samples)

Lecture 7: Extra – Enabling Server Outputs by Default

Chapter 7: Composite Data Types

Lecture 1: Simple Data Types vs Composite Data Types

Lecture 2: PL/SQL Records – Part 1

Lecture 3: PL/SQL Records – Part 2

Lecture 4: PL/SQL Records (Code Samples)

Lecture 5: Easy DML With Records

Lecture 6: Easy DML With Records (Code Samples)

Lecture 7: What Are Collections?

Lecture 8: Varrays & Collection Methods

Lecture 9: Varrays (Code Samples)

Lecture 10: Nested Tables

Lecture 11: Nested Tables (Code Samples)

Lecture 12: PL&SQL Associative Arrays (Part 1)

Lecture 13: PL&SQL Associative Arrays (Part 2)

Lecture 14: Associative Arrays (Code Samples)

Lecture 15: Storing Collections in Tables – (Part 1)

Lecture 16: Storing Collections in Tables – (Part 2)

Lecture 17: Storing Collections in Tables (Code Samples)

Chapter 8: PL/SQL Cursors

Lecture 1: What are Cursors and Cursor Types in PL SQL?

Lecture 2: Using Explicit Cursors

Lecture 3: Using Explicit Cursors (Code Samples)

Lecture 4: Using Cursors with Records

Lecture 5: Cursors with Records (Code Samples)

Lecture 6: Looping with Cursors

Lecture 7: Looping with Cursors (Code Samples)

Instructors

Database Masters Training | 250,000+ Students Worldwide
Best Seller SQL, Oracle, PL/SQL, Java Programming Courses

Code Star Academy
Software Training Center | Over 250.000+ Successful Students

Rating Distribution

1 stars: 176 votes

2 stars: 238 votes

3 stars: 1658 votes

4 stars: 5989 votes

5 stars: 8065 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!