HOT
blank

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

Development

Rating4.5
Enroll Now

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 didn't 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: Let's 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

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!

You may also like

Top 10 Ethical AI Courses to Learn in November 2024

Top 10 Game Development Courses to Learn in November 2024

Top 10 Software Testing Courses to Learn in November 2024