dbms online tutions dbms online tution

Online | Offline Tutions for DBMS(Database Management Systems)

Visit http://www.learninggeeks.info for Registration. 

Call us @ 9718322472, 9810333483 

Mail us for any queries: learninggeeks@gmail.com 

DBMS Course Details: 

 I: Introduction

1.1 Purpose of Database system
1.2 Characteristics of database approach
1.3 Advantages of using DBMS
1.4 Database concept and architecture
1.5 Data Abstraction
1.6 Data Models
1.7 Instances and schema
1.8 Data independence
1.9 3-schema architecture
1.10 Database Languages
1.11 Database Manager
1.12 Database Administrator
1.13 Database Users

 II: Data Modeling

2.1 Entity sets attributes and keys
2.2 Relationships (ER)
2.3 Database modeling using entity
2.4 Type role and structural constraints
2.5 Weak and Strong entity types
2.6 Enhanced entity-relationship (EER)
2.7 Entity-Relationship Diagram Design of an E-R Database schema
2.8 Object modeling
2.9 Specialization and generalization
2.10 Modeling of union types

 III: Data Models

3.1 Hierarchical models - basic concepts
3.2 Tree structure
3.3 Tree-structure Diagrams
3.4 Virtual records
3.5 Mapping hierarchies to files
3.6 The IMS Database system
3.7 Network model - basic concepts
3.8 Mapping networks to files
3.9 DBTG CODASYL model

 IV: Relational Model

4.1 Relational model -basic concepts
4.2 Enforcing Data Integrity Constraints
4.3 Relational-Algebra Operations
4.4 Extended Relational Algebra Operations
4.5 Relational Calculus
4.6 Assertion and Triggers
4.7 Introduction on views
4.8 Codd's Rules

 V: Database Design

5.1 Database design process
5.2 Relational database design
5.3 Relation Schema
5.4 Anomalies in a database
5.5 Functional dependencies
5.6 Membership and minimal covers
5.7 Normal forms
5.8 First Normal Form
5.9 Second Normal Form
5.10 Third Normal Form
5.11 Boyce-Codd Normal Form
5.12 Multivalued dependencies
5.13 Fourth Normal Form
5.14 Join dependencies
5.15 Fifth Normal Form
5.16 Inclusion dependencies
5.17 Reduction of an E-R schema to Tables
5.18 Converting EER Diagrams to relations
5.19 Practical database design tuning
5.20 Effect of de-normalization on database performance

 VI: Query Languages

6.1 Query-by-example(QBE)
6.2 Introduction to SQL
6.3 Overview of SQL 92
6.4 Basic queries in SQL
6.5 Advanced queries in SQL
6.6 Functions in SQL
6.7 Basic data retrieval
6.6 Aggregation
6.7 Categorization
6.8 Updates in SQLs
6.9 Views in SQL
6.10 Different types of views
6.11 Theoretical Updatability of Views
6.12 Embedded SQL and 4GLs
6.13 Procedural extension to SQL

§  PL/SQL

§  T-SQL

 VII: File Organization,Indexing and Hashing

7.1 Overview of file organization techniques
7.2 Secondary storage devices
7.3 Operations in files
7.4 Heap files and sorted files
7.5 Indexing and Hashing- Basic concepts

1.  
   • Static Hashing
   • Dynamic Hashing and Extendible hashing
   • Ordered indices
   • Types of single level ordered index
   • Multi-level indexes basics
   • Other types of indexes

7.6 Multi-level indexes

1.  
   • B-Tree index files
   • B+- Tree index files
   • Bitmap index
   • Hash Index

7.7 RAID technology
7.8 Buffer management

 VIII: Transaction Processing

8.1 Desirable properties of transactions
8.2 Implementation of atomicity and durability
8.3 Reconsistent Model
8.4 Read only and write only model
8.5 Concurrent executions
8.6 Schedules and recoverability
8.7 Serializability of schedules concurrency control
8.8 Serializability algorithms
8.9 Testing for Serializability
8.10 Precedence graph

 IX: Concurrency Control

9.1 Overview of Concurrency Control
9.2 Locking techniques
9.3 Lock based protocols
9.4 Time stamp based protocols
9.5 Commit protocols
9.6 Optimistic technique
9.7 Granularity of data items
9.8 Time stamp ordering multi version concurrency control
9.9 Deadlock handling - detection and resolution

 X: Database Backup and Recovery

10.1 Recovery mechanisms
10.2 Crash recovery
10.3 Recovery from transaction failure
10.4 Recovery in a Centralized DBMS
10.5 Virtual memory and Recovery
10.6 Database recovery techniques based on immediate and deferred update
10.7 ARIES recovery algorithm
10.8 Shadow pages and Write-ahead Logging

 XI: Query Processing and Optimization

11.1 Overview
11.2 Query interpretation
11.3 Equivalence of expressions
11.4 Join strategies for parallel processing
11.5 Algorithm for executing query operations
11.6 Heuristics of Query Optimization
11.7 Catalog information for cost estimation of queries
11.8 Basic query optimization strategies

1.  
   • Selection operation
   • Sorting
   • Join operation

11.12 Algebraic manipulation

 XII: Advanced Database Application

12.1 Evolution of an Information system
12.2 Decision making and MIS
12.3 MIS as a technique for making programmed decisions
12.4 Navigation Database System Architecture Overview
12.5 Data Mining
12.6 Data warehouse
12.7 Types of transaction processing system

1.  
   • OLAP
   • OLTP
   • DSS

 

 XIII: Distributed Databases

13.1 Structure and design
13.2 Distributed query processing
13.3 Fragments of Relations
13.4 Optimization trasmission cost by semi joins
13.5 Distributed Concurrency Control
13.6 Client/Server Model
13.7 Parallel databases

 XIV: Object Oriented Database Design

14.1 Introduction
14.2 Approaches to OODs
14.3 Object oriented data model

1.  
   • Object identity
   • Complex Objects
   • Persistance
   • Type and class hierarchies
   • Inheritance

14.4 Modelling and designing of OODs
14.5 Object oriented queries
14.6 Versioning in OODs
14.7 Object Relational DBMS-Overview

Implementing Security in Databases  

15.1 Security & integrity threats
15.2 Defence mechanisms
15.3 Statistical database auditing & control
15.4 Security issue based on granting/revoking of privileges
15.5 Introduction to statistical database security

Case Study on Popular Database Packages 

16.1 Oracle
16.2 MySql
16.3 Ingres
16.4 Postgres

 

 

Posted via web from learninggeeks's posterous