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

What's inside

Learning objectives

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!
Show more
Show less

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!
Show more
Show less

Syllabus

This lesson is an introduction to PL/SQL and why you should use Oracle PL/SQL.

Course Introductory Video

This lecture is about how to use the Udemy platform. And also includes some useful tips to get most of out the course.

This lesson explains you about what is PL/SQL and Why you should choose PL/SQL as a Programming Language.

PL/SQL Architecture

In this lecture, students are going to learn what the pluggable database, in other words, multitenant architecture is in Oracle Database.

The Sample (HR) Schema Used in This Course

Welcoming Gifts: Course Material & PL/SQL Cheatsheet

This Quiz is about the first lecture. What is PL/SQL and Why to Use it and PL/SQL Architecture.

Students are going to learn how to install the Oracle Database and required softwares for PL/SQL Development.

About the Database Installation

In this SQL tutorial, the participants will learn how to get a database to proceed with The Complete PL/SQL Bootcamp: "Beginner to Advanced PL/SQL" course.

In this SQL tutorial, the participants will learn how to download and install two virtualization software programs which are VMware and VirtualBox step by step.

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

In this tutorial, the participants will learn how to download the virtual machine image 19c.

In this tutorial, the participants will learn how to download the virtual machine image.

In this SQL tutorial, the participants will learn how to import the virtual machine image they downloaded into the VMware virtualization software as well as how to configure the virtual machine to get the most out of it.

In this SQL tutorial, the participants will learn how to import the virtual machine image they downloaded into the Oracle VirtualBox virtualization software as well as how to configure the virtual machine to get the most out of it.

In this SQL tutorial, the participants will learn how to configure Oracle SQL Developer inside of the Virtual Machine image that they downloaded step by step.

For the students who could succeed to complete the Option-1

In this lecture, students are going to learn the oracle database 19c installation.

Lecture keywords: "oracle", "oracle sql", "oracle database", "oracle database installation", "oracle database 19c installation".

In this lecture, our students are going to learn how to unlock the HR schema to practice throughout the course.

This lecture covers how to download and configure Oracle SQL Developer software and how to connect to the Oracle Database 19c.

In this tutorial, the course participants will learn about the easiest way how to install Oracle Sample Schemas to be able to work with many database sample schemas provided by Oracle.

This code includes the required SQL script to generate the HR schema with all its data.

Note 1: You can use this script if you could not have the HR schema properly.

Note 2: Just select all of the scripts and execute them in one step when connected as the SYS or SYSTEM user.

Option 3: Using Oracle Live SQL

Option 3: About Oracle Live SQL Restrictions

This section is about block structure of PL/SQL and outputting. You will write your first sample code in this section..

Anonymous Blocks

PL/SQL Outputs

This Quiz is about the anonymous blocks and PL/SQL Outputs

In this section you will learn how to declare, initialize and use PL/SQL Variables.

What are Variables and Why to Use Them?

Naming Rules & Naming Conventions

In this lecture you will learn how to use variables with different ways.

Declaring & Initializing & Using Variables (Code Samples)

In this lecture, you will learn how to use %TYPE operator to automatically assign the datatype.

Using %Type Attribute (Code Samples)

In this lesson you will learn how to use delimiters and how to write comments and why to use them.

PL/SQL Delimiters and Commenting (Code Samples)

This lecture is about the scopes of variables in the blocks.

PL SQL Variable Scope (Code Samples)

In this lesson you will learn a performance variable, bind variables.

These are the codes that we used in Using Bind Variables Lesson

In this quiz, you will find multiple choice questions about the PL/SQL Variables.

In this section you will learn how to use loops and if - case statements

What are Control Structures & IF Statements

What are Control Structures & IF Statements (Code Samples)

In this lecture you will learn how to use case expressions and case statements in PL/SQL. These are the control structures like If statements.

Case Expressions (Code Samples)

In this lecture you will learn the loops terminology and how to use basic loops in PL/SQL..

Basic Loops (Code Samples)

In this lecture you will learn how to use while loops of PL/SQL..

While Loops (Code Samples)

For Loops

For Loops (Code Samples)

In this lecture you will learn how to use a loop inside another one and exiting the outer loop with using labels in PL/SQL.

Nested Loops & Loop Labeling (Code Samples)

