Oracle PL/SQL | Ingress Academy
Для частных лиц Для бизнеса Работа и найм
Карьерные пути Курсы Почему мы Преподаватели Блог
az en ru
Портал

Этот материал пока недоступен на языке Русский — показан на другом доступном языке. Доступно на: AZ, EN

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.

Средний Очно 12 недель 48 часов

О курсе

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.

Преимущества

🧑‍🏫

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

Программа обучения

Скачать программу
  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

Преподаватели

Saida Kerimli

Saida Kerimli

PL/SQL Developer

Yelo Bank