Oracle 10g Course Content

Overview :

Oracle 10g is a version of the Oracle Database. The g stands for “grid” to indicate that 10g is “grid-computing ready”. It reduces the costs and increasing up time by making the database easier to manage Applications. One way of doing this is to automate tasks that previously had to be done manually by the DBA. A new Automated Storage Management (ASM) sub system is developed to achieve this for Oracle 10g. This feature removes the need to have a file system or a volume manager for managing the database files and eliminates the complexity of balancing data across the disks and controllers manually.

Training Objectives of Oracle 10g :

Oracle 10g Aspirants can easily learn concepts of create, retrieve, and manipulate objects in Oracle 10g Structured Query Language (SQL). We will also be introducing Oracle 10g database features and tools to the students. Students also develop deeper insight into relational Database Architecture Design and RDBMS Operations and learn the concepts and specific SQL syntax for extended Oracle Data types. Analysis and Tuning techniques to increase SQL performance and master advanced features of Oracle® SQL for large data sets and data warehouses.

Target Students / Prerequisites :

Students Must be belong IT Background and aware of Concepts in Database and Logical Programming.

DBMS :

  • Concepts of DBMS
  • Introduction
  • Importance and Need
  • Database Models and Normalization
  • Models
  • Hierarchial
  • Relational
  • Object
  • Normalization Techniques

Introduction to RDBMS :

  • Concepts of RDBMS
  • Introdution
  • Comparision with DBMS
  • COOD Rules
  • Normalization Revisited
  • Concepts of ORDBMS & OODBMS
  • Introduction to ORDBMS
  • Introduction to OODBMS
  • Comparision and analysis

Structured Query Language(SQL) :

  • Introduction to SQL
  • Predefined Data Types
  • Introduction to database objects
  • Table,View

Commands in SQL :

  • Data Defination Language(DDL)
  • Data Manipulation Language(DML)
  • Data Control Language(DCL)
  • Transaction Control Language(TCL)
  • Database Security and Privileges(DCL)

Working with DDL,DML,TCL Commands :

  • Operators
  • Conditional,Logical,Comparison,SET
  • Functions
  • Date,Number,Character,String,Group,Group by,Having clause
  • Transformation Functions
  • DECODE,TRANSLATE
  • NVL,NVL2(9i)
  • Aggregate Functions

Integrity Constraints :

  • Different Types of Integrity Constraint
  • Use of Integrity Constraint in table

Courses Duration : 3-4 weeks

1
Main