In this lecture you will learn how to use continue statement in PL/SQL Loops

Continue Statement (Code Samples)

GOTO Statement

Here you will find the codes of the examples that we did in our GOTO Statement lecture..

In this quiz you will find multiple choice quiz questions about the control strucures like if clause, loops, etc.

In this section you will learn how to use SQL Queries and DML-DDL Operations with the help of PL/SQL

In this lecture you will learn how to operate data that you queried from a table.

Operating With Selected Queries (Code Samples)

In this lecture, you will see how to insert, update and delete data in your tables with the help of PL/SQL.

DML Operations in PL/SQL (Code Samples)

You will learn how to use sequence objects in PL/SQL

In this lecture you will learn how to use sequences in PL/SQL with different ways.

In this lecture you will learn how to make set serveroutput on command run automatically to enable server output.

This quiz will test your knowledge on using SQL in PL/SQL code

In this section you will learn how to use composite data types like arrays, types, collections etc.

In this lecture you will learn the difference between scalar data types and complex data types.

PL/SQL Records - Part 1

In this lecture, you will learn how to create a complext type and a real-world like example about PL/SQL Records

PL/SQL Records (Code Samples)

With this lecture, you will learn how to insert or update the data in your table with using records, easily.

Easy DML With Records (Code Samples)

In this lecture you will learn what are PL/SQL collections and a brief explanation about the types of the 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)

Here is the code samples that we used in composite data types section.

This quiz will test your knowledge on using Composite Data Types in PL/SQL

In this section you will learn how to use PL/SQL Cursors to walk around the bulk data row by row.

What are Cursors and Cursor Types in PL SQL?

Using Explicit Cursors

Using Explicit Cursors (Code Samples)

In this lecture you will learn how to use PL SQL records with cursors including cursor type records.

Cursors with Records (Code Samples)

In this lecture you will learn how to loop with PL SQL cursors in many different ways.

In this article you will find the sample codes that we did in "Looping with Cursors" lecture

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Comprehensive course covering a variety of PL/SQL subjects, from foundational to advanced

Ideal for students with a strong interest in learning PL/SQL for building a career as an Oracle PL/SQL Developer Certified Professional

Covers crucial aspects for enhancing PL/SQL skills, such as improving coding skills, optimizing SQL and PL/SQL performance, and ensuring scalability

Prepares students for Oracle Database 19c: Program with PL/SQL certification exam and other relevant certifications

Includes real-world examples for every subject, ensuring practical relevance and application

Reviews summary

Pronounciation difficulties

According to students, there are difficulties with the pronunciation of the instructor. This accent may cause confusion while watching the course at higher speeds and may require learners to slow down the playback speed in some cases.

Instructor's pronunciation may be difficult to understand.

"The pronounciation of the instructor is very heavy accented."

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in The Complete PL/SQL Bootcamp : "Beginner to Advanced PL/SQL" with these activities:

Mentor Junior PL/SQL Developers

Show steps

Share your PL/SQL knowledge and experience by mentoring junior developers, reinforcing your own understanding and contributing to the community.

Show steps

Identify opportunities to mentor others, such as online forums or local meetups.
Provide guidance, support, and encouragement to mentees.
Review and evaluate mentees' work, offering constructive feedback.

Show all one activities

Career center

Learners who complete The Complete PL/SQL Bootcamp : "Beginner to Advanced PL/SQL" will develop knowledge and skills that may be useful to these careers:

Database Administrator

Database Administrators are the backbone of any organization that relies on data. They are responsible for the installation, configuration, maintenance, and security of databases. This course will help you build a strong foundation in PL/SQL, a powerful programming language used to manage and manipulate data in Oracle databases. With this knowledge, you will be well-equipped to design, develop, and implement efficient database solutions.

See salaries and explore the career path for Database Administrator

Data Analyst

Data Analysts play a crucial role in transforming raw data into actionable insights for businesses. This course will provide you with a solid understanding of PL/SQL, which is widely used in data analysis and manipulation. You will learn how to extract, transform, and analyze data using PL/SQL, empowering you to derive meaningful insights and make informed decisions.

See salaries and explore the career path for Data Analyst

Software Engineer

