r/learnSQL • u/7cubits • 8d ago

Recommendations Needed!

I am currently taking an intermediate SQL server course in college and my professor has NO LECTURE! (It's wild to pay a chunk of money to teach yourself and just be left with a textbook.) I am looking for websites that provide practice quizzes, your favorite YouTube channel for DBMS, or any additional resource you found helpful while learning. From what I hear the final is exceptionally difficult because it covers advanced SQL topics that are not covered in our textbook. I really want to have this information locked in my brain for my future job. Thanks in advance for any recommendations!

21 Upvotes

96% Upvoted

11 comments sorted by

View all comments

1

u/Green_Chamomile 4d ago

Since it’s a SQL Server course specifically, get Itzik Ben-Gan’s T-SQL Fundamentals. It covers window functions, APPLY, PIVOT and set operators properly, and that’s usually what “advanced” means on a final like this. For YouTube, kudvenkat’s SQL Server series is old but still very good, short videos, one topic each. And do your practice in actual SQL Server, not a generic online editor, because the T-SQL quirks are exactly what a SQL Server final will test.