Advent of SQL

Advent of SQL

Will you attempt 24 days of SQL challenges this Christmas?

🎄

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

The 2024 challenge has already started!

See example challenge
2400+

Join hundreds of SQL lovers ❤️

2024

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

Designed by Maria.design

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 Christmas themed SQL challenges.

From 1st December until Christmas eve 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 have a Christmas themed challenge, and a DB dump with all the data you'll need to complete the challenge (and instructions on how to use it).

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 early intermediate level onwards.

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?

    I'm basing it on Postgres, but you should be able to use any SQL database, your mileage may vary.

  • 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.

  • Can I see an example challenge?

    This was a popular request, so I added one here.

    The challenges, difficulty, and functionality will change a little bit between challenges, so take this as a broad example.