training@globalonlinetrainings.com

mobile: +91 8121020333

Oracle 10g

Oracle 10g Course Content

DBMS
  • Concepts of DBMS
  • Introduction
  • Importance & Need
  • Database Models & Normalization
  • Models
  • Hierarchial
  • Relational
  • Object
  • Normalization Techniques
RDBMS Introduction
  • Concepts of RDBMS
  • Introdution
  • Comparision with DBMS
  • COOD Rules
  • Normalization Revisited
  • ORDBMS & OODBMS Concepts
  • ORDBMS & OODBMS Introductions
  • Comparision & analysis
Structured Query Language
  • SQL Introduction
  • Predefined Data Types
  • Database objects Introduction
  • Table,View
Commands in SQL
  • Data Definition Languages
  • Data Manipulation Languages
  • Data Control Languages
  • Transaction Control Languages
  • Database Security & Privileges
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 Function
Integrity Constraints
  • Integrity Constraint Types
  • Use of Integrity Constraint in table