| | Training Directory | New Training Seminars | New Training Providers | Site Map | Promote Training Seminars | Training Keywords | Training Seminars | Training Providers | Regions | Training Search | Advertise Training Seminars | Login

Provided by: Teach Me IT

Basic PL/SQL Programming

Click here for more information or to take this course

Get More Information

Search for Training

Find Your Genius!

Training Provided by Teach Me IT

The Basic PL/SQL Programming WBT is the second course in this curriculum. This curriculum prepares the students for the Oracle8 Certified Database Administrator Track Exam # 1Z0-001. This course enables users to create views, sequences, synonyms, records, tables, functions, and procedures. Additionally, it enables users to create different kinds of PL/SQL blocks. After completing this course, the student will be able to:

Create views
Identify the different data dictionary views
Create and maintain sequences
Create synonyms
Identify the different kinds of PL/SQL blocks
Describe the Lexical units of a PL/SQL block
Declare variables
Identify the uses and types of control structure
Construct different types of loop statements
Create a PL/SQL Record
Create a PL/SQL Table
Identify the different types of PL/SQL DML statements
Construct PL/SQL Functions
Construct PL/SQL Procedures
Track procedural dependencies
Manage procedural dependencies

Training Avaliability and Delivery

This is primarily online training
	This is an online eLearning or CBT training program
	This course may be available for home-study
	Contact Teach Me IT for more information

Schedule:	flexible
Training Presented in:	English

Related Keywords: oracle plsql programming basic plsql programming basic sql programming oracle

Training Program Details

Other Courses in the Curriculum

Oracle SQL and PL/SQL: Basic Concepts

Advanced PL/SQL Programming

Course Name	Basic PL/SQL Programming
Audience	This course is designed for Application Developers who want to create database components using Oracle 8.
Course Requirements	You need Microsoft Internet Explorer 5.0 or above OR Netscape Navigator/Communicator 4.78 or above. Plug-in Requirements ØMacromedia Shockwave plug-in for Windows for IE/NN ØMacromedia Flash plug-in for Windows for IE/NN Note: Macromedia Flash plug-in comes built in with IE 5.5 and above and NN 6.x. To download the plug-ins, click on the relevant icon below.
Pre-requisites	Knowledge of database concepts.
Course Duration	3.8 hours
Course Objectives	The Basic PL/SQL Programming WBT is the second course in this curriculum. This curriculum prepares the students for the Oracle8 Certified Database Administrator Track Exam # 1Z0-001. This course enables users to create views, sequences, synonyms, records, tables, functions, and procedures. Additionally, it enables users to create different kinds of PL/SQL blocks. After completing this course, the student will be able to: Create views Identify the different data dictionary views Create and maintain sequences Create synonyms Identify the different kinds of PL/SQL blocks Describe the Lexical units of a PL/SQL block Declare variables Identify the uses and types of control structure Construct different types of loop statements Create a PL/SQL Record Create a PL/SQL Table Identify the different types of PL/SQL DML statements Construct PL/SQL Functions Construct PL/SQL Procedures Track procedural dependencies Manage procedural dependencies
Course Outline	Creating Database Objects Working with Views Working with other database objects Quiz Developing a PL/SQL Block Working with PL/SQL blocks Writing Control Statements Working with Composite Datatypes Quiz Working with Functions and Procedures Introducing Stored Functions and Procedures Implementing Procedures & Dependencies Quiz

About Teach Me IT - Training Provider

Teach Me IT - TeachMeIT is a comprehensive repository for online training courses and provides high quality, state-of-the-art IT and business related e-learning trainings and courses. With offerings ranging from desktop and MS office to networking and database courses, TeachMeIT provides training in both web-based as well as CD-based formats. Competitive prices, rich quality content, exhaustive...

More Oracle PL/SQL Programming Training from Teach Me IT

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 plsql programming training provider?

You could be on this page today - for FREE!