|
Provided by: 123-CBT Computer Based Training Oracle Database 10g PL SQL Fundamentals Part 2 |
 |
Training
Provided by 123-CBT Computer Based Training
This course introduces learners to PL/SQL and helps them understand the benefits of this programming language. Students learn to create anonymous PL/SQL blocks. They learn to declare variables and trapping exceptions, develop stored procedures, functions, packages and database triggers.
Learn To:
The target course audience is Application Developers, Database Designers, System Analysts, PL/SQL Developer, Technical Consultant, Forms Developer, and Portal Developer.
Deployment:
Self-Study
Language Options:
US English
Total Learning Time:
8 hours
Objectives:
Unit 1: PL/SQL Blocks
Learn To:
- 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 features of PL/SQL packages.
- Sequence steps for developing PL/SQL packages.
- Identify the syntax for creating a PL/SQL package.
- 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.
The target course audience is Application Developers, Database Designers, System Analysts, PL/SQL Developer, Technical Consultant, Forms Developer, and Portal Developer.
Deployment:
Self-Study
Language Options:
US English
Total Learning Time:
8 hours
Objectives:
Unit 1: 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.
- Identify characteristics of PL/SQL functions.
- Identify tasks you can perform for managing PL/SQL functions.
- 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.
- Match Oracle-supplied packages with their uses.
- Match procedures provided by the DBMS_OUTPUT package with their features.
- Identify features of the UTL_FILE package.
- Identify features of the HTP package.
- Identify the syntax for sending e-mail messages using the UTL_MAIL package.
- Match components of the DBMS_SCHEDULER package with their descriptions.
- Identify the syntax for creating jobs by using the DBMS_SCHEDULER package.
- 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.
- Identify key concepts of using triggers on mutating tables.
- Match the different data dictionary views containing trigger information with their descriptions.
|
|
||||||||||
Oracle Database 10g PL SQL Fundamentals Part 2
--
About The Training Provider: 123-CBT Computer Based Training
123-CBT Computer Based Training - 123-CBT offers discount pricing on top quality eLearning
programs from leading computer based training providers. Many of the training courses are available both online or on CD so that you can study at home at your own pace:
E-Learning available for
- ABAP 6.10
- Access 2003
- Acrobat 6.0
- ASP
- ASP.NET
- C
- Captivate 1.0
- Crystal Reports 8.5
- Crystal Reports v10
- Dreamweaver MX
-...
