Oracle: PL/SQL Language for Developers
Duration
32
hours
Location
Online
Language
English
Code
DB-021
Szkolenie dla #uczestników# lub większej liczby osób?
Dostosuj treningi
dla Twoich konkretnych potrzeb
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.
Po ukończeniu kursu na formularzu Luxoft Training
wydawany jest certyfikat
wydawany jest certyfikat
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