Beginners guide Oracle PL/SQL Part 1

Name: Beginners guide Oracle PL/SQL Part 1
Rating: 4.4 (197 reviews)

Learn Basics of Oracle PL/SQL Part 1, A Crash Course on Oracle PL/SQL Part 1

Created byAly Dawood

Last updated 9/2025

English

English [Auto],

What you'll learn

What PL/SQL is.
LIVESQL
Variables
Variables Naming Rules & Conventions
Control Structures (IF,IF ELSE,FOR LOOP,WHILE LOOP)
Composite Data Types(Records,Varrays, Associative Arrays,Nested Tables)

Course content

8 sections • 40 lectures • 1h 54m total length

Introduction1:12
Explore the fundamentals of Oracle PL/SQL, including variables, if statements, case statements, loops and exception handling, and use PL/SQL blocks for CRUD operations and composite types.
Prerequisites0:52
WHY PART 1 and PART 20:18
NEED HELP ?0:03
Important0:37
Learn the basics of oracle pl/sql in a beginner’s guide part 1 through a crash course that highlights the most important topics within free content limits.

Variables7:00
Declare and initialize variables in a PL/SQL block to store numbers, strings, dates, and complex data types, then use assignments and dbms_output to display results.
Naming Rules & Conventions2:02
Master Oracle PL/SQL naming rules and conventions, including valid characters, case insensitivity, 30 character limit, prefixes, camel case, and uppercase constants for readability, maintainability, and reduced errors.
Using %TYPE Attribute4:17
QUIZ
Review0:08

What are Control Structures?0:50
Learn how sql control structures govern flow within blocks, subprograms, or packages. Use if and case for decisions, loops for iteration, and go to with exception handling for sequential control.
PLSQL IF Statement4:30
LAB IF Statments4:42
Case Statement1:26
Explore the case statement in PL/SQL as a concise conditional control structure that compares an expression to simple expressions to determine a result, with a simple example showing grade-based output.
LAB Case Statment2:43
Practice applying a case statement in PL/SQL by running a lab in live SQL, where two variables are assigned based on v_grade and the output reports the corresponding result.
Iterative Control (Loops)2:25
LAB Iterative Control2:25
GOTO Statement1:09
LAB GOTO Statement2:35
PLSQL Exception Handeling1:18
LAB Exception Handeling2:11
Practice exception handling in an Oracle PL/SQL lab by tracing a division by zero error and catching the zero divide exception, printing an error division by zero not allowed.
Quiz
Assigment 1: Using Basic Loop.0:03
Solution (Assigment 1): Using Basic Loop.0:05
Assignment 2 (FOR LOOP)0:04
Solution (Assignment 2 FOR LOOP)0:08
Assignment 3 (WHILE LOOP):0:03
Solution (Assignment 3 WHILE LOOP):0:04
DECLARE
v_counter NUMBER := 10;
BEGIN
WHILE v_counter <= 15 LOOP
DBMS_OUTPUT.PUT_LINE('Counter: ' || v_counter);
v_counter := v_counter + 1;
END LOOP;
END;

Using SQL in PL/SQL6:24
Execute sql queries, insertions, updates, and deletions within pl sql blocks, using declare variables, into clauses, and exception handling to manage no data found scenarios.
LAB Using SQL in PL/SQL22:18
Practice PL/SQL with SQL in Oracle Live SQL by copying HR schema tables and performing select into, insert, update, and delete operations, handling no data found and dbms output.
Assignment 1 : PL/SQL0:37
Solution Assignment 1 : PL/SQL0:36

Composite Data Types7:43
LAB Records10:05
Explore composite data types and records in Oracle PL/SQL lab, using dot notation and table%rowtype to fetch and display employee data, while avoiding common type and alignment errors.
LAB Associative Arrays6:44
LAB Nested Tables6:22
Explore declaring and initializing nested tables in Oracle PL/SQL, extending to multiple elements, and printing values with a for loop, plus an employee row example using a composite type.
LAB Varrays5:46

Requirements

Basic SQL Knowledge - basic SQL commands: SELECT, INSERT, UPDATE, DELETE
Basic Programming Concepts - control structures: loops (FOR, WHILE), conditional statements (IF, ELSE).
Basic Programming Concepts - Basic knowledge of functions and procedures.

Description

Course Overview: In this course, we will use Oracle LiveSQL, a free and accessible platform, to practice and hone our PL/SQL skills without the need to install any software. This approach allows us to focus entirely on learning PL/SQL rather than dealing with installation issues.

What You Will Learn:

Introduction to PL/SQL:
- Understand the basics of PL/SQL and how it integrates with SQL.
- Learn the advantages of using PL/SQL with Oracle databases.
PL/SQL Blocks and Syntax:
- Explore the structure of PL/SQL blocks, including anonymous blocks, procedures, and functions.
- Write and execute your first PL/SQL block.
Control Structures:
- Master control structures such as IF statements, loops, and CASE statements to create dynamic and flexible code.
SQL in PL/SQL:
- Learn how to embed SQL statements within PL/SQL blocks for seamless data manipulation.
- Perform CRUD operations (Create, Read, Update, Delete) using PL/SQL.
Error Handling:
- Implement robust error handling techniques using EXCEPTION blocks.
- Learn to catch and handle predefined and user-defined exceptions.
Composite Data Types:
- Explore records and collections to handle complex data structures.
- Use associative arrays, nested tables, and VARRAYs in your PL/SQL programs.
Practical Examples and Assignments:
- Gain hands-on experience with practical examples and assignments designed to reinforce your learning.
- Work through real-world scenarios, such as salary calculations and employee management.

Course Projects: Throughout the course, you will work on several mini-projects:

Creating a copy of the employees table and performing operations on it.
Inserting, updating, selecting, and deleting records using PL/SQL.
Implementing error handling and using cursors for data retrieval.

Course Structure: This course is divided into two parts due to Udemy's new rule limiting free video length to a maximum of 2 hours. The complete course would take 4-6 hours, so I decided to split it into two parts. Part 2 will be completed by July 15.

By the end of this course, you will have a solid understanding of PL/SQL and be able to write efficient and maintainable PL/SQL code for Oracle databases. Whether you are a beginner or looking to enhance your database programming skills, this course is designed to meet your needs. Join us and start your journey to mastering PL/SQL today!

Who this course is for:

SQL Developers
Programmers

Beginners guide Oracle PL/SQL Part 1

What you'll learn

Explore related topics

Course content

Introduction5 lectures • 3min

LIVE SQL2 lectures • 1min

What is PLSQL?1 lecture • 3min

Variables in PLSQL4 lectures • 13min

Control Structures17 lectures • 27min

Using SQL in PL/SQL4 lectures • 30min

Composite Data Types5 lectures • 37min

Thank You and See you in Part 22 lectures • 1min

Requirements

Description

Who this course is for: