강의

멘토링

커뮤니티

BEST
Data Science

/

Data Analysis

[A hundred words are not as good as seeing once] Advanced SQL for data analysis

Inflearn cumulative students of over 30,000, Datarian's advanced SQL course with extensive online/offline teaching experience. Learn advanced SQL theory and solve 25 practice problems together.

(4.8) 321 reviews

3,435 learners

SQL

Reviews from Early Learners

What you will gain after the course

  • Importing data with SQL

  • The third lecture in the SQL Basics series that even people who have never coded before can understand!

📢 [Course Update Notice] Upgraded in November 2025. (Last Updated: November 27, 2025)

Updates
- Changed practice platform from w3schools to solvesql for faster and more stable SQL practice
- Updated and added existing SQL practice problems (total of 25 practice problems in advanced level)
- Provided new SQL cheat sheet
- Enhanced window function section practice and exercises, and added advanced topic (Frame)

SQL theory lectures are abundant,
but why aren't there any lectures where you can build real skills by practicing problem-solving alongside learning?

Just as studying English grammar alone won't improve your conversational skills without actual practice,
you can't properly use SQL by only studying its syntax.

Course Introduction 📝

Welcome to the advanced class, having completed the SQL basics and intermediate courses!

👏👏(clap clap clap)👏👏

So far, you've learned the basic SQL syntax (joining multiple tables, performing group operations, etc.),
and from now on, we'll cover various SQL features for solving more complex and challenging problems.

Through the advanced course, you'll be able to develop the skills to efficiently handle various operations needed in practical work,
and you can also pursue in-depth learning through additional materials provided in the middle or at the bottom of the lectures.

Great job to all the students who have completed the course from basics to advanced level!

Features of the Course

[Practice Makes Perfect] Advanced SQL for Data Analysis

  1. [Practice Makes Perfect] Hands-on learning approach (solving a total of 25 problems)
  2. For Data Analysis" → A curriculum focused on SQL features essential for data analysis
  3. "Advanced SQL" → Requires prerequisite knowledge of intermediate grammar (GROUP BY, conditional statements, pivot tables, JOIN). You can challenge yourself to achieve high scores in coding tests

[Practice Makes Perfect] The Difference Between Basic, Intermediate, and Advanced SQL

[데이터리안] 고급 SQL.png.webp

Previous Lecture Review 🔖

[Practice Makes Perfect] Basic SQL for Data Analysis
Learn basic SQL syntax and solve real problems
[Practice Makes Perfect] Intermediate SQL for Data Analysis
Strengthening SQL Skills for Practical Work Applications

Recommended for
these people

Who is this course right for?

  • People who have learned SQL theory but feel they lack practical experience

  • People preparing for SQL coding tests

  • People who need a problem-solving-focused SQL lecture

  • Anyone who wants to start learning SQL without any plan!

  • People who want to become data analysts

Need to know before starting?

  • Take a SQL Basics Course for Data Analysis

  • Take an intermediate SQL course for data analysis

Hello
This is

30,525

Learners

2,706

Reviews

23

Answers

4.9

Rating

35

Courses

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

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

👉 https://datarian.io/

Curriculum

All

46 lectures ∙ (4hr 33min)

Published: 
Last updated: 

Reviews

All

321 reviews

4.8

321 reviews

  • 세바스찬 주니어 3세님의 프로필 이미지
    세바스찬 주니어 3세

    Reviews 15

    Average Rating 4.7

    5

    97% enrolled

    현재 현업에서 SQL을 사용하고 있는 중이고, 개념을 전반적으로 다시 정리하기 위해 기초반부터 고급까지 전 강의 정주행 하였습니다. 먼저 강의 내용 자체는 정말 알차고 여러모로 큰 도움이 된 것 같습니다. 다만, 각각의 강의 영상 별로 볼륨 크기가 계속 차이가 난다던가 영상 도입 및 마감부에서 편집이 깔끔하지 못했던 부분들은 강의의 퀄리티 및 완성도 측면에서 조금은 아쉬운 부분인 것 같기도 합니다. 또한 이번 고급 강의처럼 기초/중급 레벨에도 강의 자료가 별도로 첨부되어 있었으면 각 레벨 별로 완강 이후 복습을 할 때 좀 더 효율적일 것 같습니다. 해당 개선점들에 대한 의견은 주관적인 부분이라 앞으로 강의 제작해주실 때 가볍게 참고해주셨으면 합니다. 좋은 강의 만들어주셔서 진심으로 감사드리고, 앞으로 새롭게 신설될 강의들도 기대하겠습니다!

    • 선종연님의 프로필 이미지
      선종연

      Reviews 6

      Average Rating 5.0

      5

      100% enrolled

      초보 실무자에게 매우 도움이 되는 강의였습니다.

      • 김선영님의 프로필 이미지
        김선영

        Reviews 5

        Average Rating 5.0

        5

        100% enrolled

        명강의 감사합니다~

        • jkblaxk님의 프로필 이미지
          jkblaxk

          Reviews 1

          Average Rating 5.0

          5

          100% enrolled

          좋은강의 잘듣고 갑니다. 감사합니다.

          • 데릭로님의 프로필 이미지
            데릭로

            Reviews 71

            Average Rating 5.0

            5

            100% enrolled

            기초반, 중급반 듣고 강의가 괜찮아서 고급반까지 듣네요. 강의가 좋습니다.

            • 윤선미
              Instructor

              로날루영님, SQL 시리즈 완주 중이시군요. 감사합니다!

          $42.90

          datarian's other courses

          Check out other courses by the instructor!

          Similar courses

          Explore other courses in the same field!