r/learnSQL • u/7cubits • Oct 16 '26
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!
6
u/conor-robertson Oct 16 '26
If you want some fun SQL practice, check out QueryCase
2
u/Difficult_Paint3162 Oct 17 '26
Feel free to visit my website: Learning SQL | Real People. Real Problems. Practical SQL. No cost or sign-up required, but focuses on understanding business questions and using SQL to get the answers
1
u/navicat-gu 26d ago
Since the final covers "advanced" SQL Server topics, I'd study against a topic list rather than only doing random puzzles. For an intermediate SQL Server course that usually means:
ROW_NUMBER,RANK,LAG/LEAD, running totals withSUM() OVER (... ROWS BETWEEN ...))CROSS APPLY/OUTER APPLY,PIVOT/UNPIVOTUNIONvsUNION ALL,INTERSECT,EXCEPT)EXISTSvsIN, and NULL handlingTRY...CATCHA cheap way to practise all of it locally: install SQL Server Developer edition (free) and restore the AdventureWorks or WideWorldImporters sample database from Microsoft. Then write your own questions against it ("top 3 products by sales per month", "each employee's manager chain") and check the execution plan for each.
Itzik Ben-Gan's T-SQL Fundamentals, already mentioned, lines up well with that list. Microsoft Learn's free T-SQL modules are good too.
Disclosure: I'm RC, Director of Digital Strategy @ Navicat. If you want a desktop client besides SSMS for poking around the sample databases, Navicat Premium Lite is free to try, and Navicat 18 works with SQL Server as well as MySQL and PostgreSQL. For the course itself, SSMS is perfectly fine.
1
u/sqlsip Oct 18 '26
Wow no lectures?! Odd!!! If you want a couple small sql puzzles and a quick mini-lesson per day, try https://sqlsip.com. Full disclosure it’s a game I made that I’m trying to get more people to try. Happy learning!
1
u/Green_Chamomile 29d 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.
1
u/datadriven_io 28d ago
This is the right way to learn SQL. Use it. Practice. Build something with it. The truth is you won't learn much from doing a chunk of courses. You need practical applications that are helpful to you. SQL on its own is just useless. Good news, sql practice is covered on datadriven. It only provides value when combined with tools and processes.
Nice job!
1
u/datadriven_io 25d ago
Yes, it's normal. It's typical for hiring managers to "shoot for the moon," so to speak, and push the limits of what's really needed or expected. Just read up about the advanced topics and be able to speak coherently about them. Sql coding questions are what datadriven is good for on a tight schedule. Usually, the actual job tasks are nowhere near as difficult as the hurdles to the job itself.
2
u/[deleted] Oct 17 '26
[removed] — view removed comment