[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.
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
[Practice Makes Perfect] → Hands-on learning approach (solving a total of 25 problems)
For Data Analysis" → A curriculum focused on SQL features essential for data analysis
"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
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!