Oracle Database 19c: PL/SQL Workshop

25 Nov 2024

  A 29 Nov 2024


Horário: 9h30 às 16h30


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.

Explore the most advanced features and methods for achieving maximum performance, availability, and reliability using core database technologies and features. Learn how to leverage enhancements in multitenant architecture, manage security, use RMAN, understand general Database Administration functionality, implement big data, and more.


  • Declare Variables
  • Write Executable Statements
  • Write Control Structures
  • Create Procedures and Functions
  • Create Packages


  • End users
  • Business analysts
  • Application developers
  • Database administrators


  • 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

Outras datas e horários


Quero saber mais informações sobre este curso

Oracle Database 19c: PL/SQL Workshop

Oracle | 30h - Laboral: 9h30 às 16h30


Pretende mais informação sobre este curso?

Preencha o formulário com os seus dados e as suas questões e entraremos em contacto consigo para lhe darmos todas as informações pretendidas.


Quero inscrever-me neste curso

Oracle Database 19c: PL/SQL Workshop

Oracle | 30h - Laboral: 9h30 às 16h30

Dados Pessoais
Dados para faturação