Contents
CHAPTER 1
INTRODUCTION TO DBMS COMPONENTS OF DBMS FILE-ORIENTED SYSTEM FUNCTIONS OF DBMS: RELATIONAL DATABASE MANAGEMENT SYSTEMS OBJECT RELATIONAL DATABASE MANAGEMENT SYSTEM ENTITY-RELATION SHIP DIAGRAMS RELATIONAL MODLE HIERARCHICAL MODEL NETWORK MODEL MAPPING: TYPES OF KEYS: NORMALIZATION
CHAPTER 2
INTRODUCTION TO SQL BASIC ELEMENTS OF SQL: DATA TYPES LITERALS FORMAT MODELS NULLS COMMENTS DATABASE OBJECTS
TYPES OF SQL STATEMENTS DATA DEFINATION LANGUAGE (DDL) DATA MANIPULATION LANGUAGE (DML) DATA CONTROL LANGUAGE (DCL) TRANSACTION CONTROL LANGUAGE (TCL) LOCK TABLE SQL FUNCTIONS EXPRESSIONS SQL OPERATORS INTEGRITY CONSTRAINTS SUB QUERIES (OR) NESTED QUERIES SQL VIEWS: SQL JOINS SQL Alias SQL INDEX CLUSTERS ROLES CONDITIONS SEQUENCES
CHAPTER 3
INTRODUCTION TO PL/SQL FEATURES OF PL/SQL CONDITIONAL CONTROLS CURSORS
ERROR HANDLING/EXCEPTIOIN DATA TYPES COLLECTIONS AND RECORDS TRIGGERS SUB PROGRAMS PACKAGES FILE INPUT/OUTPUT AUTONOMOUS TRANSACTION Sample PL/SQL Programs Sample 1. FOR Loop Sample 2. Cursors Sample 3. Batch Transaction Processing Sample 4. Calling a Stored Procedure