9 Best Articles on SQL
The most useful articles on SQL from around the web—beginners to advanced—curated by thought leaders and our community. We focus on timeless pieces and update the list whenever we discover new, must-read articles or videos—make sure to bookmark and revisit this page.
Top 5 SQL Articles
At a glance: these are the articles that have been most read, shared, and saved on SQL by Refind users in 2023 so far.
Trending
These links are currently making the rounds on SQL on Refind.
Understanding database Indexes in PostgreSQL
Understand SQL indexes, organize your knowledge, and memorize good practices regarding performance optimization in PostgreSQL.
Short Articles
Short on time? Check out these useful short articles on SQL—all under 10 minutes.
Writing composable SQL using JavaScript by Gajus Kuizinas
A walkthrough of common patterns of writing SQL queries in JavaScript with the help of Slonik.
The Rise of SQL
SQL dominated the jobs ranking in this year's IEEE Spectrum interactive rankings of the top programming languages. Normally, the top position is occupied by Python or other mainstays, such as C, C++, Java, and JavaScript, but we explain why SQL has soared to the top
Transaction anomalies with SELECT FOR UPDATE
This article shows how surprising transaction anomalies can happen with SELECT FOR UPDATE and what you can to to avoid them.
SQL Murder Mystery
Use SQL queries to solve the murder mystery. Suitable for beginners or experienced SQL sleuths.
Modern, collaborative SQL editor for your team
Write queries, visualize data, and share your results.
Long Articles
These are some of the most-read long-form articles on SQL.
The 5 Hardest Things to Do in SQL
The 5 hardest things Josh Berry, a 15 year analytics professional, experienced while switching from Python to SQL. Offering examples, SQL code, and a resource to customize the SQL to your own project.
6 SQL Tricks Every Data Scientist Should Know
SQL tricks to make your analytics work more efficient
Why SQL is beating NoSQL, and what this means for the future of data
After years of being left for dead, SQL today is making a comeback. How come? And what effect will this have on the data community?
Publications
We monitor hundreds of publications, blogs, newsletters, and news sources in SQL, including:
KDnuggets
KD stands for Knowledge Discovery. Covering #DataScience #MachineLearning #AI #Analytics. Edited by @mattmayo13. Founded by Gregory Piatetsky-Shapiro.
IEEE Spectrum
The latest technology news and analysis from the world's leading engineering magazine
Towards Data Science
A Medium publication sharing concepts, ideas, and codes. Share your insights and projects with like-minded readers: http://bit.ly/write-for-tds.
What is Refind?
Every day Refind picks the most relevant links from around the web for you. Picking only a handful of links means focusing on what’s relevant and useful. We favor timeless pieces—links with long shelf-lives, articles that are still relevant one month, one year, or even ten years from now. These lists of the best resources on any topic are the result of years of careful curation.
How does Refind curate?
It’s a mix of human and algorithmic curation, following a number of steps:
- We monitor 10k+ sources and 1k+ thought leaders on hundreds of topics—publications, blogs, news sites, newsletters, Substack, Medium, Twitter, etc.
- In addition, our users save links from around the web using our Save buttons and our extensions.
- Our algorithm processes 100k+ new links every day and uses external signals to find the most relevant ones, focusing on timeless pieces.
- Our community of active users gets the most relevant links every day, tailored to their interests. They provide feedback via implicit and explicit signals: open, read, listen, share, mark as read, read later, «More/less like this», etc.
- Our algorithm uses these internal signals to refine the selection.
- In addition, we have expert curators who manually curate niche topics.
The result: lists of the best and most useful articles on hundreds of topics.
How does Refind detect «timeless» pieces?
We focus on pieces with long shelf-lives—not news. We determine «timelessness» via a number of metrics, for example, the consumption pattern of links over time.
How many sources does Refind monitor?
We monitor 10k+ content sources on hundreds of topics—publications, blogs, news sites, newsletters, Substack, Medium, Twitter, etc.
Which sources does Refind monitor on SQL?
We monitor hundreds of sources on SQL, including KDnuggets, IEEE Spectrum, Towards Data Science, and many more.
Can I submit a link?
Indirectly, by using Refind and saving links from outside (e.g., via our extensions).
How can I report a problem?
When you’re logged-in, you can flag any link via the «More» (...) menu. You can also report problems via email to hello@refind.com
Who uses Refind?
200k+ smart people start their day with Refind. To learn something new. To get inspired. To move forward. Our apps have a 4.9/5 rating.
Is Refind free?
Yes, it’s free!
How can I sign up?
Head over to our homepage and sign up by email or with your Twitter or Google account.