Intermediate-to-Advanced SQL and Practical Data Analysis 101 Problem Solving

Master intermediate-to-advanced SQL and build solid SQL data analysis skills by solving 101 real-world data analysis problems together.

(5.0) 28 reviews

535 learners

Level Basic

Course period Unlimited

SQL
SQL
MySQL
MySQL
DBMS/RDBMS
DBMS/RDBMS
SQL
SQL
MySQL
MySQL
DBMS/RDBMS
DBMS/RDBMS

Reviews from Early Learners

5.0

5.0

염기탁

64% enrolled

I received a lot of help learning SQL for the first time. Highly recommended!!

5.0

둥절둥절

34% enrolled

This is a really useful lecture! After listening to the MySQL basic lecture by the fun coding instructor, I studied on my own because I was confused about some of the grammar while solving the Programmers SQL High Score Kit. However, since I only studied by problem, I had a limit to understanding the overall flow. While I was thinking about buying a book to study, the intermediate and advanced query lectures were updated, so I quickly paid and took the course. This lecture systematically explains how to write queries necessary for practical work, and it is well organized so that I can review them with real-life problems and practice problems. I feel like my skills are being upgraded one step at a time every time I listen to the lecture. During the basic grammar lecture, the practice problems were easy, so the instructor's and my answers were almost the same, but as I solved the advanced problems, I felt that my own query style and thinking were developing. It was surprising that the answers were the same even though the queries written by the instructor and I were different, and I realized that there are really various ways to write queries. I am learning together by matching the answers and asking ChatGPT to modify the queries to be more optimized. I think this part is also necessary in practical work, so I am practicing it while solving the problems! This lecture is a great lecture that allows you to learn in depth the queries required for data science or data analysis! I think it is a lecture that can be useful for those preparing for query tests. Thank you for the great lecture!

5.0

박민주

100% enrolled

I had been neglecting SQL, but this lecture helped me study it again. I didn't understand everything from the beginning, but I'll keep reviewing and make it my own. Thank you for the great lecture.

What you will gain after the course

  • Intermediate-to-advanced SQL (subqueries, transaction control, WITH clauses, window functions, etc.)

  • Develop practical SQL query composition skills through 101 diverse problems

강의 내 로드맵

The best teaching
Intermediate-to-advanced SQL and practical data analysis from Fun Coding
, validated by 80,000 cumulative students over 8 years of online and offline courses

Build your practical SQL skills
This one course is all you need 💪

We have distilled and reconstructed as an online course only the content that received the best feedback from students over years of data analysis boot camps and offline classes. Since most students who took the existing offline course upgraded their skills enough to immediately carry out real-world data projects as data professionals, we confidently recommend this course to anyone who wants to build practical SQL skills.

Intermediate-to-advanced SQL syntax explanations and
101 hands-on problems, along with
143 pages of study materials

From SQL coding tests
to real-world data analysis
job hunting and practical work, be fully prepared for both

Easier and friendlier than anyone else!
More than 1,800 Inflearn
student reviews prove the instructor's teaching ability

With 101 real-world problems,
you’ll never be intimidated by any SQL

Do you know SQL syntax but still feel at a loss when trying to write the queries you need for real-world work? The fastest and most efficient way to improve your SQL skills is to solve a variety of problems. By following the curriculum step by step, you can develop the skills to solve increasingly complex, lengthy queries—eventually even those spanning dozens of lines, rather than just single-line queries.

Because the problems are based on data analysis topics you are likely to encounter in real-world work, if you can solve the problems covered in this course on your own, you will develop the skills needed for both SQL coding tests and real-world SQL data analysis,.

Let's build solid SQL skills so you can write any SQL query you want without buffering!

Notes Before Enrolling 📢

  • This course does not cover basic SQL syntax. For those who want to build their fundamentals from the ground up, we recommend <First-Time SQL and Database (MySQL) Bootcamp>.

  • The problems covered in this course combine the basic SQL syntax learned in the prerequisite course with the intermediate-to-advanced SQL syntax taught in this course.

Course Features

#1.
A course based on well-organized materials


To help you become familiar with database utilization techniques in a short time,
we provide a variety of code examples by level and technology and lectures based on well-organized materials

#2.
If you need to level up after learning basic SQL syntax


