Oracle Database 19c: PL/SQL Workshop

5 nap
750 000 Ft + ÁFA
tanfolyamkezdési időpontok:

A tanfolyamról

This is a complete course on PL/SQL including an introduction to Programming and Managing the PL/SQL code.

Skills Gained

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


Course Outline

  •     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
  •     Creating Procedures and Functions
  •     Debugging Subprograms
  •     Creating and working with Packages
  •     Using Oracle-Supplied Packages in Application Development
  •     Using Dynamic SQL
  •     Creating Compound, DDL, and Event Database Triggers
  •     Design Considerations for the PL/SQL Code
  •     Tuning the PL/SQL Compiler
  •     Managing Dependencies
  •     Using SQL Developer and SQL*Plus
  •     Commonly Used SQL Commands
  •     REF Cursors
  •     Managing PL/SQL Code
  •     Implementing Triggers
  •     Using the DBMS_SCHEDULER and HTP Packages

Kinek ajánljuk


Oracle Database SQL knowledge

Kapcsolódó tanfolyamok

Ajánlja másoknak is!