inflearn logo
inflearn logo

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) 수강평 17개

강의소개.상단개요.수강생.short

난이도 중급이상

수강기한 무제한

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

먼저 경험한 수강생들의 후기

먼저 경험한 수강생들의 후기

4.8

5.0

Jason

27% 수강 후 작성

Thank you for the great lecture!

5.0

Kumud

30% 수강 후 작성

Loving this..

5.0

똘똘이스머프

100% 수강 후 작성

Thank you for the valuable lecture.

강의상세_배울수있는것_타이틀

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

강의소개.콘텐츠.추천문구

학습 대상은 누구일까요?

  • Person preparing for SQL coding test

  • Knows SQL theory but lacks practice

선수 지식, 필요할까요?

  • SQL

강의소개.지공자소개

23,254

수강생

2,732

수강평

28

답변

4.9

강의 평점

35

강의_other

Experienced working analysts with solid practical backgrounds design the data analysis curriculum and teach the classes themselves.

If you want to learn more about Datarian

👉 https://datarian.io/

더보기

공동 지식공유자

커리큘럼

전체

35개 ∙ (강의상세_런타임_시간 강의상세_런타임_분)

해당 강의에서 제공: [object Object]
강의 게시일: 
마지막 업데이트일: 

수강평

전체

17개

4.8

17개의 수강평

  • doong님의 프로필 이미지
    doong

    수강평 4

    평균 평점 5.0

    5

    23% 수강 후 작성

    • jason8373님의 프로필 이미지
      jason8373

      수강평 5

      평균 평점 5.0

      5

      27% 수강 후 작성

      Thank you for the great lecture!

      • kumuddhabhai251955님의 프로필 이미지
        kumuddhabhai251955

        수강평 1

        평균 평점 5.0

        5

        30% 수강 후 작성

        Loving this..

        • hyongsu44님의 프로필 이미지
          hyongsu44

          수강평 868

          평균 평점 5.0

          5

          100% 수강 후 작성

          Thank you for the valuable lecture.

          • dbekdms1473339님의 프로필 이미지
            dbekdms1473339

            수강평 58

            평균 평점 3.9

            4

            30% 수강 후 작성

            datarian님의 다른 강의

            지식공유자님의 다른 강의를 만나보세요!

            비슷한 강의

            같은 분야의 다른 강의를 만나보세요!

            무료