Oracle PL/SQL | Ingress Academy
For individuals For business Jobs & hiring
Career Paths Courses Why Us Instructors Blog
az en ru
Portal

Database Management

Oracle PL/SQL

Master Oracle PL/SQL programming to automate and enhance database operations. Topics include stored procedures, functions, triggers, and exception handling. This course helps developers optimize database interactions for enterprise applications. Training is delivered by experienced instructors with practical lab work and real-world scenarios.

Intermediate On-site 12 weeks 48 hours

About this course

Master Oracle PL/SQL programming to automate and enhance database operations. Topics include stored procedures, functions, triggers, and exception handling. This course helps developers optimize database interactions for enterprise applications. Training is delivered by experienced instructors with practical lab work and real-world scenarios.

Advantages

🧑‍🏫

Practical teaching

In addition to class hours, you will practice the topics covered with your instructor and mentor dur

🤝

Mentors

The knowledge and skills you learn at the academy will be further strengthened with the mentor syste

📋

Academic transcript

Assignments and projects are checked by the instructor, and your knowledge and skills are determined

Training program

Download program
  1. 1 Advantages of PL SQL
  2. 2 What is PL SQL?
  3. 3 Comparison of PL SQL with SQL
  1. 1 Block Structure
  2. 2 Types of Blocks
  3. 3 Writing Anonymous blocks
  4. 4 PL/SQL Blocks
  1. 1 Declarations of variables
  2. 2 PL SQL Data types
  3. 3 Declarations of constants
  1. 1 Case
  2. 2 Conditional selection statements
  3. 3 If
  1. 1 For Loop
  2. 2 Basic Loop
  3. 3 Cursor For Loop (Implicit cursor)
  4. 4 Exit and Exit when
  5. 5 While Loop
  6. 6 Continue and Continue when
  1. 1 VARRAY
  2. 2 Collections
  3. 3 Records
  4. 4 Associative Arrays
  5. 5 Nested Table
  1. 1 What is Explicit Cursor?
  2. 2 Cursor Attributes
  3. 3 Difference between implicit and explicit cursor
  1. 1 System Defined exceptions
  2. 2 User defined exceptions
  1. 1 What is a procedure?
  2. 2 Procedure parameters
  1. 1 Calling methods
  2. 2 What is function?
  3. 3 Creating and using Functions
  1. 1 Calling methods
  2. 2 Creating and using Functions
  3. 3 What is function?
  1. 1 Package Body
  2. 2 What is Package?
  3. 3 Package Specification
  4. 4 Creating and using packages
  1. 1 EXECUTE IMMEDIATE Statement
  2. 2 Native Dynamic SQL
  3. 3 When You Need Dynamic SQL
  4. 4 OPEN FOR, FETCH, and CLOSE Statements
  1. 1 Reasons to Use Triggers
  2. 2 DML Triggers
  3. 3 Compound DML Triggers
  4. 4 INSTEAD OF DML Triggers
  5. 5 SCHEMA Triggers
  6. 6 System Triggers
  7. 7 DATABASE Triggers
  1. 1 Advantages of Autonomous Transactions
  2. 2 Declaring Autonomous Routines

Instructors

Saida Kerimli

Saida Kerimli

PL/SQL Developer

Yelo Bank