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.53 (19251 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)

Charts

Students

Price

Rating & Reviews

Enrollment Distribution

Comidoc Review

Our Verdict

This 5.5-hour PL/SQL course with a global rating of 4.53 stands out among other Udemy offerings, thanks to its engaging and concise approach, merging procedural language efficiency with powerful SQL applications within Oracle databases. However, it assumes some SQL expertise, doesn't provide all resources for exercises, and features an occasionally challenging accent. Nonetheless, combining the course's practical examples and strong focus on fundamentals through advanced topics prepares learners well for employing PL/SQL in real-world applications.

What We Liked

Comprehensive coverage of PL/SQL concepts, ranging from basics like variables and control structures to advanced topics such as triggers, bulk processing, and large object handling
Practical examples and real-world problems help reinforce learning, focusing on both SQL and procedural aspects of PL/SQL
Instructor explains complex topics smoothly, making it easy for learners with any programming background to follow along
A significant number of clear explanations about the underlying processes and architecture

Potential Drawbacks

Some lessons require prior knowledge of SQL or Oracle Development, which might hinder complete understanding for true beginners
Absence of latest updates by instructor may affect immediate clarification of queries or issues
Distribution of exercises varies and lack of downloadable resources increases dependency on video presentation for some users
Accent and pronunciation could pose a minor challenge to focus on the content, especially in lengthy sessions