Faites confiance à votre formation en TI |

Oracle University reconnaît ExitCertified comme Partenaire en formation de l’année en Amérique du Nord.

Oracle Database 10g: PL/SQL Fundamentals Self-Study Course

Catégorie: Formation

Bases de données et grilles

Format: Formation individualisée sur DVD/CD

Autres formats:

Oracle University Self-Study CD Courses are a great accompaniment and reliable alternative to our inClass courses, and provide an excellent ongoing resource for reviewing key concepts and practicing skills.

In this course, the learner will get familiar with the procedural language to access Oracle database. The learner will learn how to write and use anonymous PL/SQL blocks, program constructs, simple and composite PL/SQL data types, programming guidelines, and accessing and manipulating data using PL/SQL. Additionally, the learner will also learn how to write and use PL/SQL program units, such as stored functions, stored procedures, and packages along with some standard Oracle supplied packages and exception handling techniques in PL/SQL.

Learn to:

Identify features of PL/SQL
Identify benefits of PL/SQL
Identify features of PL/SQL blocks
Identify features of PL/SQL blocks within a subprogram
Identify features of triggers

Compétences acquises

Create, execute, and maintain procedures, functions, packages, and triggers
Manage dependencies
Manipulate large objects
Conditionally control code flow (loops, control structures, and explicit cursors)

Handle runtime errors
Manage program constructs
Describe the features and syntax of PL/SQL

Qui peut en profiter

Business Intelligence Developer
Database Designers
Forms Developer

PL/SQL Developer
Portal Developer
Technical Consultant

Ce cours autoformation est certifiÃ© par le .

Oracle University a nommÃ© ExitCertified Partenaire de lâ€™annÃ©e 2011

Il y a une diffÃ©rence....dÃ©couvrez-la.

Code:	D47229
Format:	Formation individualisée sur DVD/CD

Durée:
Certifié par:	Oracle

Frais d’inscription (CAD): 1,103$

Oracle University Awards ExitCertified the North American Partner of the Year Award for 2011

Formation de Oracle (3027 cours)

Formation de Bases de données et grilles (209 cours)

Formation de 10g (73 cours)

Oracle Database 10g: PL/SQL Fundamentals Self-Study Course Contenu détaillé

Programming with PL/SQL

Identify features of PL/SQL
Identify benefits of PL/SQL
Identify features of PL/SQL blocks
Match different PL/SQL program constructs with their features
Identify features of the iSQL* Plus programming environment
Identify features of PL/SQL variables
Identify guidelines for declaring PL/SQL variables
Identify features of various PL/SQL data types

PL/SQL Blocks

Identify features of PL/SQL blocks within a subprogram
Match types of PL/SQL named blocks with their descriptions
Match types of PL/SQL environments with their descriptions
Identify the syntax for creating a stored procedure
Identify features of the parameters used in stored procedures
Identify the syntax for passing parameters to a stored procedure
Identify tasks involved in using stored procedures
Identify the syntax for creating a PL/SQL function

PL/SQL Packages

Identify features of PL/SQL packages
Sequence steps for developing PL/SQL packages
Identify the syntax for creating a PL/SQL package
Identify tasks involved in managing PL/SQL packages
Identify features of the overloaded subprograms contained in PL/SQL packages
Identify features of forward referencing in PL/SQL packages
Identify features of the PL/SQL package state
Identify features of the PL/SQL wrapper utility

Triggers

Identify features of triggers
Identify the code to create a Data Manipulation Language (DML) trigger
Identify the code to create a Data Manipulation Language (DML) row trigger
Identify the code to create an INSTEAD OF trigger
Match the options for managing triggers with their descriptions
Identify guidelines for testing triggers
Identify the benefits of triggers in different business application scenarios
Identify the syntax for creating triggers for DDL and system events

Dynamic SQL Statements

