Explore these recommended books to enhance your understanding:
- Fundamentals of Database Systems by Elmasri and Navathe ~ 4th edition
Chapters 2,3, 5,6, 7.1,8,10,11,14,17,18 - "Data Mining Book (Third Edition)"
Jiawei Han(University of Illinois at Urbana–Champaign),Micheline Kamber,Jian Pei(Simon Fraser University)
A comprehensive resource for theory and its applications. - "Introduction to Data Mining (Second Edition)" by Tan, Steinbach, Kumar, & Karpatne,
Course to deepen your knowledge:
- Data Base Management System- IITKGP :NPTEL Course widely appreciated for DBMS
- DBMS COURSE NPTEL covering both Data Mining and Data Warehousing Concepts Lecture Series on Database Management System by Prof.D.Janakiram, Department of Computer Science and Engineering, IIT Madras Dr. S. Srinath, IIIT Bangalore.
Review these comprehensive notes to reinforce your grasp:
- Database Management Systems by MIT: 6.830 Database Systems The Notes are pretty comprehensive and include a syllabus for DBMS asked in the GATE Exam
- Lecture notes on DBMS by UC Berkely: CS 186 UC Berkely The course website contains notes for the portion of the syllabus which is identical to GATE DS/AI Syllabus
- Data Mining Notes from CMU: Data Mining: Spring 2013 The Data Mining offering contains some section which is part of the syllabus, furthermore some of the handout here contains material which might be helpful to prepare other sections ie ML
- Indexing:File Organization Taken from George Washington University Course CS 2451
Read insightful articles to gain additional insights:
- SQL Cheatsheat Data Camp
- DBMS Normalization examples
Test your knowledge and skills with these practice problems:
- Gate CSE PYQ on DBMS
- SQL Practice A standard GitHub repo containing good variety of questions on SQL Query
- Relational Algebra Questions Some Standard Questions on RA by Stanford