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

541 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

강의 내 로드맵

Over 8 years, online and offline, validated by 80,000 cumulative studentsthe best teaching quality
Janjaemi Coding’s intermediate-to-advanced SQL and practical data analysis

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

We distilled and restructured into an online course only the content that received the best feedback from students over years of data analysis bootcamps and in-person classes. Since most in-person students improved their skills enough to immediately take on real-world data projects, we confidently recommend this course to anyone who wants to build practical SQL skills.

Explanations of intermediate-to-advanced SQL syntax and
101 hands-on problems in
143 pagesof study materialstài liệu học tập

From SQL coding tests to
practical data analysis
job hunting and real-world workhandle it all perfectly

Easier and friendlier than anyone else!
More than 1,800 Inflearn
course reviews prove the quality of this course.
chứng minh năng lực giảng dạy

With 101 real-world problems,
you'll never be stumped by any SQL query

Are you familiar with SQL syntax but find it daunting to write practical queries right away? The way to upgrade your SQL skills—the fastest and most efficient—is to practice solving various problemsyourself. By following the curriculum, you will develop the ability to solve increasingly complex queries, from a single line to queries spanning dozens of lines, before you know it.. Nếu theo sát chương trình học, bạn sẽ dần có khả năng giải quyết không chỉ các truy vấn một dòng mà cả những truy vấn phức tạp dài hàng chục dòng.

Because the problems are based on data analysis topics you might be asked to handle in a real-world setting, if you can solve the problems in this course on your own, you will have the skills to handle both SQL coding tests and real-world SQL data analysis, as well as both.

Build your SQL skills with confidence 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 Steps with SQL and Databases (MySQL) Bootcamp>.

  • This course's problems are designed by combining the SQL fundamentals from the prerequisite course with the intermediate and advanced SQL syntax covered in this course.

Course Features ✨

#1.
A course based on well-organized materials


Become familiar with database utilization techniques in a short time
We provide a variety of code examples organized by level and technology and lectures based on well-organized materials

#2.
If you need to level up after learning the basics of SQL


Even with just basic SQL syntax, anyone can do it without difficulty!
Starting with a single-line query, you can write up to dozens of lines of real-world queries

We also provide a roadmap for those considering a career in data science/AI engineering. (See more)

What You'll Learn 📖

✅ SQL Functions, Subqueries, and Correlated Subqueries

Learn SQL functions for handling strings, dates/times, numbers, and more; subqueries that use one query within another; and correlated subqueries that execute based on the outer query.

✅ Various Intermediate-to-Advanced SQL

Learn how to efficiently manipulate multiple datasets, control transactions, optimize complex queries, apply conditional logic, and combine aggregate results into a single line.

✅ Advanced SQL Window Functions

Learn how to perform complex analyses such as ranking, cumulative distributions, and referencing past/future values with window functions, and how to apply detailed calculations by group.

✅ 101 Practical Problems

Develop your SQL coding test skills and practical data analysis abilities through hands-on problems. All 101 problems are covered in the course, and you can review them anytime using the separate answer sheet.

Detailed Learning Syntax

  • SQL functions (strings, dates/times, numbers, etc.)

  • Various intermediate-to-advanced subqueries and correlated subqueries

  • SQL set operations

  • Transactions and ROLLBACK/COMMIT

  • SQL VIEW

  • WITH clause (Common Table Expressions)

  • CASE WHEN and 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 person who created this course (Dave Lee from Fun Coding)

I designed this course because, after collaborating with data analysts and data engineers, I realized that the ability to write complex SQL is essential for performing effectively in the workplace. To help you develop that ability in a short period of time, the course focuses on practicing how to write complex queries and understanding intermediate to advanced SQL. I hope it helps you grow into a data analyst, data scientist, or data engineer with strong SQL skills.

  • Current CTO of Neumans & 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 Platform


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

Notes Before Taking the Course

Practice environment

  • We explain how to install the necessary programs (such as MySQL) on both Windows and Mac, so you can follow along on any PC.


Learn systematically
Dave Lee's roadmap from Fun Coding

Following this course, AI, development, data, and CS roadmaps that you can learn according to your goals giúp bạn học theo mục tiêu của mình.

IT technologies are interconnected.
By selectively learning connected technologies and adding AI to them, 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 and right to explore the CS courses and the full roadmap →

View the full computer science roadmap in detail

4. The Most Reliable Ultimate AI Utilization Roadmap (2026)

From Claude Code work 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 check out AI lectures and reference courses →

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

Learners

2,602

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

  • chayh10043898님의 프로필 이미지
    chayh10043898

    Reviews 7

    ∙

    Average Rating 5.0

    5

    32% enrolled

    Good

    • funcoding
      Instructor

      Thank you!

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

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

  • s1121238291님의 프로필 이미지
    s1121238291

    Reviews 97

    ∙

    Average Rating 4.9

    5

    100% enrolled

    It was very helpful.

    • 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

funcoding's other courses

Check out other courses by the instructor!

Similar courses

Explore other courses in the same field!

Limited time deal ends in 11:02:09

$53,900.00

30%

$59.40