Simon Willison’s Weblog

What are the key insights in mastering SQL queries?

My answer to What are the key insights in mastering SQL queries? on Quora

You may find this article useful (despite the list-o-matic name): 10 Easy Steps to a Complete Understanding of SQL—I’ve been using SQL for years but I found that some of the concepts explained there helped firm up my fundamental understanding of how to use it effectively.