FORGOT YOUR DETAILS?

eluide9eb7f5d

Oracle Database 19c: PL/SQL Workshop

Cost
$4000 USD
Course Code
D108652GC10
Duration
5 Days
Format
Live Virtual Class

Course Schedule

Oracle Database 19c: PL/SQL Workshop

$4,000.00

Scheduled, 03-Oct-2022 - 07-Oct-2022, 09:00 AM - 05:00 PM US Eastern
Scheduled, 13-Feb-2023 - 17-Feb-2023, 09:00 AM - 05:00 PM US Eastern
Scheduled, 26-Jun-2023 - 30-Jun-2023, 09:00 AM - 05:00 PM US Eastern
Choose an option
Oracle Database 19c: PL/SQL Workshop – Scheduled, 03-Oct-2022 - 07-Oct-2022, 09:00 AM - 05:00 PM US Eastern
$4,000.00
Oracle Database 19c: PL/SQL Workshop – Scheduled, 13-Feb-2023 - 17-Feb-2023, 09:00 AM - 05:00 PM US Eastern
$4,000.00
Oracle Database 19c: PL/SQL Workshop – Scheduled, 26-Jun-2023 - 30-Jun-2023, 09:00 AM - 05:00 PM US Eastern
$4,000.00
Clear
SKU: D108652GC10 Categories: , ,

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.

BENEFITS TO YOU:

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

Audience

  • Database Administrators
  • Developers

Suggested Preqrequisites

  • Oracle Database 19c: SQL Workshop

Topics

  • 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 Trigge3rs
  • Design Considerations for the PL/SQL Code
  • Tuning the PL/SQL Compiler
  • Managing Dependencies

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.

BENEFITS TO YOU:

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

Audience

  • Database Administrators
  • Developers

Suggested Preqrequisites

  • Oracle Database 19c: SQL Workshop

Topics

  • 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 Trigge3rs
  • Design Considerations for the PL/SQL Code
  • Tuning the PL/SQL Compiler
  • Managing Dependencies

Related Courses…

TOP
0