DBMS & Oracle

Contents

1. Database Management Systems    

1.1 Introduction 

1.2 Database Environment     

1.3 DBMS Features and Capabilities 

1.4 Meta-Data Repository     

1.5 Traditional and DBMS Environment     

1.6 Transaction Control

1.7 Data Processing    

1.8 Data Warehouse     

1.9 Data Mining  

1.10 DBMS Components   

1.11 ODBMS Components  

1.12 Types of Database 

1.13 The Database Approach   

1.14 Centralized System

1.15 Decentralization System 

1.16 Distributed Database    

1.17 Multitier Architecture  

1.18 Three-Tier Architecture 

1.19 Database Administration and Automation    

2. Entity Relationship Model 

2.1 Introduction 

2.2 Logical and Physical Database  

2.3 Mapping Cardinality

2.4 Database Development Process   

2.5 Database Development Life Cycle

2.6 Integrity Constraints    

2.7 Transforming E-R Diagrams into Relations   

2.8 Tree Structure and Hierarchical

2.9 Database Normalization   

2.10 Codd’s 12 Rules   

2.11 Hierarchical Database Model   

2.12 Network Model     

2.13 Relational Model  

2.14 Object/Relational Model 

2.15 Object-Oriented Model   

2.16 Semistructured Model    

2.17 Entity-Attribute-Value (EAV) Data Model   

2.18 Context Model     

2.19 Network Database Model  

2.20 Relational Database Management System     

3. Introduction to Oracle as RDBMS

3.1 Introduction 

3.2 Oracle Database Features 

3.3 Standardization of SQL   

3.4 Elements of SQL    

3.5 Type of SQL  

3.6 Library Functions  

4. Overview of PL/SQL  

4.1 Introduction of Pl/SQL   

4.2 Similar Languages  

4.3 Advantages of PL/SQL     

4.4 Bind Variables     

4.5 Processing Queries with PL/SQL 

4.6 Overview of PL/SQL Control Structures

4.7 PL/SQL Cursors     

4.8 Trigger

4.9 Stored Procedures  

4.10 Stored Functions  

4.11 Parameters in Procedure and Functions     

4.12 Exception Handling

4.13 Sample PL/SQL Programs