[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) 337 reviews

3,533 learners

Level Intermediate

Course period Unlimited

SQL
SQL
SQL
SQL

Reviews from Early Learners

4.8

5.0

세바스찬 주니어 3세

97% enrolled

I am currently using SQL in my workplace, and I have watched all the lectures from beginner to advanced to reorganize the concepts. First of all, the lecture content itself is very informative and helpful in many ways. However, the volume size of each lecture video keeps changing, and the editing in the introduction and ending of the video is not neat, so it seems a bit disappointing in terms of the quality and completeness of the lecture. Also, if the lecture materials were attached separately for the beginner/intermediate levels like this advanced lecture, it would have been more efficient to review after completing each level. The opinions on these areas for improvement are subjective, so please refer to them when creating future lectures. I sincerely thank you for creating such a good lecture, and I look forward to the new lectures that will be created in the future!

5.0

선종연

100% enrolled

This was a very helpful lecture for beginners.

5.0

김선영

100% enrolled

Thank you for the great lecture~

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 datarian

24,107

Learners

2,796

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

Co-instructor

Curriculum

All

46 lectures ∙ (4hr 33min)

Published: 
Last updated: 

Reviews

All

337 reviews

4.8

337 reviews

  • coolk14431님의 프로필 이미지
    coolk14431

    Reviews 5

    Average Rating 5.0

    5

    100% enrolled

    Thank you for the great lecture~

    • wonseok님의 프로필 이미지
      wonseok

      Reviews 15

      Average Rating 4.7

      5

      97% enrolled

      I am currently using SQL in my workplace, and I have watched all the lectures from beginner to advanced to reorganize the concepts. First of all, the lecture content itself is very informative and helpful in many ways. However, the volume size of each lecture video keeps changing, and the editing in the introduction and ending of the video is not neat, so it seems a bit disappointing in terms of the quality and completeness of the lecture. Also, if the lecture materials were attached separately for the beginner/intermediate levels like this advanced lecture, it would have been more efficient to review after completing each level. The opinions on these areas for improvement are subjective, so please refer to them when creating future lectures. I sincerely thank you for creating such a good lecture, and I look forward to the new lectures that will be created in the future!

      • sunjongyun1234359님의 프로필 이미지
        sunjongyun1234359

        Reviews 6

        Average Rating 5.0

        5

        100% enrolled

        This was a very helpful lecture for beginners.

        • dlgpdnjs3280859님의 프로필 이미지
          dlgpdnjs3280859

          Reviews 1

          Average Rating 2.0

          2

          48% enrolled

          This is not a lecture that I recommend. There are often parts where you get stuck while solving a problem, so I think you should prepare thoroughly in advance for these parts. Also, the explanations are not very detailed, so sometimes you have to look it up and understand it on your own.

          • sunmiyoon
            Instructor

            Dear Summer, I will try to reflect your feedback in improving my future lectures. Thank you for your feedback.

        • augustman88081016님의 프로필 이미지
          augustman88081016

          Reviews 11

          Average Rating 4.6

          1

          9% enrolled

          I am writing this again because the course review was made private. 1. The instructor's teaching skills are the worst. 2. I paid in advance during the discount period to follow the previous curriculum, but there was a period. Since there was no proper notice in advance, I could not attend the lecture and the period expired. Because of this, I could not follow the previous curriculum and listen to it properly. 3. Because of this, I requested the instructor to refund or extend the lecture because the instructor's previous curriculum that I had applied for through the Infraon customer center was not sufficiently notified in advance about the lecture period, but I was ignored because they said something that did not sound fair. 4. So I wrote a course review that included these complaints, but you made it private because you gave me 1 point. I hope you do not manage your ratings like this. Other students should know this too ^^ 5. The money is good, but please have a conscience. I think I did a good deed, and since you said I can't get a refund or extend it, I don't expect that, but please don't make the course review private. And I think it is problematic that you are arbitrarily making my course review private without my permission. If you make it private again, I will contact Inflearn Customer Center and protest. 6. Finally, I would like to add. If you truly consider yourself an instructor, you should be considerate so that people like me who purchased the course in advance during the discount period and ended the course without even taking it can take the course because there was not enough advance notice. If you are doing this because you want money, I have nothing to say, but if you consider yourself an instructor, please think about it from the perspective of a student. Are you kidding me by asking me to pay for a course I haven't even heard of? 7. As I write, I am writing again. I am adding this in case you think I should have looked into it carefully in advance. When I paid, Inflearn UI did not specify the course period on the payment page, so it was difficult for students to know the period. All there was was a small note on the right side of the course application saying "2 months, 3 months". And as the instructor knows, some of his lectures are unlimited and some have a course period, so I thought they were all unlimited and bought them when they were on sale. And I tried to listen to them when I had time, but some of them had already expired. You may not know this context, so I'm adding more information here. You asked me to pay to listen to them again, but I can't do that even if I die. That's why I gave this course review and a 1-star rating. I don't even want to call you an instructor. Some of the lectures you registered for had a course period, and I applied for all the lectures in the curriculum when the discount was applied, but the period wasn't clearly notified, so they expired and I couldn't take the lectures in the curriculum I had applied for before. Because of this, I asked you to refund or extend the course, but you refused without considering the student's position at all, and because of this, I couldn't take the course smoothly, so I gave you a 1-star rating. Don't make this course review private. There are people like me who don't know that some lectures have a deadline, so please don't make it private and stop only revealing your 5-star course reviews according to your own taste. If you have even a modicum of conscience.

          datarian's other courses

          Check out other courses by the instructor!

          Similar courses

          Explore other courses in the same field!