Faites confiance à votre formation en TI |
Oracle University reconnaît ExitCertified comme Partenaire en formation de l’année en Amérique du Nord.
ExitCertified renforce sa relation avec Red Hat en obtenant le statut de revendeur avancés.
Oracle University décerne à ExitCertified le prix de Qualité exceptionnelle des instructeurs.
ExitCertified en vedette dans le répertoire des Entrepreneurs dynamiques du 21e siècle.
ExitCertified est mis en candidature une troisième fois pour les prix de la Chambre de commerce.
ExitCertified élargit sa relation avec Apple en ajoutant la diffusion de formation agréée Mac OS à Phoenix, en Arizona.
 |
Oracle Database 11g: Develop PL/SQL Program Units Self-Study Course |
 |
|
| Format: Formation individualisée sur DVD/CD |
| Autres formats: |
|
|
|
|
|
|
| |
PL/SQL, the Procedural Language extension to SQL, enhances SQL by including constructs normally available in other procedural languages. This course is designed to teach you how to create modularized applications using PL/SQL. It demonstrates how to develop, execute, and manage PL/SQL stored program units, such as procedures, functions, packages, and database triggers. You will also learn how to use Oracle-supplied packages, Dynamic SQL, and the PL/SQL compiler. Understanding design considerations when coding using PL/SQL and managing dependencies is also covered. |
|
|
|
|
|
|
|
 |
|
 |
Compétences acquises |
| |
Identify the steps for designing, debugging, invoking, and bundling PL/SQL subprograms, procedures and functions, and also for handling their exceptionsRecognize the steps for creating and using efficient PL/SQL packages, including Oracle-supplied packages, executing dynamic SQL, and improving the performance of code
| | Identify the steps for creating, managing, and using database triggers, and for using the new PL/SQL compiler, its initialization parameters, and its compile time warningsIdentify the steps for performing conditional compilation to selectively use PL/SQL code, wrapping code, and tracking dependencies
| |
|
|
|
|
Qui peut en profiter |
| |
Application DevelopersDatabase AdministratorsDatabase Designers
| | Forms DeveloperPL/SQL DeveloperTechnical Consultant
| |
|
|
|
|
Préalables |
| |
The learner should have experience and knowledge with SQLSpecifically the Oracle Database 11g: SQL Fundamentals I
| | Oracle Database 11g: SQL Fundamentals II
| |
|
|
|
| |
|
|
 |
| Code: |
D55831 |
| Format: |
Formation individualisée sur DVD/CD |
|
| Durée: |
|
| Certifié par: |
Oracle |
|
| Frais d’inscription (CAD): 1,103$ |
|
|
 |
|
|
|
|
|
|
|
|
Oracle Database 11g: Develop PL/SQL Program Units Self-Study Course Contenu détaillé |
| |
| |
| Oracle Database 11g: Subprograms, Packages, and Exception Handling in PL/SQL
| - Using Subprograms and Handling Exceptions
- Using Functions, Creating Packages, and Debugging
| |
| Oracle Database 11g: Packages, Dynamic SQL, and Coding Considerations in PL/SQL
| - Using Packages and Dynamic SQL
- Coding Considerations in PL/SQL
| |
| |
| Oracle Database 11g: Using Triggers, the PL/SQL Compiler, and Managing Code
| - Working with Triggers in PL/SQL
- Using the PL/SQL Compiler and Managing Code
| |
| Oracle Database 11g: Managing PL/SQL Code and Dependencies
| - PL/SQL Code and Dependency Management
| |
| |
|
