Oracle SQL and PL/SQL: Basic Concepts

Oracle PL/SQL

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
Duration:3 hours
Training Presented in:English
Training Provided by Serebra Learning Corporation
  • asked: Oracle SQL and PL/ SQL
  • G asked: what is sql? what are the keys to formation of table?
  • M asked: how do I train my applications in this program?
  • D asked: how can i get trainning in the basic concepts of oracle in my country kenya?
  • J asked: i want the best of i.t course on oracle
  • A asked: how to learn this course
  • S asked: tips and tricks in oracle pl/sql programming
  • A asked: I here by reqoest to accept my request for nline tutorials of Oracle SQL and PL/SQL: Basic Concepts .i will be thankful to you if you do the needful.
  • P asked: I would request for training informarion on Oracle SQL and PL/SQL for my certification on OCP.
  • S asked: i want ot lern these topics so how can i get soft copies on these topics and how can i get clarification of my doubts.
  • J asked: Can you please provide me with a complete list of start dates and times/durations for this course
  • D asked: Could you please provide a course description, schedule of classes and cost for the subject named course.
  • P asked: What is the cost?
  • J asked: Oracle SQL and PL/SQL
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, 1660 - 999 W Hastings St, Vancouver, BC, Canada   V6C 2W2
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...
Want to Sell More basic training?
Custom Search
tcw11-v473M-02/04/12-22:45:41-()[A]-[B]-[A] -09:06:13