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
