Oracle 11g - Programming with PL / SQL I - Workshops

nobleprog

Corso

A Milano

Prezzo da consultare

Chiama il centro

0294759467

Hai bisogno di un coach per la formazione?

Ti aiuterà a confrontare vari corsi e trovare l'offerta formativa più conveniente.

I migliori corsi di SQL Server

Vedi tutti

Vedi tutti

Descrizione

  • Tipologia

    Corso

  • Luogo

    Milano

For who
Workshops are dedicated to developers, end users and administrators, who until now have had no contact with the language PL / SQL, and the need to exploit its huge potential in working with a database, automate processes, and in building applications
Exams and Certificates
The plan covers the training material required to pass the exam 1Z0-144 Oracle Database 11g Program with PL / SQL and obtain the title of Oracle PL / SQL Developer Certified Associate
Purpose of training
The workshop aims to familiarize participants with the programming language PL / SQL, its capabilities and limitations. This workshop will include a full understanding of the mechanisms involved in the programming language PL / SQL needed to implement the logic of the free applications, automation of data processing and database management.
The content of the training
Introduction to PL / SQL architecture solutions based on this language, the organization of the working environment
Create scripts and stored program units that operate on data
Notes
The workshops are based on the software version 11g XE

Sedi e date

Luogo

Inizio del corso

Milano
Visualizza mappa
Piazza Duomo, Via Torino 2, 20123

Inizio del corso

Consultare

Profilo del corso

Basic skills in any programming language, object-oriented structural or
The free use of the basics of SQL and knowledge of Oracle database environment (preferably Oracle 11g completion of training - Native SQL for Programmers - Workshops)

Domande e risposte

Aggiungi la tua domanda

I nostri consulenti e altri utenti potranno risponderti

Chi vuoi che ti risponda?

Inserisci i tuoi dati per ricevere una risposta

Pubblicheremo solo il tuo nome e la domanda

Opinioni

Materie

  • Pl/sql
  • Management
  • SQL

Programma

Introduction to PL / SQL

  • Runtime Environment
  • Construction and types of PL / SQL blocks
  • Declaring and using variables
  • Control statements, decisions, loops
SQL statements in PL / SQL
  • DML commands
  • DDL and dynamic SQL
  • TCL commands and transactional
  • SELECT
Procedures and Functions
  • Create and delete
  • Parameterization
  • Passing parameters by value and reference, nocopy
Handling errors and exceptions Create and use cursors
  • Records
  • static cursors
  • Parameterizing cursors
  • Cursor FOR UPDATE
Associative arrays Packages
  • The structure of the package: the specification and body
  • Section Initialization and global variables, memory management, an instance of the package
  • Encapsulation, overloading programs, pre-declaration procedures
Triggers
  • DML triggers
  • The triggers Drives (INSTEAD OF)
  • The triggers system
  • New features in Oracle 11g triggers
Examples of application packages built
  • Writing to a file through UTL_FILE
  • Sending e-mails
Management code and compiler
  • Encryption code (dynamic obfuscation, wrap)
  • conditional Compilation
  • The relationships between objects
  • Warnings

Categorie correlate

Chiama il centro

0294759467

Hai bisogno di un coach per la formazione?

Ti aiuterà a confrontare vari corsi e trovare l'offerta formativa più conveniente.

Oracle 11g - Programming with PL / SQL I - Workshops

Prezzo da consultare

I migliori corsi di SQL Server

Vedi tutti

Vedi tutti