SYLLABUS OF ORACLE

Basic Concepts: File Systems vs. DMBS, Characteristics of the Data Base Approach, Abstraction and Data Integration, Database users, Advantages and Disadvantages of a DBMS.

Data Base Systems Concepts and Architecture:   Data Models, Schema and Instances, DBMS architecture and Data Independence, Data Base languages and Interfaces, DBMS functions and component modules.

Entity Relationship Model:  Entity Types, Entity Sets, Attributes & keys, Relationships, Relationships Types, Roles and Structural Constraints, Design issues, E-R Diagrams, Design of an E-R Database Schema, Reduction of an E-R schema to Tables.

Relational Data Model:  Relational model concepts, Integrity constraints over Relations, Relational Algebra – Basic Operations.

MODULE- II

SQL: DDL, DML, and DCL, views& Queries in SQL, Specifying Constraints & Indexes in SQL.

Relational Data Base Management System: ORACLE, Basic structure, Date Base Structure & its manipulation in ORACLE, Storage Organization in ORACLE, Programming ORACLE Applications.

Conventional Data Models: An overview of Network and Hierarchical Data Models.

MODULE-III

Relational Data Base Design:  Functional Dependencies, Decomposition, Normal forms based on primary keys (1 NF, 2 NF, 3 NF, & BCNF), Multi-valued Dependencies, 4 NF, Join dependencies, 5 NF, Domain key normal form.

Practical Data Base Design:   Role of Information systems in Organizations, Database design process, physical database design in Relational Database.

MODULE-IV

Transaction Processing Concepts:   Introduction to Transaction Processing, Transaction & System Concepts, Properties of Transaction, Schedules and Recoverability, Serializability of Schedules.

Concurrency Control Techniques:  Locking Techniques, Time stamp ordering, Multi-version Techniques, Optimistic Techniques, Granularity of Data items.

Recovery Techniques: Recovery concepts, Recovery Techniques in centralized DBMS.

Data Base Security: Introduction to Data base Security issues.