Oracle: PL/SQL Language for Developers
Durată
32
ore
Location
Pe net
Limba
Engleză
Cod
DB-021
Training pentru 7-8 sau mai multe persoane?
Personalizați antrenamentele
pentru nevoile dumneavoastră specifice
Description
The course covers the Oracle 11g R2 version of the PL/SQL language. During the training we cover subjects related to the use of stored Oracle DBMS PL/SQL objects (procedures, functions, packages, triggers), which provide powerful capabilities for creating business logic for applications using Oracle technology. We will also talk about the new features of the 11 g version.
In addition the course covers some of the standard packages, dynamic SQL, mass loading of data using collections, ways of influencing the compilation of PL/SQL-code and the mechanism of dependency management. Oracle SQL Developer is used for developing.
After completing the course, a certificate
is issued on the Luxoft Training form
is issued on the Luxoft Training form
Objectives
- Creating, modifying and deleting stored PL/SQL objects
- Handling exceptions more effectively
- How to use standard Oracle database packages
- How to use dynamic SQL
- Working with object types and collections more effectively
Target Audience
- Database administrators
- System administrators
- Application developers
- Software Testers
Prerequisites
- Knowledge of the course
- DB-018 Oracle Database: Basics of PL/SQL Language