INTRODUCTION

• RDBMS
• Back-End Programming
• Client Server Architecture
• CODD’s Rule
• Defining Relational Model
• DATABASE OBJECTS: Creating Tables,Views, Sequence
• Synonyms,Indexing,Alert Sequence, Insert Tables
• Constraints. Unique Key, Primary key
• Operator Types:Numeric, Logical, Relational
• Query Expression Operator, Union Intersect,Minus
• Functions: Arithmetic, Group, Data
• SQL & SQL Plus Select Statements
• SQL Data Types of Oracle
• Data Defination, Operators
• Function, Multi-Table
• Queries Sub- Queries
• Normal- Correlated
• DDL & DML Commands
• Pseudo coloumn ROWID, Script Files, Locking
• Commands, Joins , Inner Joins, ARRAY,
• Package Type, Cursor, Exception
• PL SQL Plus
• PL SQL , Tables Arrays
• Data Types - Scalar Composite
• PL SQL Block Structure
• Constraints, Procedure Pkg,Declaration Prog,Constructs
• Cursors, SubBlocks, View & Security, LOB’s Data Types
• Nested Tables
• DATABASE ADMINISTRATION (theory)
• Advanced Oracle, Concepts & Utilities
• Physical & Logical, Table Spaces, Segments, Extent
• Allocation / Deallocation, Truncated Table Command
• COMMIT
• DATABASE TRIGGERS