Custom Search

Oracle SQL and PL/SQL: Basic Concepts

Oracle PL/SQL

Serebra Learning Corporation
Training Provided by Serebra Learning Corporation The Oracle SQL and PL/SQL: Basic Concepts WBT is the first course in this curriculum. This course will explain basic concepts regarding a DBMS, RDBMS, and ORDBMS and give an Oracle implementation of these. It will also provide users with the basic functionality of PL/SQL for creating, viewing, maintaining, and altering data in Oracle.
This is primarily online training
on-line e-learning cbt (computer based)This is an online eLearning or CBT training program
Contact Serebra Learning Corporation for more information
Duration:3 hours
Training Presented in:English
Oracle SQL and PL/SQL: Basic Concepts Course Outline - IP1450 - Oracle SQL and PL/SQL: Basic Concepts

Oracle SQL and PL/SQL: Basic Concepts

Course Code IP1450

Contents

  1. Contents
  2. Description
  3. Audience
  4. Prerequisites
  5. Objectives
  6. Topics Include
  7. Duration
  8. Minimum Requirements
  9. Media

Screenshot


click to enlarge

Description

The Oracle SQL and PL/SQL: Basic Concepts WBT is the first course in this curriculum. This course will explain basic concepts regarding a DBMS, RDBMS, and ORDBMS and give an Oracle implementation of these. It will also provide users with the basic functionality of PL/SQL for creating, viewing, maintaining, and altering data in Oracle.

Audience

This course is designed for Application Developers who want to create database components using Oracle 8.

Prerequisites

Knowledge of database concepts.

Objective

Upon completion of 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

Topics Include

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

Duration

3 hrs

Minimum Requirements

Netscape or Internet Explorer (versions 4.0 or higher). Browsers should be capable of accepting cookies; SVGA Hi-color mode 800x600 resolution display. Macromedia Shockwave 6.02 or higher.

Media

Web Based Training

Serebra Learning Corporation, 600 - 1188 West Georgia, Vancouver, BC    V6E 4A2 Canada
Tel: (604) 676-5480 or 1-800-567-7766 - Fax: (604) 676-5490
E-Mail: sales@serebra.com - Web Site: www.serebra.com
About The Training Provider: Serebra Learning Corporation
Serebra Learning Corporation - Serebra Learning Corporation provides technology-based training solutions through a combination of Cortex, its proprietary learning management system (LMS), and a curriculum catalog with over 1,825 current courseware titles. Founded in 1987 (as FirstClass Systems, with a name change to Serebra in 2001), Serebra has over sixteen years" experience delivering e-learning solutions to both...
Advertise With Us
Do you teach sql ?
This page was last updated on sb5- 09/08/08 at 19:04:46 - 07:16:26