Oracle PL/SQL Database Programming

Enhance Your Database Programming Skills

4.9(96)4h 47m23 lectures8 sections

What you'll learn

Understand basic PL/SQL concepts
Master writing executable statements
Learn to use control structures
Handle composite data types
Effectively manage exceptions
Create procedures, functions, and triggers

About this course

This course provides you with a deep and comprehensive understanding of database programming using Oracle PL/SQL. You will learn the fundamentals of the language, writing executable statements, using control structures, handling exceptions, and creating procedures, functions, packages, and triggers. The course offers intensive hands-on training that enhances your skills and prepares you to work as a professional PL/SQL developer.

Expected outcomes

Master the skills of writing PL/SQL code professionally.
Ability to create procedures, functions, packages, and triggers in Oracle databases.
Develop the ability to solve programming problems using PL/SQL.
Readiness to work as a professional PL/SQL developer in corporate environments.

Course content

Introduction and Basics of PL/SQL

2 lectures

Building Programming Basics

3 lectures

Handling Variables in PL/SQL18:59
Writing Executable Statements in PL/SQL14:49
Using SQL Statements Inside PL/SQL Blocks13:10

Control Structures

3 lectures

Creating Control Structures for Programming Decisions11:40
Programming Loops - Part One11:53
Programming Loops - Part Two9:06

Composite Data Types

2 lectures

Introduction to Composite Data Types12:56
Advanced Practical Applications on Composite Data5:36

Explicit Cursors

2 lectures

Understanding Explicit Cursors and Their Uses - Part One18:00
Advanced Applications for Explicit Cursors - Part Two5:02

Exception Handling and Creating Procedures and Functions

6 lectures

Managing and Handling Errors and Exceptions in PL/SQL15:21
Introduction to Procedures and Functions in Databases13:07
Introduction to the Advanced Practical Workshop3:06
Creating Procedures - Part One12:08
Creating Procedures - Part Two12:53
Creating and Using Functions11:40

Packages

2 lectures

Introduction to Software Packages and Their Creation9:05
Advanced Practical Applications on Software Packages5:12

Triggers

3 lectures

Introduction to Triggers and Their Basic Uses13:57
Advanced Applications on Triggers - Part One26:07
Advanced Applications on Triggers - Part Two12:29

Instructor

Eng. Azab Mohamed Azab

Lecturer at the Arab Academy for Science, Technology and Maritime Transport, and the Egyptian Ministry of Interior, specializing in technology and information.

3,945 students28 courses

Related courses

4.9(76)|1,002|2h 42m
Microsoft Access
Learn to Create Databases and Reports
Ahmed Hassan Khamis
$19.99
Start your journey now
4.4(82)|715|16h 18m
Key Logger Spyware Design
Spyware Design Using C++ Language
Eng. Mohamed Ali Mansour
$19.99
Start your journey now
4.7(74)|2,667|17h 30m
Adobe Animate & Action Script
Learn to Create Cartoon Films and Interactive Games
Ahmed Hassan Khamis
$19.99
Start your journey now
4.4(90)|863|12h 40m
Deep Learning
Simulating the Human Mind in Thinking
Eng. Amr Abdel Fattah
$25.99
Start your journey now