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.

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

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

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.

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.

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

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

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

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

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

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 lecture you will learn how to use case expressions and case statements in PL/SQL. These are the control structures like If statements.

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

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

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.

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

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 lecture you will learn how to operate data that you queried from a table.

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

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 lecture you will learn the difference between scalar data types and complex data types.

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

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

In this lecture you will learn what are PL/SQL collections and a brief explanation about the types of the collections.

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 lecture you will learn how to use PL SQL records with cursors including cursor type records.

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

Traffic lights

Read about what's good

what should give you pause

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

Comprehensive pl/sql for certification & skills

According to learners, this bootcamp provides a comprehensive and practical guide for mastering PL/SQL, suitable for both beginners and those aiming for advanced skills. Many highlight its effectiveness in preparing for Oracle certification exams (like 1Z0-149). Students appreciate the clear explanations, numerous real-world examples, and the emphasis on hands-on coding. The course structure, moving from basic concepts to complex topics like cursors, collections, and tuning, is frequently praised. Recent updates, including sections on Oracle-Supplied PL/SQL Packages and Dynamic SQL, demonstrate the instructor's commitment to keeping the content current, which learners view as a significant positive. While setting up the necessary environment can be a point of difficulty for some, the core lecture content and quizzes are widely seen as high quality and effective for skill development and exam preparation.

Regularly updated with new content.

"Great to see the course is actively maintained and updated with new sections like Oracle-Supplied Packages."

"The instructor keeps adding relevant content, showing a commitment to keeping the bootcamp current."

"I enrolled later and benefited from the recent lectures on Dynamic SQL and other additions."

Instructor explains concepts clearly.

"The instructor does a fantastic job of explaining complex topics in a clear and understandable way."

"Lectures are well-structured and easy to follow, even when covering difficult material."

"I really appreciated the step-by-step approach and clear explanations provided throughout the course."

Excellent preparation for Oracle exams.

"This course was instrumental in helping me pass the 1Z0-149 certification exam on my first try."

"The content aligns perfectly with the Oracle certification objectives. It's a great study resource."

"If your goal is to get certified, this bootcamp provides the necessary foundation and practice."

Lots of code samples and real-world demos.

"The strength of this course lies in the hundreds of real-world examples. It made applying the concepts much easier."

"I loved that every theoretical topic was immediately followed by practical code samples and demos."

"The hands-on coding exercises and practical scenarios were incredibly valuable for learning."

Suitable for beginners to advanced learners.

"The course really lives up to its name - it covers everything from the basics to pretty advanced concepts."

"As a beginner, I found the early sections very easy to follow. The advanced topics were challenging but well explained."

"Whether you're just starting or looking to deepen your PL/SQL knowledge, this bootcamp has something for you."

Database/environment installation can be tricky.

"Getting the Oracle database and SQL Developer set up was a bit of a struggle initially."

"The installation section could be clearer, I spent a lot of time troubleshooting the environment setup."

"Setting up the virtual machine and database was the most challenging part of the course for me."

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