Oracle PL/SQL Fundamentals (ORPLSQL)

Descrizione del Corso Schedulazione Contenuti del Corso
 

Course Overview

This course introduces one to Oracle database programming using the PL/SQL programming language. One will learn the syntax, structure and features of the language. This trainng will also lay the foundation for the Oracle PL/SQL programming language, allowing one to progress from introductory topics to advanced application design and programming and finally onto writing complex high-performance applications. The focus of the second part of this training will be on the use of database-resident stored program units such as procedures, functions, packages and database triggers. New features introduced with the Oracle 12c release of the database are also explained and demonstrated.

PL/SQL may be considered as one of the basic skill sets required for any Oracle professional, nearly as important as the SQL language itself.

Chi dovrebbe partecipare

The target audience is all Oracle professionals. Among the specific groups for whom this course will be helpful are:

  • Application designers and database developers
  • Database administrators
  • Web server administrators

Obiettivi del Corso

This trainng begins with an explanation of the intent and usage of the PL/SQL programming language for database applications. Important reasons why one should incorporate PL/SQL modules within the application architecture right from the initial design and planning phase are presented. Next one learns how to begin building executable PL/SQL program units. One learns about each of the major segments of a working program and how these interact with each other during program execution, including the important error or exception handling capabilities of the language.

In a production environment most PL/SQL program units should be packaged, and these advanced database programming capabilities along with the benefits of using these are discussed. It concludes with extensive demonstrations on how a particular type of database-resident program unit known as a database trigger can be used as part of an advanced database application design.

Contenuti del Corso

  • Selection & Setup Of The Database Interface
  • About BIND & SUBSTITUTION Variables
  • Choosing A Database Programming Language
  • PL/SQL Language Fundamentals
  • DECLARE Section
  • BEGIN Section
  • Exception Section
  • Beyond The Basics: Explicit Cursors
  • Beyond The Basics: Nested Blocks
  • Beyond The Basics: DECLARED Subprograms
  • Introducing Database-Resident Program Units
  • Creating Stored Procedures & Functions
  • Executing Stored Procedures & Functions
  • Maintaining Stored Program Units
  • Managing Dependencies
  • Creating & Maintaining Packages
  • Advanced Package Capabilities
  • Advanced Cursor Techniques
  • Using System-Supplied Packages
  • Database Trigger Concepts
  • Creating Database Triggers
  • Maintaining Database Triggers
  • Implementing System Event Triggers
Formazione in Aula
Modality: C

Durata 5 Giorni

Prezzo (IVA esclusa)
  • Italia: 2.500,- €
Date e prenotazione
 
Clicca sulla città per iscriverti Schedulazione
Italia
28.01. - 01.02.2019 Milano
15.04. - 19.04.2019 Roma
15.07. - 19.07.2019 Milano
14.10. - 18.10.2019 Roma
FLEX Training

Di seguito i corsi disponibili in modalità Flex.

07.01. - 11.01.2019 FLEX training Corso FLEX in lingua Inglese
Fuso orario: Europe/Bratislava
18.03. - 22.03.2019 FLEX training Corso FLEX in lingua Inglese
Fuso orario: Europe/London
25.03. - 29.03.2019 FLEX training Corso FLEX in lingua Inglese
Fuso orario: Europe/Budapest
08.07. - 12.07.2019 FLEX training Corso FLEX in lingua Inglese
Fuso orario: Europe/London
09.09. - 13.09.2019 FLEX training Corso FLEX in lingua Inglese
Fuso orario: Europe/Prague
21.10. - 25.10.2019 FLEX training Corso FLEX in lingua Inglese
Fuso orario: Europe/London
11.11. - 15.11.2019 FLEX training Corso FLEX in lingua Inglese
Fuso orario: Europe/Bucharest
Svizzera
04.02. - 08.02.2019 Zürich
13.05. - 17.05.2019 Zürich
05.08. - 09.08.2019 Zürich
04.11. - 08.11.2019 Zürich
Regno Unito
18.03. - 22.03.2019 FLEX training Corso FLEX in lingua Inglese
Fuso orario: Europe/London
08.07. - 12.07.2019 FLEX training Corso FLEX in lingua Inglese
Fuso orario: Europe/London
21.10. - 25.10.2019 FLEX training Corso FLEX in lingua Inglese
Fuso orario: Europe/London
Repubblica Ceca
09.09. - 13.09.2019 FLEX training Corso FLEX in lingua Inglese
Fuso orario: Europe/Prague
Romania
11.11. - 15.11.2019 FLEX training Corso FLEX in lingua Inglese
Fuso orario: Europe/Bucharest
Slovakia
07.01. - 11.01.2019 FLEX training Corso FLEX in lingua Inglese
Fuso orario: Europe/Bratislava
Ungheria
25.03. - 29.03.2019 FLEX training Corso FLEX in lingua Inglese
Fuso orario: Europe/Budapest
Questo è un corso FLEX, erogato sia in aula che in remoto, contemporaneamente.
 

I cookies ci aiutano a fornirti un servizio adeguato. Utilizzando i nostri servizi acconsenti all'utilizzo dei cookies.   Acconsento.