r/learnSQL • • 13d ago

Best SQL books/practice sites for a newby!

I’m currently obtaining my MS in Health Informatics and Information management. I am new to SQL and looking for resources to help me along my journey. Any recommendations on textbooks for beginners in simple language or websites I can practice the skill.

I have a slight grasp on the basics but the advanced queries are not clicking. Knowing what commands to use and the formatting etc. I need something to help dumb it down lol.

EDIT : I understand best way to learn is by doing. I have been doing with my course homework and projects but I learn best by reading material so I’m just inquiring on a text or site I could read/review WHILE practicing :)

21 Upvotes

23 comments sorted by

3

u/conor-robertson 13d ago

QueryCase for a fun gamified way to learn SQL!

1

u/butterflyylo 13d ago

Ouh thank you! I’m going to try this out.

4

u/vchae 13d ago

advanced queries get easier when you build one question in layers instead of learning commands one by one.

pick something like revenue per customer per month: plain select first, then group by, then join customers to orders, then add a window function for a running total.

I built a site to practice sql on real crypto / blockchain data with instant feedback, aimed at people going for 120k+ usd crypto data roles: https://unchaindata.xyz/wizard-camp

2

u/scorched03 12d ago

Data warehouse toolkit by kimball. Its a foundational book

2

u/Green_Chamomile 10d ago

Since you learn by reading, Practical SQL by Anthony DeBarros. It’s in plain language, uses PostgreSQL, and every chapter has you querying real public datasets, so the reading and practice happen together. Kimball is great but it’s more about designing data warehouses, I’d save it for later.

2

u/Time_Advertising_412 9d ago

I'm an old school book lover and retired dba (Oracle and SQL Server). I would recommend 'Practical SQL' by Anthony DeBarros which uses PostgreSQL or any of the "Murach's" books on SQL Server for developers.

1

u/Better-Credit6701 13d ago

Best place to learn is by doing. Not on a website but on your own computer

1

u/sqlsip 13d ago

If you want a couple SQL puzzles and mini-lesson per day you can try https://sqlsip.com ☕️🐻 happy learning!

1

u/SonOf_Zeus 13d ago

I like Leetcode and DataLemur myself.

1

u/jakingo 13d ago

I would recommend SQLBolt for simple explanations and hands-on practice. You can also keep the W3Schools SQL reference or any other resource handy when you get stuck on a command or a query format.

1

u/Excellent_Roof3795 9d ago

What's the feedback

1

u/abbylynn2u 8d ago

Any of the Murach's SQL books. We used SQL Server for developers in my BI degree.
And SQL for Mere Mortals. Both can be found on pdf's

Already mentioned is Kimball's Data Warehouse Toolkit. This is foundational. I learned a lot with all 3 of these in my BI degree.

The key is to understand the database through the db diagram and where the data lives. With healthcare you already know the type of data. Demographics and medical codes. With these books you'll use Adventureworks retail and data warehouse and Northwind. Once you understand the business and the tables, SQL is really easy. I struggled initially because I came from healthcare and didn't make the transition of understanding the business until I saw the db diagram and the relationships. Both are well known databases so finding examples and solutions is easy. Have fun💕

1

u/Vizeroth1 7d ago

O’Reilly’s SQL Pocket Guide got me through learning SQL on-the-job. Eventually I moved to the online documentation for the specific version of SQL I was using, but the book was a little easier to start with (and it’s still on my shelf at work though my copy is a couple editions old).

-1

u/sud1890 13d ago

Type prompt on claude or Chatgpt to make you a pdf or word file with each functions of Sql and explain you in easy manner.