Oracle PL/SQL Database Programming

Enhance Your Database Programming Skills

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

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.
7,309 students28 courses

Related courses

  • Microsoft Access
    4.6|5,337|0h 0m

    Microsoft Access

    Learn to Create Databases and Reports

    Ahmed Hassan Khamis
    Ahmed Hassan Khamis
    $19.99
    Buy now
  • Key Logger Spyware Design
    4.5|5,026|0h 0m

    Key Logger Spyware Design

    Spyware Design Using C++ Language

    Eng. Mohamed Ali Mansour
    Eng. Mohamed Ali Mansour
    $19.99
    Buy now
  • Adobe Animate & Action Script
    4.7|6,962|16h 58m

    Adobe Animate & Action Script

    Learn to Create Cartoon Films and Interactive Games

    Ahmed Hassan Khamis
    Ahmed Hassan Khamis
    $19.99
    Buy now
  • Deep Learning
    4.5|5,162|12h 40m

    Deep Learning

    Simulating the Human Mind in Thinking

    Eng. Amr Abdel Fattah
    Eng. Amr Abdel Fattah
    $25.99
    Buy now