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

Oracle SQL and PL/SQL: Basic Concepts

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 Oracle SQL and PL/SQL: Basic Concepts WBT is the first course in this curriculum. This curriculum prepares the students for the Oracle8 Certified Database Administrator Track Exam # 1Z0-001. This course explains the basic concepts regarding a DBMS, RDBMS, and ORDBMS, and give an Oracle implementation of these. It also provides users with the basic functionality of PL/SQL for creating, viewing, maintaining, and altering data in Oracle. After completing this course, the student will be able to:

Describe a relational database
List various Normalization techniques used by a database
List the features of RDBMS and ORDBMS specific to Oracle
Describe the PL/SQL
Explain basics of PL/SQL
Describe the SELECT statement
Implement the SELECT statement
Restrict data selection in Oracle
Sort and group data
Use functions
Use queries/subqueries or subqueries for data selection
Use joins for advanced data selection
Describe the structure of a table
Create a table
Alter table structure
Create and maintain indexes

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 oracle sql plsql basic concepts oracle sql basic concepts

Training Program Details

Other Courses in the Curriculum

Basic PL/SQL Programming

Advanced PL/SQL Programming

Course Name	Oracle SQL and PL/SQL: Basic Concepts
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.2 hours
Course Objectives	The Oracle SQL and PL/SQL: Basic Concepts WBT is the first course in this curriculum. This curriculum prepares the students for the Oracle8 Certified Database Administrator Track Exam # 1Z0-001. This course explains the basic concepts regarding a DBMS, RDBMS, and ORDBMS, and give an Oracle implementation of these. It also provides users with the basic functionality of PL/SQL for creating, viewing, maintaining, and altering data in Oracle. After completing this course, the student will be able to: Describe a relational database List various Normalization techniques used by a database List the features of RDBMS and ORDBMS specific to Oracle Describe the PL/SQL Explain basics of PL/SQL Describe the SELECT statement Implement the SELECT statement Restrict data selection in Oracle Sort and group data Use functions Use queries/subqueries or subqueries for data selection Use joins for advanced data selection Describe the structure of a table Create a table Alter table structure Create and maintain indexes
Course Outline	Introducing Oracle: SQL and PL/SQL Overview of Relational Databases Oracle Implementation of the RDBMS Quiz Creating Queries Using the SELECT Statement Using Clauses and Functions Using Queries/Subqueries and Joins Quiz Database Creation in Oracle Using Tables Customizing Tables 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/18/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!