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

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