NEWSLETTER

DBMS & Oracle

BI 1272

New

According to New Revised Syllabus w.e.f. 2010 NAGPUR, Maharashtra (INDIA)


Text Book of DBMS & Oracle

TY BCCA - B.Com.Computer Application (Nagpur)

Author : Ravish K. Mishra

Book ID : 1272

More details

Rs.180

Rs.200

-10%

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

No customer comments for the moment.

Write a review

Write a review

16 other products

16 other products in the same category: