강의

멘토링

로드맵

Data Science

/

Data Analysis

SQL problem solving for data analysis (Advent of SQL 2024)

Solve 25 SQL problems of various difficulty levels. This is the Advent of SQL 2024 explanation lecture. Upon finishing the lecture, you can complete the Advent calendar and obtain a badge.

(4.8) 6 reviews

425 learners

  • datarian
  • sunmiyoon
sql
sqlite
mysql
SQL
SQLite
MySQL
PostgreSQL
Thumbnail

Reviews from Early Learners

What you will learn!

  • SQL Problems: Beginner to Advanced, Various Difficulties

  • Advent of SQL 2024 Completed

Advent of SQL official explanation lecture

solvesql X datalian

Fill out the Advent of SQL calendar!

You can really improve your SQL skills by filling out the twenty-five spaces on the calendar.

  • This challenge has already had over 1,000 participants.

  • What's more important than SQL theory or certification is whether you can actually do it.

  • Inflearn SQL popular course "[A hundred questions are not as good as seeing once] SQL for data analysis" explained directly by the instructor.

I recommend this to these people


Anyone preparing for the SQL coding test

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


For those who want to upgrade their SQL skills

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

People who know SQL theory but lack practical experience

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

After class

  • This will prepare you perfectly for the SQL coding test.

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

  • You will become familiar with functions for working with dates and times, and functions for working with strings.

Features of this course

The fun of filling a twenty-five-square calendar

Are you bored with solving SQL problems? Every time you solve a problem, your calendar turns colorful. Studying SQL is no longer boring because you have fun completing your own calendar.

Calendar complete!

Earn the Advent of SQL 2024 (Too Late) Badge

Are you thinking, 'Is it too late to start the Advent of SQL 2024 Challenge?' Everyone who completes the challenge will receive the Advent of SQL 2024 (Too Late) badge!

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

Advent of SQL 2024
(Too Late) Badge

Who created the lecture

Yoon Seon-mi

  • Current) Datalian CEO

  • Former Kakao Data Analyst

  • Former Hyperconnect Product Analyst

  • Former Coupang Business Analyst


introduction

Hello! Nice to meet you. I am Seonmi Yoon, a data analyst. I have created this lecture due to many requests for explanations for the Advent of SQL 2024 Challenge. I hope it will be helpful to those who are studying SQL and preparing for coding tests.

👀 Download SQL Cheat Sheet

Leave memorizing SQL grammar to the cheat sheet for now.

Do you have any questions?

Q. Do I need to have good computer specifications?

Computer specifications are not important at all. All practical exercises are conducted online to avoid learning impediments due to program installation and other external factors. Please take the course in an environment with a smooth internet connection.

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

Q. I'm new to SQL. Can I listen to it too?

This lecture is a problem-solving lecture, and the class proceeds assuming that you are familiar with the main SQL grammar. For those who need to learn basic SQL theory, we recommend the SQL Data Analysis Camp | Introduction + Practice Package .

Q. How difficult is the actual coding test?

SolveSQL's problems are classified by difficulty level from 1 to 5. Most coding test problems are considered to be between difficulty level 3 and 4. This is similar to HackerRank Medium and Leetcode Medium~Hard.

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

Q. The lecture title says ‘(Introductory Week 1)’. What does that mean?

SQL Data Analysis Camp | Solve problems based on the content of the first week of the introductory course . If you are curious about Datarian's camp, please refer to the Datarian homepage !

Things to note before taking the class

Practice environment

  • Solvesql membership registration and login required

  • Dual monitor use recommended


Player Knowledge and Notes

  • You can start Day 1 with basic grammar at the level of SELECT, FROM, WHERE, ORDER BY.


  • DBMS Permissions

🚩 If you want to improve your basic SQL skills,

Recommended for
these people

Who is this course right for?

  • Person preparing for SQL coding test

  • Knows SQL theory but lacks practice

Need to know before starting?

  • SQL

Hello
This is

32,375

Learners

2,814

Reviews

23

Answers

4.9

Rating

37

Courses

실무 경험이 탄탄한 현업 분석가들이 데이터 분석 교육을 기획하고, 직접 강의합니다.

데이터리안에 대해서 더 알아보고 싶다면

👉 https://datarian.io/

Curriculum

All

35 lectures ∙ (2hr 54min)

Course Materials:

Published: 
Last updated: 

Reviews

All

6 reviews

4.8

6 reviews

  • 유요한님의 프로필 이미지
    유요한

    Reviews 58

    Average Rating 3.9

    4

    30% enrolled

    • 둥절둥절님의 프로필 이미지
      둥절둥절

      Reviews 4

      Average Rating 5.0

      5

      23% enrolled

      • Jason님의 프로필 이미지
        Jason

        Reviews 5

        Average Rating 5.0

        5

        27% enrolled

        좋은 강의 감사합니다~

        • Kumud님의 프로필 이미지
          Kumud

          Reviews 1

          Average Rating 5.0

          5

          30% enrolled

          너무 좋아요.

          • 똘똘이스머프님의 프로필 이미지
            똘똘이스머프

            Reviews 868

            Average Rating 5.0

            5

            100% enrolled

            귀한 강의 감사드립니다.

            Free

            datarian's other courses

            Check out other courses by the instructor!

            Similar courses

            Explore other courses in the same field!