If you only know basic SQL syntax, you can master it without difficulty!
Starting with a single line of query, you will ultimately be able to write practical queries spanning dozens of lines.

We present a systematic roadmap for those considering a career in data science or AI engineering. (View it here)

What You'll Learn 📖

✅ SQL functions, subqueries, and correlated subqueries

Learn about SQL functions for handling strings, dates/times, and numbers; subqueries, which involve writing one query within another; and correlated subqueries, in which the subquery depends on the outer query to execute.

✅ Various intermediate-to-advanced SQL

Learn how to efficiently manipulate multiple sets of data using SQL, control transactions, optimize complex queries, handle conditional logic, and combine aggregated results into a single row.

✅ Advanced SQL Window Functions

Learn how to use SQL window functions to perform complex analytical tasks, such as calculating data rankings and cumulative distributions, referencing past and future values, and applying detailed calculations by data group.

✅ 101 Practical Problems

You can build your SQL coding test and practical data analysis skills through a variety of hands-on problems. All 101 problems are covered in the course, and you can review them anytime using the separately provided answer sheet.

Detailed Learning Syntax

  • SQL functions (strings, date/time, numbers, etc.)

  • Various intermediate-to-advanced subqueries and correlated subqueries

  • SQL set commands

  • Transactions and ROLLBACK/COMMIT

  • SQL VIEW

  • WITH clause (Common Table Expressions)

  • CASE WHEN, GROUP_CONCAT Clauses

  • Window functions (RANK, DENSE_RANK, ROW_NUMBER)

  • Window functions (PARTITION BY, ORDER BY, ROWS/RANGE)

  • Window functions (LEAD, LAG, FIRST_VALUE, LAST_VALUE)

  • Window functions (PERCENT_RANK, CUME_DIST, NTILE)

The creator of this course (Dave Lee from Fun Coding)

This course was designed based on experience gained through collaboration with data analysts and data engineers, with the belief that the ability to write complex SQL is essential for performing your role in the field. To improve this ability in a short period of time, the course focuses on practicing writing complex SQL queries and understanding intermediate-to-advanced SQL. We hope this course will help you quickly develop practical SQL skills and grow into a data analyst, data scientist, or data engineer with solid SQL expertise.

  • Current CTO of Noimans&Turings

  • Former Principal Product Manager/Principal Development Manager at Coupang,

    Samsung Electronics Development Manager


  • Education: Korea University, Japanese Language and Literature / Yonsei University, Master’s in Computer Engineering


  • Key Development/Planning Experience: E-commerce, Samsung Pay, Mobile Platforms


  • Books: *Flask & FastAPI for the Fastest Full-Stack Development*, *Linux Kernel Programming*, *Understanding and Developing Linux Operating Systems*, *Core IT Technologies Anyone Can Quickly Read and Fully Understand*, *An Introduction to Python Programming for Complete Beginners*

Notes Before Taking the Course

Practice environment

  • We will explain how to install the programs needed for the course (such as MySQL) on both Windows and Mac, so you should have no trouble following along on either a Windows or Mac PC.


Learn systematically
Dave Lee’s roadmap from Fun Coding

Following this course, AI · Development · Data · CS roadmaps you can learn according to your goals

IT technologies are interconnected.
By selectively learning connected technologies and adding AI to the mix, you can reach your goals much faster.

Every roadmap covers how to connect and use technologies together,
is designed to increase in difficulty from the beginner level to the expert level, and
is continuously updated over the years.

It is also available at a greater discount than when taking the courses individually.

3. Fundamentals of development and data, and core computer science (CS) knowledge

From computer architecture, operating systems, networks, system software, software engineering, and architecture to data structures and algorithms

← Swipe left or right to check out the CS courses and the full roadmap →

View the full computer science roadmap in detail

4. The Most Reliable and Powerful AI Utilization Roadmap (2026)

From Claude Code business automation to vibe coding, Codex, OpenClaw, Claude Code–based data analysis, advanced Claude Code techniques such as agentic, harness, and loop engineering, and even AI agent development

← Swipe left and right to explore AI courses and reference materials →

View the Most Reliable Ultimate AI Utilization Roadmap (2026) in Detail

Recommended for
these people

