ORACLE9i SQL/PLSQL
 
ORACLE9i SQL

Course duration(in hrs): 28

Course Objectives:

  1. Use iSQL*Plus to format reports

  2. Use basic iSQL*Plus commands

  3. Retrieve, insert, update, and delete data

  4. Describe relational and object relational database concepts

  5. Create and maintain database objects

  6. Control transactions

  7. Control data and user access
 
Course Topics
 
Introduction

  1. Describing the Life Cycle Development Phases

  2. Defining a Database

  3. Discussing the Theoretical, Conceptual, and Physical Aspects of a Relational Database

  4. Describing How a Relational Database Management System (RDBMS) Is Used to Manage relational database

  5. Describing the Oracle Implementation of Both the RDBMS and the Object Relational Database Management System (ORDBMS)

  6. Describing How SQL Is Used in the Oracle Product Set
Writing a Basic SQL Statement

  1. Describing the SQL Select Capabilities

  2. Executing a Basic Select Statement with the Mandatory Clauses

  3. Differentiating Between SQL and iSQL*Plus Commands
Restricting and Sorting Data

  1. Limiting the Rows Retrieved by a Query

  2. Sorting the Rows Retrieved by a Query
Single Row Functions

  1. Describing Various Types of Functions Available in SQL

  2. Using a Variety of Character, Number, and Date Functions in SELECT Statements

  3. Explaining What the Conversion Functions Are and How They Are Used

  4. Using Control Statements
Displaying Data from Multiple Tables

  1. Writing SELECT Statements to Access Data from More Than One Table

  2. Describing the Cartesian Product
Describing and Using the Different Types of Joins

  1. Writing Joins Using the Tips Provided

  2. Aggregating Data by Using Group Functions

  3. Identifying the Different Group Functions Available & Explaining the Use of Group Functions

  4. Grouping Data by Using the GROUP BY Clause

  5. Including or Excluding Grouped Rows by Using the HAVING Clause
Writing Subqueries

  1. Describing the Types of Problems That Subqueries Can Solve

  2. Describing Subqueries

  3. Listing the Types of Subqueries

  4. Writing Single-Row and Multi-Row Subqueries

  5. Describing and Explaining the Behavior of Subqueries When NULL

  6. Values Are Retrieved
Producing Readable Output with iSQL*Plus

  1. Producing Queries That Require an Input Variable

  2. Customizing the iSQL*Plus Environment

  3. Producing More Readable Output

  4. Creating and Executing Script Files
Manipulating Data

  1. Describing Each Data Manipulation Language (DML) Command

  2. Inserting Rows into a Table

  3. Updating Rows in a Table

  4. Deleting Rows from a Table

  5. Merging Rows into a Table

  6. Controlling Transactions

  7. Describing Transaction Processing

  8. Describing Read Consistency and Implicit and Explicit Locking
 
 
 
     
 
Training Portfolio
 
 
Courses
Course material designed by experts
Tutorial
Certification Guidance
 
 
—————————————————
  
 
Course Schedule - July-Sept 2008
 
 
July 2008 Bangalore Region
Mumbai Region
August 2008 Bangalore Region
Mumbai Region
September 2008 Bangalore Region
Mumbai Region
 
     
 
 
     
© 2004, qsoftindia.com, All Rights Reserved
`