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