You know that SQL is one of the most important technical tools for any data analyst, but how do you learn more advanced topics and get a chance to practice them?
When I first learned SQL, I used LearnSQL as my platform. It is still my favorite place to go back to if I want to know about advanced topics like recursive queries.
It also offers specific courses on MySQL and SQL Server, so you can learn the syntax differences between the two.
They have deals on their lifetime plan happening now, for pre-Black Friday, so if you’re thinking about it, now’s your chance.
Weekly Recap
Here are some of the best posts from the past week. Check them out if you missed them, and don’t forget to add to the conversation.
SQL: The Real Love Language
Good SQL formatting is basically how analysts say, “I care.” Clean code isn’t just tidy, it’s helpful to whoever reads it next (including yourself).
BLOG
Subqueries vs. CTEs
Subqueries work until they don’t. CTEs keep your logic clean and readable when things get messy.
Good Reads
If you’re new here, a few good reads to start with:
• SQL Best Practices for Writing Clean, Reliable Queries
• Excel Will Outlive Us All, And Data Analysts Can't Escape It
• Is the Google Data Analytics Professional Certificate Worth It in 2025?
If you’re building your data portfolio, these will help:
• Where to Find Datasets for Your Data Analytics Projects
• Data Analysis Project Guide
• Building a Data Analytics Portfolio
Appreciate you being on this list!
Till next time,
Sarah
SITES THINGS WORTH CHECKING OUT
Data With Sarah Blog: Tips, articles, and resources for improving your data analytics skills.
The Data Analytics Stash: Plug-and-play resources for analysts. Templates, guides, and tools that make your work faster and cleaner.
Learn and Improve Your SQL Skills: Detailed SQL courses with on-screen practice.
Note: This post includes affiliate links, which help support my work. As an Amazon Associate, I earn from qualifying purchases.
