Oracle

ORACLE 10g

DBMS:

• Concepts of DBMS

· Introduction

· Importance and Need

· Database Models and Normalization

· Models

· Hierarchical

· Network

· Relational

· Object

· Normalization Techniques

Introduction to RDBMS:

• Concepts of RDBMS
• Introduction
• Comparison with DBMS
• CODD rules
• Normalization Revisited

· Concepts of ORDBMS & OODBMS

· Introduction to ORDBMS

· Introduction to OODBMS

· Comparison and analysis

Structured Query Language

• Introduction to SQL
• Predefined Data Types
• Introduction to database Objects
• Table, view

Commands in SQL

• Data definition 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 function:- DECODE, TRANSLATE

· NVL ,NVL2(9i)

· Aggregate Functions

· Integrity Constraint

· Different Types of Integrity Constraint

· Use of Integrity constraint in table

· Joins

· Usage of joins

· Different Types of joins

§ Equip join, Cartesian join

§ Self join, outer join

· Sub queries

· Need of sub queries

· Nested sub queries

· Co-related sub quires

· Flashback queries (9i)

· View

· Importance of views

· Creating, manipulating views

· Materialized views(9i)

· Working with database objects

o Sequences and synonyms

o Index, cluster, creating cluster table

Using external tables(9i)

o System privileges

o Table privileges

· Locks and SQL plus editor commands

PL/SQL

• Introduction to PL/SQL
• Advantages of PL/SQL
• Data types in PL/SQL
• Variable and constants
• Assignments and constants
• Referencing NON-PL/SQL Variable
• Using built in functions
• Conditional and Iterative statements
• SQL in PL/SQL
• Composite data types
• Cursors
• Exception:-predefined, user-defined
• Records and PL/SQL table types

Advanced PL/SQL

• Introduction to Triggers
• Types of triggers:-row levels, statements level
• Before and after, instead of triggers
• Procedures, functions in PL/SQL
• Argument modes
• User defined packages
• Dropping triggers, procedures, functions
• Reference cursors
• Usage of ref cursors in procedures, functions, packages