Provided by: 123-CBT Computer Based Training

Oracle Database 10g PL SQL Fundamentals Part 1

Click here for more information or to take this course

Search for Training

Find Your Genius!

Training Provided by 123-CBT Computer Based Training

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.

Audience:

The target course audience is Data Administrators, PL/SQL Developers, and Technical consultants who have experience with the Oracle9i Database.

Deployment:

Self-Study

Language Options:

US English

Total Learning Time:

8 hours

Objectives:

Unit 1: 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.
Identify the syntax for declaring PL/SQL variables using the %TYPE attribute.
Identify features of bind variables.
Identify features of substitution variables.
Identify the syntax of the %ROWTYPE attribute.
Identify the syntax for creating a PL/SQL record.
Identify the syntax for creating a PL/SQL collection.
Identify guidelines for programming in PL/SQL.
Identify features of PL/SQL functions.
Identify features of nested blocks.
Identify uses of PL/SQL operators.
Match SQL statements with their functions.
Identify guidelines for retrieving data in PL/SQL.
Identify codes for manipulating data using DML statements.
Identify the syntax for testing the outcome of SQL statements using cursors.
Identify the syntax of the IF statement.
Identify the syntax of the CASE construct.
Identify considerations for handling nulls.
Identify considerations for building Boolean conditions.
Identify the syntax of loop statements.
Identify the syntax for controlling explicit cursors.
Identify the syntax for using cursor FOR loops.
Identify the syntax used to obtain status information about a cursor using explicit cursor attributes.
Identify the syntax of the FOR UPDATE clause.
Identify the syntax of the WHERE CURRENT OF clause.
Identify features of exceptions.
Identify guidelines for trapping exceptions.
Identify uses of the RAISE_APPLICATION_ERROR procedure.
Identify the syntax for creating a stored procedure.
Identify the syntax for creating a function.

Training Avaliability and Delivery

This is primarily online training
	This is an online eLearning or CBT training program
	This program may be available on CD
	Contact 123-CBT Computer Based Training for more information

Training Presented in:

English

Related Keywords: oracle database 10g sql fundamentals part

Training Program Details

About 123-CBT Computer Based Training - Training Provider

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 -...

More Oracle Database 10g Training from 123-CBT Computer Based Training

Click here for more information or to take this course

Custom Search

Training Directory \| New Training Seminars \| New Training Providers \| Search \| Site Map \| Promote Training \| Login \| Links

	Training-Classes.com by Skillbox® 07/19/08 Copyright 1998-2008 skillbox, inc. All rights reserved

Are you an Oracle training provider?

You could be on this page today - for FREE!