Course Details

DBMS & RDBMS Training Program

Database management system

 

Course description

 

The course, Database Management Systems, provides an introduction to the management of database systems. The course emphasizes the understanding of the fundamentals of relational systems including data models, database architectures, and database manipulations. The course also provides an understanding of new developments and trends such as Internet database environment and data warehousing. The course uses a problem-based approach to learning.

 

Course outline

 

Part 1.1: Database Environment  

1. Explain why database management is an exciting and growing field with ample job opportunities. 

2. 2. Provide definitions of key terms and concepts that describe the database environment. 

3. 3. Describe data models and how they are used to capture the nature and relationships among data. 

4. 4. Identify the broad spectrum of applications and describe how business organizations are using database applications for competitive advantage.

5. 5. Describe the major components of the database environment and explain how these components interact with each other.

 

Part 1.2: Database Development Process  

1. Provide a comprehensive overview of various concepts and issues in database management.

2. Provide a review of systems development methodologies, particularly the systems development lifecycle and prototyping; show how database development fits with these methodologies.

3. Describe how packaged data models can be used to shorten the development process and improve the quality of data models.

4. Describe the different roles involved in a database development team.

 

MODULE 2: DATABASE ANALYSIS

Part 2.1: Modeling Data  

1. Describe why understanding of organizational data is important. Argue why unambiguous representation of data in logical terms is needed for implementing a database that will effectively serve the needs of management.

• Present the E-R model as a logical model that can be used to capture the structure and much, although not all, of the semantics (meaning) of data.
• Apply E-R modeling to several practical examples.

 

Part 2.2: Enhanced E-R Model and Business Rules  

1. Describe the concept of supertype/subtype relationships and recognize when to use these relationships in data modeling.

• Describe the use of specialization (top-down perspective) and generalization (bottom-up perspective) as complementary techniques for defining supertype/subtype relationships.
• Use the notation for specifying both completeness constraints and disjointness constraints when modeling supertype/subtype relationships. 4. Describe the basic premises of a business rules paradigm and a simple framework for categorizing business rules.

5. Use the notation for modeling typical operational constraints that can be incorporated in an EER diagram.

 

MODULE 3: DATABASE DESIGN

Part 3.1: Logical Database Model and the Relational Model  

1. Describe the position of logical database design within the overall database development process.

2. Describe the relational model including the properties of relations, integrity constraints, and well-structured relations.

3. Describe the principles and detailed steps involved in mapping EER diagrams to relations.

4. Describe the principles of functional dependencies, determinants, and related concepts of normalization.

5. Describe why normalization is important to stable database design with the relational model and concisely describe the various normal forms and the normalization process.

6. Describe some of the anomalies that arise when merging relations and discuss how these anomalies can be addressed.

 

Part 3.2: Physical Database Design

1. Argue why physical database design is a critical element in achieving overall database objectives, rather than as an afterthought.

• Describe the factors that must be considered in distributing data effectively and how a simple model can be used to obtain at least a first-cut distribution.
• What are indexes and what are the trade-offs that must be considered in their use.
• Describe why denormalization must be used with great care and for specific reasons.

 

MODULE 4: DATABASE IMPLEMENTATION

Part 4.1: Introduction to SQL

1. Describe SQL and summarize its basic operators.

2. Provide a historical perspective of the development of SQL and its continuing development.

3. Show that SQL, although standard and a high level language, does have some flaws, and that SQL must evolve to include additional features.

4. Explain and illustrate the power of relational views for simplifying relational database processing.

5. Illustrate data definition language (DDL) commands for creating tables and views as well as for modifying and dropping tables.

6. Formulate single table SQL queries.

7. Formulate SQL queries that use functions.

8. Show how to establish referential integrity using SQL.

9. Use of the group by and order by clauses in SQL queries.

 

Part 4.2: Advanced SQL

1. Demonstrate SQL capabilities such as multiple-table data retrieval (join and other operators such as difference, union, and intersection), explicit and implicit joining, and built-in functions.

• Illustrate the differences between the joining and subquery approaches to manipulating multiple tables in SQL.
• Describe triggers and stored procedures and provide examples of how these might be used.

 

Part 4.3: Client/Server Database Environment

1. Provide a comprehensive view of the possibilities of client/server computing and the advantages and disadvantages of different architectural structures.

• Provide a framework for discussion of tiered architectures and the vocabulary that goes along with it.
• Describe the conceptual underpinnings of connections to remote databases.

 

Part 4.4: Internet Database Environment

1. Describe the importance of new and emerging technologies that will carry businesses forward in a constantly evolving environment.

• Define the different constructs of the Internet and the Web-enabled database, and provide a comprehensive view of how they work together.
• Describe how clients pull up remote applications and data.

 

Part 4.5: Data Warehousing  

1. Argue the fact that many organizations today are experiencing an information gap; they are drowning in data but starving for information. 2. Define data warehousing and describing characteristics of a data warehouse.

• Describe major factors that drive the need for data warehousing as well as several advances in the field of information systems that have enabled data warehousing.
• Contrast operational systems and information systems from the point of view of data management.
• Describe the basic architectures that are most often used with data warehouses.
• Contrast transient and periodic data, and discuss how data warehouses are used to build a historical record of an organization.
• Discuss the purposes of populating a data warehouse and the problems of data reconciliation.
• Contrast data warehouses and data marts.
• Describe and illustrate the dimensional data model (or star schema) that is often used data warehouse design.

 

RELATIONAL DATABASE MANAGEMENT SYSTEM

 

Course description

The course is to expose the students to the fundamentals & basic concepts in relational Data Base Management Systems. This course discusses architecture of Database Systems with concept of relational model & ER model. This course explains techniques for database design, Normalization and database recovery and protection.

 

Course outline

 

Module I – Introduction to Data base & RDBMS

Descriptors/Topics

Introduction: definition of data, uses & need of data in organizations, Need for Information, Qualities of Information, Definition of DBMS, Entities & their attributes, advantages & disadvantages of DBMS, DBMS Architecture, Functions of DBMS , Uses of DBMS File System Approach Vs DBMS Approach, Data Models:The hierarchical model, the network model, the relational model and OORDBMS

 

Module II- Database Design

Descriptors/Topics

Understanding the need for Data base, mapping users output needs with database design, Feasibility Study Understanding fields, record, file and database, designing front end and back end user interface, integration of backend database with online and traditional interfaces using MSACCESS Definition and need of Normalization, First Normal Form, Second Normal Form, Third Normal Form. Relations, domains & keys.

 

Module III - Relational Model & SQL

Descriptors/Topics

Understanding the history of RDBMS, its role and importance of creating robust database, RDBMS Terminology, CODD's rule for RDBMS, Concept of Relational Model, and SQL: SQL Database creation & manipulation views & queries on RDBMS

 

Module IV - Database Recovery & Backup, Performance & Security

Descriptors/Topics

Introduction to database Recovery, Concurrency Control Techniques, Locking mechanism, Dead Locks, Techniques of backup, RAID configuration, database Security techniques and storage technique- DAS, NAS, SAS.