OBIEE


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