ORACLE9i SQL/PLSQL
 
ORACLE10g 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
 
Creating and Managing Tables

  1. Describing the Main Database Objects
  2. Creating Tables

  3. Describing the Oracle Data Types

  4. Altering Table Definitions

  5. Dropping, Renaming, and Truncating Tables
Including Constraints

  1. Describing Constraints
  2. Creating and Maintaining Constraints
  3. Creating Views
  4. Creating a View
  5. Retrieving Data by Means of a View
  6. Inserting, Updating, and Deleting Data Through Views
  7. Dropping Views
  8. Altering the Definition of a View
  9. Inline Views
  10. Top 'N' Analysis
Other Database Objects

  1. Creating, Maintaining, and Using Sequences
  2. Creating and Maintaining Indexes
  3. Creating Private and Public Synonyms
  4. Controlling User Access
  5. Understanding the Concepts of Users, Roles, and Privileges
  6. Granting and Revoking Object Privileges
  7. Creating Roles and Granting Privileges to Roles
  8. Creating Synonyms for Ease of Table Access

Date Time functions

  1. Time Zones
  2. Oracle Date Time Support
  3. TZ_OFFSET
  4. Local Timestamp
  5. CURRENT_DATE
Enhancements to the Group By Clause

  1. Cube

  2. Rollup
Advanced Subqueries

  1. Pairwise and non Pairwise comparision subquery

  2. Correlated update


  3. Correlated Delete

Hieararchical Retrieval
 
 
 
     
 
Training Portfolio
 
 
Courses
Course material designed by experts
Tutorial
Certification Guidance
 
 
 
     
     
     
 
 
     
© 2009, qsoftindia.com, All Rights Reserved
`