I found the combination of real-world problems, general SQL advice, and the broad range of topics to be a really good book. It took my SQL from “the database is not much more than a place to persist application data” to “the application is not much more than a way to match commands to ... More on news.ycombinator.com

Another thing, the invalid / incomplete query alert gets in the way of looking at the last data row. Perhaps you can find a better location to show this alerts · It's an interactive tutorial, and I'm looking to add a few more topics along the way. Curious to see what HN thought, and whether ... More on news.ycombinator.com

Look here for a very general introduction to SQL and databases: https://learnsql.com/blog/sql-primer/sql-primer.pdf Why don't you just try SQLBolt? It's available for free. It will give you an understanding of what SQL and databases are about, and you will get your feet wet with writing SQL. In my opinion just SQLBolt will not be enough to get any serious job requiring SQL, but it's a very good starting point. After that you may look here for additional resources: https://www.reddit.com/r/learnSQL/comments/1c4pykk/im_done_with_sqlbolt_what_should_i_do_next/ More on reddit.com

Hey so you don't need to download anything for PGExcercises! You CAN if you want to but you don't need to. Here's a SQL learning guide you can follow: https://datalemur.com/blog/learn-sql-in-30-days-roadmap Otherwise here's my recommendations I recommend going through Data Lemur and Mode Analytics SQL Tutorial, they both have overlapping material that will help with reinforcement. And Code Wars Finally when you get to this point of being able to use Window Functions, go to windowfunctions.com and work through the material there. PGExcercises has excercises on Window Functions but I'd say it wasn't as helpful as windowfunctions.com. Lastly to really reinforce the material strongly, and I mean CHALLENGE to prove material mastery I recommend working through the classes on EDX from Stanford University. They have a series of Database courses from Dr. Widom that are really well recommended on reddit for a reason. Or work through CS50SQL from Harvard is an all around comprehensive course and is highly recommended as well. The sequence I'd recommend is: Mode Analytics and Data Lemur's SQL Tutorial Code Wars SQL tag for their tutorial series of questions and to see other's solutions Widom's SQL Courses on EDX or Harvard's CS50SQL (Optional, intense but really helps with reinforcement) windowfunctions.com (look through the tutorial, watch some videos on each window function or look up blog posts about it) Go through the excercises on PGExcercises for reinforcement Go through interview questions on StrataScratch, DataLemur and Interview Query This is an immense amount of material, don't let the bullet points make it seem smaller than it really is. But for Data Analytics there's a lot to utilize in SQL. More on reddit.com