Boston Computer School

Call now to find out how:
617-230-0749

You are here:  Home » Courses » Oracle » ORACLE 10 g 

ORACLE 10 g

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

Course: ORACLE 10 g

BCS Fees: $1750