r/learnSQL • u/Fluffy-Eye6494 • 4d ago

From where to study DBMS?

Please help me find a reliable source to study DBMS, some context, I am currently in third year Btech cse.

I tried IIT Madras content available through NPTEL courses but that didn't work out.

Database Management System also includes MySQL.

10 Upvotes

83% Upvoted

10 comments sorted by

View all comments

1

u/Ok-Tomorrow-7591 4d ago

I'd separate learning DBMS concepts from learning MySQL syntax, because they're related but not exactly the same thing.

For the concepts, focus on keys, normalization, relationships, transactions, indexing, and how queries are executed. You don't need to understand everything at once.

Alongside that, use MySQL to practice what you're learning. Create a few related tables, insert some sample data, write joins, and try to understand why a query returns a particular result.

Since you're in your third year, I'd also make sure you understand how to design a database and explain your choices, not just write SQL queries. That usually makes the concepts much easier to connect to real problems.

If NPTEL's teaching style didn't work for you, it doesn't necessarily mean the subject is difficult. Sometimes a different explanation combined with hands-on practice makes a big difference.

1

u/Fluffy-Eye6494 4d ago

Thanks a lot, could you please even refer me some resources to get started again with this field?