This course is designed to provide a comprehensive understanding of database management and warehousing concepts. It covers a wide range of topics including database design, data modeling, SQL queries, data normalization, data warehousing, and data mining techniques. The course will also focus on the practical aspects of implementing database management systems and designing efficient data warehouses. By the end of this course, you will have a strong foundation in database management and warehousing, which are vital skills in the field of data science and AI.

GATE Data Science and AI DBMS and Warehousing Syllabus

ER-model, relational model: relational algebra, tuple calculus, SQL, integrity constraints, normal form, file organization, indexing, data types, data transformation such as normalization, discretization, sampling, compression; data warehouse modelling: schema for multidimensional data models, concept hierarchies, measures: categorization and computations.