Advent of SQL

Become a SQL pro in 25 days for Free

🎄

CREATE TRIGGER advent_of_sql
BEFORE INSERT ON days_of_christmas
FOR EACH ROW
EXECUTE FUNCTION deliver_sql_challenge();
🎁 loading...

Starts in

days
hours
min
sec

What is this?

Just like in your lovely chocolately advent calendar, this Christmas you get a SQL-y advent calendar.

But instead of chocolate behind the doors, you get SQL challenges.

From 1st December until Christmas day you'll get a daily challenge emailed to you to sharpen your SQL skills.

Each day a new advent door will swing open. Inside you'll see a video about a specific SQL skill, a written challenge, and a DB dump with all the data you'll need to complete the challenge (and instructions on how to use it).

You have 24 hours to complete it before you'll get the solution revealed to you.

Who is this for?

This is for anyone who wants to get better at SQL. You'll get the most out of this if you're a beginner to early intermediate level.

FAQ's

  • Is this free?

    Yes, there's no charge for anything.

  • Can I start after 1st December?

    Yes, you can start at any time between 1st Dec to 25th December 2024, but you'll only receive the challenges every 24 hours from the day you sign up. And the first challenge will only be available after December 1st 2024.

  • How long will each day take?

    Roughly 10-20 mins per day

  • What database system are we using?

    Postgres!

    Most of the lessons will include postgres functions but you should be able to find analogous functions in your DB of choice.

  • Why would I want a SQL advent calendar?

    Why wouldn't you?

    But for real, why not finally get around to improving your SQL skills like you promised yourself last Christmas? Treat yourself 😉 🎁

    Plus you can brag to your mates, colleagues, and partner about your SQL-fu.

  • Do I have to complete the days in order?

    Kind of, each day builds on the last, if you think you know the skill for that day test yourself by jumping straight to the challenge. If you can't pass the challenge try watching the lesson (use 2x speed if its too slow for you).