inflearn logo

SQL Problem Solving for Data Analysis (Advent of SQL 2025)

Solve 25 SQL problems of varying difficulty levels. This is a commentary lecture for Advent of SQL 2025, and upon completing the course, you can finish the advent calendar and earn a badge.

27 learners are taking this course

Level Intermediate

Course period Unlimited

SQL
SQL
MySQL
MySQL
PostgreSQL
PostgreSQL
SQLite
SQLite
SQL
SQL
MySQL
MySQL
PostgreSQL
PostgreSQL
SQLite
SQLite
Thumbnail

What you will gain after the course

  • Solving SQL problems across various difficulty levels, from beginner to advanced.

  • Advent of SQL 2025 Completed

Advent of SQL Official Commentary Lecture

solvesql X DATARIAN

Fill out the Advent of SQL calendar!

You can improve your real SQL skills while filling out the twenty-five slots of the calendar.

  • It's a challenge that over 1,000 people have already participated in.

  • Practical ability is more important than SQL theory or certifications.

  • The instructor of the popular Inflearn SQL course "[Action over Words] SQL for Data Analysis" provides the solutions directly.

Recommended for these people


Those who are preparing for a SQL coding test

"I don't know how to prepare for the SQL coding test. Is there a way to study effectively?"


Those who want to upgrade their SQL skills

"I want to master syntax that still feels difficult, such as subqueries and window functions, by repeatedly solving various problems."

Those who know SQL theory but lack practical experience

"I passed the SQLD certification exam, but I didn't exactly understand how to extract and analyze data. Now I need practical experience, not just theory."

After taking this course,

  • It will be the perfect preparation for SQL coding tests.

  • You will become proficient in everything from basic SELECT, FROM, and WHERE syntax to subqueries and window functions.

  • You will become familiar with using functions that handle dates, times, and strings.

Features of this course

The fun of filling up a twenty-five-square calendar

Was solving SQL problems just boring for you? Every time you solve a problem, the calendar fills with vibrant colors. With the fun of completing your very own calendar, studying SQL won't be tedious anymore.

Calendar Complete!

Earn the Advent of SQL 2025 (Too Late) Badge

Are you thinking, 'The Advent of SQL 2025 challenge is already over, is there any point in starting now?' We are awarding the Advent of SQL 2025 (Too Late) badge to everyone who completes the challenge!

See who received the badge 👉https://solvesql.com/badges/advent-of-sql-2025-toolate/

Advent of SQL 2025
(Too Late) Badge

The person who created the lecture

Bomin Lee

  • Current) Datarian CCO

  • Former) JobPlanet Data Analyst

Introduction

Nice to meet you all! I'm Bomin Lee, a data analyst. Once again this year, I've created the commentary lectures for the Advent of SQL 2025 challenge.

All the time you spent pondering over these problems will come together to build your SQL skills. I hope this explanation lecture will be helpful to those studying SQL and preparing for coding tests.

👀 Download SQL Cheat Sheet

Leave the memorization of SQL syntax to the cheat sheet for a moment

Do you have any questions?

Q. Do I need a high-spec computer?

Computer specifications do not matter at all. To ensure that learning is not hindered by program installations or other external factors, all practice sessions are conducted online. Please take the course in an environment with a stable internet connection.

However, since you need to practice directly while watching the lecture screen, we recommend using dual monitors.

Q. I'm new to SQL, can I still take this course?

This course is a problem-solving course and proceeds under the assumption that you are familiar with major SQL syntax. For those who need to learn basic SQL theory, we recommend the SQL Data Analysis Camp | Introductory + Practical Package.

Q. What is the difficulty level of actual coding tests?

solvesql classifies problem difficulty from levels 1 to 5. You can consider most coding test problems to be around level 3 or 4. This is similar to the Medium level on HackerRank and the Medium to Hard levels on LeetCode.

If you are new to SQL coding tests, I recommend the lecture Almost Everything About SQL Coding Tests.

Q. The lecture title says '(Beginner Week 1)', what does that mean?

We will solve problems that can be addressed based on the Week 1 content of the SQL Data Analysis Camp | Introductory Class. If you are curious about Datarian's camps, please refer to the Datarian website!!

Notes before taking the course

Practice Environment

  • solvesql registration and login required

  • Dual monitors recommended


🚩 If you want to improve your basic SQL skills

Recommended for
these people

Who is this course right for?

  • Those who are preparing for an SQL coding test

  • Those who know SQL theory but lack practical experience

Need to know before starting?

  • SQL

Hello
This is datarian

23,608

Learners

2,764

Reviews

29

Answers

4.9

Rating

36

Courses

Experienced working analysts with solid practical experience plan data analysis education and teach the lectures themselves.

If you want to learn more about Datarian

👉 https://datarian.io/

More

Curriculum

All

33 lectures ∙ (4hr 28min)

Course Materials:

Published: 
Last updated: 

Reviews

Not enough reviews.
Please write a valuable review that helps everyone!

datarian's other courses

Check out other courses by the instructor!

Similar courses

Explore other courses in the same field!

Free