Software Engineers are in high demand due to the increasing reliance on technology. This course will help you develop the skills necessary to become a proficient Software Engineer, particularly in the area of database development. You will gain expertise in PL/SQL, a key language for building and maintaining database applications, and learn best practices for software development.

See salaries and explore the career path for Software Engineer

Database Architect

Database Architects are responsible for designing and implementing the architecture of databases. This course will provide you with a comprehensive understanding of PL/SQL, a language specifically designed for database programming. You will learn how to use PL/SQL to create efficient and scalable database solutions, meeting the complex requirements of modern data-driven applications.

See salaries and explore the career path for Database Architect

Data Scientist

Data Scientists combine their knowledge of statistics, programming, and data analysis to extract insights from data. This course will introduce you to PL/SQL, a powerful language for data manipulation and analysis. By learning PL/SQL, you will enhance your ability to handle large datasets, perform complex data transformations, and develop predictive models, enabling you to make data-driven decisions.

See salaries and explore the career path for Data Scientist

Business Analyst

Business Analysts help organizations improve their performance through data analysis and process optimization. This course will provide you with a valuable skill set in PL/SQL, a language commonly used in business intelligence and data analysis. You will learn how to use PL/SQL to extract and analyze data, identify trends, and make recommendations that drive informed decision-making.

See salaries and explore the career path for Business Analyst

Information Security Analyst

Information Security Analysts are responsible for protecting an organization's data and systems from cyber threats. This course will provide you with a foundational understanding of PL/SQL, a language used in developing secure database applications. You will learn how to implement security measures, prevent data breaches, and ensure the confidentiality and integrity of sensitive data.

See salaries and explore the career path for Information Security Analyst

Data Engineer

Data Engineers are responsible for building and maintaining the infrastructure that supports data analysis and reporting. This course will provide you with a solid foundation in PL/SQL, a language commonly used in data engineering. You will learn how to use PL/SQL to create and manage data pipelines, perform data integration, and ensure data quality, enabling you to support data-driven decision-making.

See salaries and explore the career path for Data Engineer

Technical Writer

Technical Writers create documentation and instructions for software and technology products. This course will help you develop the skills necessary to become a proficient Technical Writer, particularly in the area of database documentation. You will gain expertise in PL/SQL, a key language for database development, and learn best practices for technical writing, enabling you to produce clear and concise documentation that supports users.

See salaries and explore the career path for Technical Writer

IT Auditor

IT Auditors evaluate the security and efficiency of computer systems and networks. This course will provide you with a valuable skill set in PL/SQL, a language commonly used in database auditing and compliance. You will learn how to use PL/SQL to perform database audits, assess security vulnerabilities, and ensure compliance with regulatory standards.

See salaries and explore the career path for IT Auditor

Systems Analyst

Systems Analysts study and analyze an organization's systems and procedures to identify areas for improvement. This course will provide you with a solid understanding of PL/SQL, a language used in developing and maintaining business applications. You will learn how to use PL/SQL to automate processes, improve efficiency, and support the organization's overall goals.

See salaries and explore the career path for Systems Analyst

Quality Assurance Analyst

Quality Assurance Analysts test and evaluate software products to ensure they meet quality standards. This course will provide you with a valuable skill set in PL/SQL, a language commonly used in software testing and debugging. You will learn how to use PL/SQL to perform unit testing, integration testing, and performance testing, ensuring the reliability and quality of software applications.

See salaries and explore the career path for Quality Assurance Analyst

Project Manager

Project Managers plan, execute, and complete projects successfully. This course may be useful for Project Managers who are involved in database development projects. You will gain a basic understanding of PL/SQL, a language used in database programming, enabling you to communicate effectively with technical team members and make informed decisions about the project's scope and timelines.

See salaries and explore the career path for Project Manager

Computer Programmer

Computer Programmers write and maintain the code that makes computers work. This course may be useful for Computer Programmers who are interested in specializing in database development. You will gain a basic understanding of PL/SQL, a language used in database programming, enabling you to contribute to the development and maintenance of database applications.

See salaries and explore the career path for Computer Programmer

Software Tester

Software Testers evaluate the functionality and performance of software applications. This course may be useful for Software Testers who are involved in testing database applications. You will gain a basic understanding of PL/SQL, a language used in database programming, enabling you to test the functionality and performance of database applications more effectively.

See salaries and explore the career path for Software Tester