Overview
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
Requirements
- 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)
Course Outline
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