Resources
While I hope this course provides a full picture of what's possible with SQL, there are plenty of areas where I have not explored all of the features of the language or where my explanations may be lacking. To supplement the instruction in this course, I've compiled this list of helpful resources.
- SQL Cookbook by Anthony Molinaro and Robert De Graaf. This is an excellent book that is structured in a problem-solution framework. It will give a problem, like "how to calculate running totals" and then provide a discussion of how to solve the problem in SQL along with code for a variety of different SQL dialects. The explanations of groups, partitions, and window functions are outstanding and worth the price by themselves.
- The SQL subreddit is a great place to ask questions or get feedback about your code.
- DBDiagram is helpful if you need to build visual representations of your data model.
- SQLBolt, a free SQL tutorial site that also includes interactive tutorials. Covers most of the same material I have covered, but some may prefer their explanations to mine.
- Find me on LinkedIn. I would be happy to answer questions or provide personalized feedback or recommendations.
Finally, if you find something missing from the course that you think would be helpful, or if you have any other feedback, please let me know!