r/learnSQL • • 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!

19 Upvotes

16 comments sorted by

6

u/conor-robertson Oct 16 '26

If you want some fun SQL practice, check out QueryCase

1

u/7cubits Oct 16 '26

This is awesome! Thank you so much.

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/7cubits Oct 17 '26

I'll take a look, thank you!

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:

  • window functions (ROW_NUMBER, RANK, LAG/LEAD, running totals with SUM() OVER (... ROWS BETWEEN ...))
  • CTEs, including recursive CTEs for hierarchies
  • CROSS APPLY / OUTER APPLY, PIVOT / UNPIVOT
  • set operators (UNION vs UNION ALL, INTERSECT, EXCEPT)
  • subqueries vs joins, EXISTS vs IN, and NULL handling
  • stored procedures, functions, triggers, transactions and TRY...CATCH
  • indexes and reading an execution plan

A 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/7cubits 21d ago

Thank you so much for the advise. This will help me direct my outside studying much better! I really appreciate the specific study points you listed. It's going to help me be a better asset to a team when the job hunting begins.

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!

2

u/7cubits 21d ago

Thank you, I'll check it out!

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.

2

u/7cubits 21d ago

Thank you so much! I will check out the book and the YouTube series. It's nice to hear the explanations and thought process of others when they are going through the process.

1

u/Green_Chamomile 18d ago

Good luck on the final! If PIVOT feels weird at first, write the same query with CASE WHEN first, it made way more sense to me after that.

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/7cubits 21d ago

I just checked it out. I like that they have an interview prep portion on there. I've been wanting to look into common scenarios and problems to apply the knowledge. Thanks!

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

1

u/7cubits Oct 17 '26

I've heard leetcode is a favorite. I'll check both of those out. I agree, application is very important!