Who is this course right for?

  • Those who want to learn practical SQL data analysis

  • Those who want to build strong SQL skills

  • Those who want to solve a variety of problems for SQL coding tests

  • Those who want to thoroughly organize their SQL skills for advanced development

Need to know before starting?

  • MySQL and Database Bootcamp (SQL and Database Basics)

Hello
This is funcoding

Inflearn Verified

Career Verified

34,485

Learners

2,592

Reviews

1,952

Answers

4.9

Rating

13

Courses

Janjemi Coding, Dave Lee

  • About Janjaemi Coding Introduction Blog [Click]

  • Key Experience: Coupang Senior Development Manager/Principal Product Manager, Samsung Electronics Development Manager (Approx. 15 years of experience)

  • Education: BA in Japanese Language and Literature, Korea University / MS in Computer Science, Yonsei University (A complete mix)

  • Key Development Experience: Samsung Pay, E-commerce Search Service, RTOS Compiler, Linux Kernel Patch for NAS

  • Books: Linux Kernel Programming, Understanding and Developing the Linux Operating System, IT Core Technologies That Anyone Can Easily Read and Understand, Python Programming Primer for Absolute Beginners

  • Operating Site: Fun-Coding (http://www.fun-coding.org) [Click]

  • This is a site that shares free materials related to full-stack development, data science, and AI.

  • Others: Fun-Coding YouTube Channel [Click]

    • I am starting little by little to share tips and short free lectures that are helpful for IT learning~

While working in the industry, I have been consistently creating solid full-stack, data science, and AI courses for 8 years.

 

More

Curriculum

All

44 lectures ∙ (9hr 8min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

28 reviews

5.0

28 reviews

  • doong님의 프로필 이미지
    doong

    Reviews 4

    Average Rating 5.0

    5

    34% enrolled

    This is a really useful lecture! After listening to the MySQL basic lecture by the fun coding instructor, I studied on my own because I was confused about some of the grammar while solving the Programmers SQL High Score Kit. However, since I only studied by problem, I had a limit to understanding the overall flow. While I was thinking about buying a book to study, the intermediate and advanced query lectures were updated, so I quickly paid and took the course. This lecture systematically explains how to write queries necessary for practical work, and it is well organized so that I can review them with real-life problems and practice problems. I feel like my skills are being upgraded one step at a time every time I listen to the lecture. During the basic grammar lecture, the practice problems were easy, so the instructor's and my answers were almost the same, but as I solved the advanced problems, I felt that my own query style and thinking were developing. It was surprising that the answers were the same even though the queries written by the instructor and I were different, and I realized that there are really various ways to write queries. I am learning together by matching the answers and asking ChatGPT to modify the queries to be more optimized. I think this part is also necessary in practical work, so I am practicing it while solving the problems! This lecture is a great lecture that allows you to learn in depth the queries required for data science or data analysis! I think it is a lecture that can be useful for those preparing for query tests. Thank you for the great lecture!

    • funcoding
      Instructor

      Thank you so much for your valuable review!! 🥰

    • I also wrote a question about learning, so thank you for leaving a reply!

  • zamon님의 프로필 이미지
    zamon

    Reviews 13

    Average Rating 4.6

    5

    100% enrolled

    I could definitely feel my skills improving as I wrote various queries.

    • funcoding
      Instructor

      Thank you!!

  • mjpark0930님의 프로필 이미지
    mjpark0930

    Reviews 3

    Average Rating 4.7

    5

    100% enrolled

    I had been neglecting SQL, but this lecture helped me study it again. I didn't understand everything from the beginning, but I'll keep reviewing and make it my own. Thank you for the great lecture.

    • funcoding
      Instructor

      If you repeat it several times, it will be effective! Thank you

  • chayh10043898님의 프로필 이미지
    chayh10043898

    Reviews 7

    Average Rating 5.0

    5

    32% enrolled

    Good

    • funcoding
      Instructor

      Thank you!

  • s1121238291님의 프로필 이미지
    s1121238291

    Reviews 94

    Average Rating 4.9

    5

    100% enrolled

    It was very helpful.

    • funcoding
      Instructor

      Thank you!

funcoding's other courses

Check out other courses by the instructor!

Similar courses

Explore other courses in the same field!