At a glance
- 4 lecture hours per week
- 4 credits
- II Semester
- Topics of Study: DBMS
Course Objectives
- Enumerate the various flavours of structured query languages
- Explain the techniques for storage and indexing of data
- Describe query processing, query optimisation, and transaction management
- Explain the need for database security
- Explain use of database programming to retrieve data
- Describe how distributed and multimedia databases are used
- Explain the concepts of data mining and data warehousing
Prior Preparation
Course Description
The course enables working with a database management system (DBMS). It covers various techniques used for storage and indexing of data. A significant part of the course deals with advanced topics related to databases and their management, including database security, distributed databases, data mining, and data warehousing.
Learning Resources
- Elmasri, R., & Navathe, S. B. (2011). Fundamentals of database systems. Pearson.