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.

Learner reviews

These reviews are from learners who bought the content and completed at least 50% of it — there are no reviews from anyone who hasn't gone through the material.
4.9
★★★★★
96 reviews
5★
87
4★
8
3★
1
2★
0
1★
0

    Course content

    1

    Introduction and Basics of PL/SQL

    2 lectures
    1. General Introduction to Programming and Databases21:14
    2. Understanding PL/SQL Language, Features, and Uses10:07
    2

    Building Programming Basics

    3 lectures
    1. Handling Variables in PL/SQL18:59
    2. Writing Executable Statements in PL/SQL14:49
    3. Using SQL Statements Inside PL/SQL Blocks13:10
    3

    Control Structures

    3 lectures
    1. Creating Control Structures for Programming Decisions11:40
    2. Programming Loops - Part One11:53
    3. Programming Loops - Part Two9:06
    4

    Composite Data Types

    2 lectures
    1. Introduction to Composite Data Types12:56
    2. Advanced Practical Applications on Composite Data5:36
    5

    Explicit Cursors

    2 lectures
    1. Understanding Explicit Cursors and Their Uses - Part One18:00
    2. Advanced Applications for Explicit Cursors - Part Two5:02
    6

    Exception Handling and Creating Procedures and Functions

    6 lectures
    1. Managing and Handling Errors and Exceptions in PL/SQL15:21
    2. Introduction to Procedures and Functions in Databases13:07
    3. Introduction to the Advanced Practical Workshop3:06
    4. Creating Procedures - Part One12:08
    5. Creating Procedures - Part Two12:53
    6. Creating and Using Functions11:40
    7

    Packages

    2 lectures
    1. Introduction to Software Packages and Their Creation9:05
    2. Advanced Practical Applications on Software Packages5:12
    8

    Triggers

    3 lectures
    1. Introduction to Triggers and Their Basic Uses13:57
    2. Advanced Applications on Triggers - Part One26:07
    3. Advanced Applications on Triggers - Part Two12:29

    Instructor

    Eng. Azab Mohamed Azab

    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.
    14.7K students28 courses