PL/SQL by Example - Beginner to Advanced PL/SQL

Using PL/SQL learn how to combine the efficiency of SQL & Procedural Language(PL) to build a powerful PL/SQL Application

4.46 (15760 reviews)

Udemy

platform

English

language

Oracle

What you will learn

Declare PL/SQL Variables

Conditionally control code flow (loops, control structures)

Use some of the Oracle supplied PL/SQL packages to generate screen output

Create anonymous PL/SQL blocks, functions and procedures

Use PL/SQL packages to group and contain related constructs

Catch run time errors using Exceptions

Perform Data processing using Records and Cursors

Manage data using Collections

Create triggers to solve business challenges

Peform Bulk Processing to improve performance

Execute SQL using Dynamic SQL

Pipelining the data as it is processed

Working with Large Objects (LOB's)

Why take this course?

Learn to become a PL/SQL developer in just four weeks.

This fast, easy and effective course will take you from zero PL/SQL writing skills to being able to write efficient programs to process data.

PL/SQL is the Oracle Procedural Language extension of SQL. A PL/SQL program can have both SQL statements and procedural statements. In the PL/SQL program, the SQL statements are used to access sets of data stored in a database, while the procedural statements are used to process individual piece of data and control the program flow.

In this course participants will learn

Describe the features and syntax of PL/SQL
Design PL/SQL anonymous blocks that execute efficiently
Use the Oracle supplied PL/SQL packages to generate screen output
Create and debug Stored Procedures and Functions
Design PL/SQL packages to group related constructs
Use PL/SQL programming constructs and conditionally control code flow
Create overloaded package subprograms for more flexibility
Handle runtime errors using Exceptions
Writing manageable code using Records
Storing and processing data using Collections
Processing data using Implicit and Explicit Cursors

Softwares used

Oracle Database 11g
SQL Developer

Reviews

Jaganathan

March 26, 2024

very good for some one who needs to get foundational kickstart with easy understanding, and for some one who needs some brush up with no recent experience.

Sanjay

November 10, 2023

Awesome, I am very happy & feeling luck to have such wonderful tutorial. Great content. Must recommended for PLSQL learners.

Jonathan

November 6, 2023

Really great course that does not take a tremendous amount of time, but covers the bases around PL/SQL. Pl/SQL is a procedural language within an Oracle Database, but this course also brings in concepts from plain SQL itself (like Triggers, Cursors, etc.) Many helpful points about the benefits of using PL/SQL and how to manage it relative to the SQL statements that may be inside it. Good course for a Database Administrator, but also for a Developer, since many important conventions and features found in other programming languages are also present in PL/SQL (Exceptions, Loops, composite datatypes, packages/libraries, etc.)

Marioalberto

October 26, 2023

Si me ha servido de mucho. El unico detalle que veo es que el traductor cambia muchas palabras. Pero entiendo y agradezco de mucho al traduccicón

Manisha

October 18, 2023

Yes. it is very good learning journey. explanation is simple and more expressive. we learn lots of new things.

Mustafa

October 12, 2023

That's solved my conflict problems about some of SQL topics. Teacher's expression is clear and understandable.

Anuar

October 5, 2023

The examples and explanations provided in this course have been excellent. While I had some prior knowledge on the subject, this course has helped me gain a much deeper understanding and clarity.

Slaven

September 25, 2023

All steps are explained in detail. I like that the lessons last a few minutes. I like that everything is supported by examples.

Beauty

September 21, 2023

Its awesome to attend the Training which is so simple to understand and covering each aspects very well.

Alex

September 20, 2023

My expectation is to learn PL/SQL and applied it in my projects..And so far I am glad that the instructor is explaining the concepts clearly in a manner that is easily understandable

Sai

March 1, 2023

The resources are not provided for some modules. The exercises are not even understandable. This course literally confuses my knowledge on Oracle sql.

Bhakta

February 24, 2023

Yes really liking the course and it is actually very helpful in clearing all basic to advance concepts in PLSQL

Shubham

February 20, 2023

Its a great way of explaining from scratch, should include quizzes in between lectures of mcq pattern

Rafael

January 19, 2023

Course contents are good, but teacher intonation used when speaking is just awful, it makes really difficult to focus en the course.

Saroja

January 4, 2023

Very much loved this course and the pace of explanation. Very detailed instructions on installing the required components.

Charts

Price

Rating

Enrollment distribution

PL/SQL by Example - Beginner to Advanced PL/SQL - Distribution chart