Oracle Database 19c: PL/SQL Workshop

Kursun kodu

19cDB-PLSQL-WS

Müddət

5 Gün, 40 Saat

PDF yüklə

Kursun təsviri

Məqsədlər

Tələblər

Kursun proqramı

Kursun təsviri

Course overview

This course introduces students to PL/SQL, Procedural Language for SQL. Explore the differences between SQL and PL/SQL. Examine the characteristics of PL/SQL and how it is used to extend and automate SQL.

Məqsədlər

Course Objectives

Get an overview of PL/SQL
Learn how to declare variables
Write executable statements
Learn how to use SQL statements in PL/SQL Programming

Tələblər

Prerequisites

Oracle Database 19c: SQL Workshop

Kursun proqramı

Course Outline

Introduction
Introduction to PL/SQL
Declaring PL/SQL Variables
Writing Executable Statements
Using SQL Statements Within a PL/SQL Block
Writing Control Structures
Working with Composite Data Types
Using Explicit Cursors
Handling Exceptions
Introducing Stored Procedures and Functions
Creating Procedures
Creating Functions
Debugging Subprograms
Creating Packages
Working with Packages
Using Oracle-Supplied Packages in Application Development
Using Dynamic SQL
Creating Triggers
Creating Compound, DDL, and Event Database Triggers
Design Considerations for the PL/SQL Code
Tuning the PL/SQL Compiler
Managing Dependencies

Kurslara qayıt (Oracle)

Ən yaxın kurs üçün qeydiyyat

Oracle Database 19c: PL/SQL Workshop

Kursun kodu:

19cDB-PLSQL-WS

Müddət:

5 Gün, 40 Saat

21.04.25

Kiyev

Format

Tarixlər

21.04.25

Yer

Kiyev

Qeydiyyatan keç

PDF yüklə