Match the stages in the execution of SQL statements with their descriptions
Identify features of dynamic SQL
Identify the features of the DBMS_SQL package
Identify features of the subprograms in the DBMS_METADATA package
Identify the features of Large Objects (LOBs)
Identify features of internal Large Objects (LOBs)
Identify features of Binary Files (BFILEs)
Identify tasks involved in managing Binary Files (BFILEs)

Large Object (LOB) data type

Identify features of the DBMS_LOB package
Identify the code to work with Large Object (LOB) values
Identify methods of selecting Character Large Object (CLOB) values
Identify features of temporary Large Objects (LOBs)

PL/SQL Design Considerations

Identify guidelines for standardizing constants and exceptions
Identify benefits of using local subprograms
Sort the characteristics of the rights models according to their category
Identify features of autonomous transactions
Identify features of bulk binding
Identify features of dependencies
Identify tasks you need to perform for displaying dependencies
Identify features of local dependencies. Identify features of remote dependencies

Compilation Tools and Options

Identify features of native compilation
Identify settings to be specified for native compilation
Sequence the steps to enable native compilation of PL/SQL code
Identify features of compiler warnings
Identify features of the PLSQL_WARNINGS parameter
Identify features of the DBMS_WARNINGS package
Identify features of the NOCOPY and PARALLEL_ENABLE hints

Your Name:

Your Email:

Sign up for newsletter:

Send Email To:

Course Link:

http://exitcertified.ca/oracle-training/D47229.html

Message:

Next


	Lorsque vous suivez un cours certifié chez ExitCertified, vous apprenez directement des concepteurs des produits que vous utilisez. Notre engagement envers la communauté des TI, de même que notre autorisation à offrir des cours certifiés, vous assurent une expérience de formation supérieure. Il y a une différence. Apprenez directement de la source. Il y a une différence. Apprenez directement de la source.



Canada	United States
Formation à Montréal :: 514.876.1666 Formation à Ville de Québec :: 514.876.1666 Formation à Ottawa :: 613.232.3948 Formation à Toronto :: 416.487.3948 Formation à Vancouver :: 604.633.3948 Formation à Victoria :: 1.866.328.3948 Formation à Calgary :: 403.291.2855 Formation à Edmonton :: 780.441.3948 Formation à Regina :: 1.866.328.3948	Formation à Sacramento :: 916.669.3970 Formation à San Francisco :: 415.975.3948 Formation à San Jose :: 408.288.3948 Formation à Las Vegas :: 1.800.803.3948 Formation à Phoenix :: 602.889.9350
À travers le monde - 613.232.3948	Des questions? Il nous fait plaisir de vous aider. Transmettez-nous ce formulaire par courriel et nous vous répondrons dans les plus brefs délais.

(c) 2012 ExitCertified Corp. Tous droits réservés.

Conditions d’utilisation et exclusions | Politique de confidentialité | Index des cours | Communiquez avec nous

ExitCertified est un fournisseur international agréé de formation en technologies. Voici quelques-uns de nos cours les plus souvent consultés :

Formation Sun	Formation Oracle	Formation Symantec	Formation IBM	Formation Red Hat :: Linux
Formation Java, Cours J2EE, Formation JSP, servlets, EJB, Struts, réseaux, Formation Solaris, Java Composite Application Platform (JCAPS), SeeBeyond, XML, Formation Solaris 10, certification Java, certification Solaris	Cours PeopleSoft, 11g, Formation Oracle SQL, Oracle PL/SQL, DBA, Hyperion, Fusion Middleware, 10g, 9i, certification 11g, certification DBA, certification Oracle	Formation NetBackup, Cours Veritas, protection contre les virus, sécurité des TI, certification Symantec	DB2, OS/400, Formation zSeries, s/390, iSeries, AIX	SUSE, Formation RedHat

Formation MySQL	Formation Apple	Formation en gestion de projet
Base de données MySQL	Cours Apple, Formation Leopard	Formation du PMI