Preface of the course is to present an introduction to database management systems, with an emphasis on how to organize, maintain and retrieve – efficiently, and effectively – information from DBMS.
Learning Outcomes: Upon successful completion of this course, students should be able to : Describe the fundamental elements of relation database management system , Explain the basic concepts of relation data model , entity- relationship model, relational database design, relational algebra and SQL . Design ER-models to represent simple database application scenarios. Convert the ER-model to relational tables, populate relational database and formulate SQL queries on data. Improve the database design by normalization. Familiar with basic database storage structures and access techniques ; file and page organizations, indexing methods including B tree, and hashing.
Contents –
1. Introduction to DBMS
2. Data Modeling
3. Relation Data Model
4. SQL Introduction
5. Normalization
6. Transaction Processing
7. DBMS Concurrency Control
8. File Organization
9. Indexing and B+ Tree
10. Hashing
11. RAID
12.Introduction to PL/SQL
13.DBMS & SQL Interview Question for Campus Interviews.