RDBMS: Relational Database Management System

By SS Gayatree Devi Uncategorized
Wishlist Share
Share Course
Page Link
Share On Social Media

About Course

RDBMS

DBMS manages databases with various data models, lacking strict relational structure enforcement and standardized querying. RDBMS strictly adheres to the relational model, organizing data into tables with rows and columns, enforcing integrity constraints, and supporting SQL for querying, ensuring data accuracy and consistency in relational databases.

Course Content

Overview of Database Management System
This chapter provides an overview of database management system which includes concepts related to data, database, and database management system. After completing this chapter, the reader should be familiar with the following concepts.

Entity-Relationship Model
This chapter presents a top-down approach to data modeling. This chapter deals with ER and Enhanced ER (EER) model and conversion of ER model to relational model.

Relational Model
This chapter is dedicated to relational model which is in use since late 1970s.

Structured Query Language
This chapter focuses on how to access the data within a DBMS.

PL/SQL
This chapter focuses on the shortcomings of SQL and how it is overcome by PL/SQL.

Database Design
This chapter deals with various phases in database design, objectives of database design, database design tools.

Transaction Processing and Query Optimization
This chapter deals with various concepts in transaction processing. The ACID property that is necessary in transaction processing is discussed in detail.

Database Security and Recovery
This chapter provides an overview of database security and recovery.

Physical Database Design
This chapter describes physical database design which is the final phase of the database development process.

Data Mining and Data Warehousing
This chapter provides an overview of advanced concepts in database management system, which includes concepts related to data mining and data warehousing.

Objected-Oriented and Object Relational DBMS
This chapter provides an overview of object oriented and object relational database management system.

Distributed and Parallel Database Management Systems
This chapter is dedicated to distributed and parallel database management system.

Recent Challenges in DBMS
This chapter provides an overview of recent challenges database management system (DBMS).

Projects in DBMS
Here we have given list of projects using back-end and front-end Programme.

Student Ratings & Reviews

No Review Yet
No Review Yet