30 days to Intermediate SQL: A Real-Time Learning Journey

As a data analyst, SQL is the backbone of my work. As much as I’d love to do nothing but make dashboards all day, the dashboards have to tell a story. And the data is the story. Granted, I will be doing a 30 days to Intermediate challenge PowerBI as well but, I digress.

I have built dashboards before. I have cleaned messy spreadsheets. But honestly, something was missing: my confidence in SQL. Right now, I can write basic SELECT statements to pull data from the database server at work, but it’s not enough. I want to know the language like it’s the back of my paw. So I gave myself a challenge. 30 days to move from “I kinda get it” to “I know what I’m doing and why I’m doing it.”

THE SETUP

Tools: MySQL, Peppermint Tea, a notebook for making notes

Course: Udemy’s The Ultimate MySQL Bootcamp: Go from SQL Beginner to Expert by Colte Steele

Time Commitment: minimum 8 hours a week

Tracking method: Notion template (self created)

MySQL has been downloaded on my pc for quite a while. I use it sometimes for fun. Now I’m using it to dig deeper. Why 8 hours a week? I am still making sure that data analytics fundamentals are secure. Getting drills by chatGPT on real world issues, creating quizzes, and answering flashcards on Quizlet. But also 8 hours a week because I want to dive deeper into the information. The more I work with it, the faster I will learn it.

THE PLAN

Every day: at least 1 hour of SQL by reviewing the course. Watch the video, then write the code. Take any notes as necessary. At the end of each video, summarize the video and copy/paste any code written.

Weekly Structure

Mon–Wed: SQL + Quiz Night (Data+ or SQL concepts)

Thu: SQL + Power BI

Fri: SQL + Light Review (quiz or video recap)

Sat: Longer SQL sprint + light Power BI

Sun: Project Lab (mock dashboards, small SQL builds), Q&A dump

I’m doing this not just to learn SQL—but to prove to myself that I can keep showing up, one query at a time. I’ll check in regularly with reflections on what I’ve learned and any umps in the road.

If you’re doing your own SQL sprint, feel free to follow along or adapt the plan to your own style. The point isn’t perfection—it’s momentum.

Let’s get querying. 🐾

Next
Next

Learning with Professor ChatGPT