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

Inflearn cumulative students over 30,000, Datarian's SQL basics course with rich online/offline teaching experience. Learn SQL basic theory and solve 10 SQL problems together.

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

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.

How can data be used in content marketing? At this May seminar, you can hear case studies from data analysts on using data from company blogs and newsletters!

If you are curious about the various possibilities and future prospects of generative AI, including ChatGPT and Clova X, that can be used for data analysis, come to our seminar this May!

Solve 25 SQL problems of varying difficulty levels. This is a commentary lecture for Advent of SQL 2025, and upon completing the course, you can finish the advent calendar and earn a badge.

I have worked at seven different small startups that had neither data analysts nor user researchers, and I've stumbled through various trials and errors. I will share the many realistic challenges a UX designer can face, along with the deep insights I gained while navigating through those difficulties.

No developers needed! No coding knowledge required. I'll show you how anyone can easily install GA4 with just a few clicks.

Solve 25 SQL problems of various difficulty levels. This is the Advent of SQL 2024 explanation lecture. Upon finishing the lecture, you can complete the Advent calendar and obtain a badge.

We will reveal the actual data analysis portfolio of successful job seekers and the portfolio-related questions they received during interviews!

If you are thinking about using data in your work, get some great tips from this seminar.

Did you know that there are different types of data analysts? If you want to know everything about in-house data analysts and consulting data analysts, come to this seminar!

Practitioners who are curious about how other companies conduct funnel analysis, gather here! Meet the case of the global No. 1 alarm app, ‘Alarmy’, with 75 million cumulative downloads.

Are you worried about whether you can become a data analyst as a non-major? Hear from a non-major senior analyst!

If you are worried about where to start and where to start studying because you need to take a SQL coding test to become a data analyst, then come to this seminar!

In the cookie-less era, how will marketing change? If you don't know how to start marketing performance analysis, attend the November seminar.

How can performance be measured in offline advertising? From how to measure the performance of elevator TV ads, to the commonalities and differences in data observed in online/offline marketing! Hear about it at this October seminar!

Data analyst job prep: Lost on where to begin? Get hints at this September seminar!

How can data be leveraged in side projects? Hear the stories of 'Geumim' and 'Skull' at this seminar!

If you are preparing for a data analyst job or career change and were curious about hearing from someone in the field, ask a data analyst anything!

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

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.

Inflearn cumulative students over 30,000, Datarian's SQL basics course with rich online/offline teaching experience. Learn SQL basic theory and solve 10 SQL problems together.

Easy explanations and examples are provided so that you can apply them directly to your work.

Through a hands-on curriculum using MariaDB and HeidiSQL, you can learn the core concepts of SQL and how to use it in practice while collecting, preprocessing, and analyzing data.

From Java basics to advanced levels and Oracle SQL, this is a backend web development series where you learn through hands-on practice with star instructor Young-Cody Kim, who makes coding easy to understand even for non-majors and beginners.

Make the most of relational database systems!

This is a guide course for beginners who are taking their first steps into Oracle. We will teach you the basics of user creation, table creation, and queries.

By implementing various practical data analysis cases using SQL, you can simultaneously improve your data analysis and SQL utilization skills.

This course is a master class that systematically covers the fundamental principles and practical applications of MongoDB. Starting with core MongoDB concepts, you will systematically learn essential topics for practical work, such as database design, CRUD operations, indexing, aggregation pipelines, performance optimization, transactions, and security. It explains topics step-by-step so even beginners can understand, and you can deeply learn the working principles of MongoDB through exercises and examples. This is the best introductory and practical course for developers who want to build strong MongoDB skills for practical work.

This is a course for learning MS-SQL through baseball and corporate databases.

Learn how modern data teams leverage dbt. Build maintainable analytics models and validated data pipelines hands-on. Master core concepts of analytics engineering with a practical focus. This course is for those who want to take their data career to the next level 🚀

Perfect preparation for the SQLD certification, from understanding SQL to practical function application, finishing with the latest exam questions!

For those feeling overwhelmed by SQLD exam preparation, this is a standard course that analyzes the entire scope of the "Yellow Book," organizes the necessary theories through practice-oriented lessons, and solves every single problem. With short, concise clips and a topic-based structure, you can build the practical skills needed to succeed on the actual exam.

This is a special lecture that can lay the theoretical foundation to simultaneously prepare for the Microsoft AZ-900 certification, and as the latest content reflecting the scope of questions as of May 2025, by providing content related to core data concepts, Azure's relational data, Azure's non-relational data, and Azure's analytical workloads in a form combining theory and practice, it can be utilized as a meaningful educational opportunity to not only obtain the certification but also take the first step towards becoming a data professional.

This is a course aimed at obtaining the nationally recognized SQLD certification, and SQLD refers to developers who can write accurate SQL for manipulating and extracting data while developing application software based on database and data modeling knowledge.

SQLD, where do I even start? This course is for those who feel completely lost - you'll meet a transformed version of yourself after completing it. SQLD All-in-One Pass!

Let's understand data analysis suitable for advanced retail business and learn how to utilize tools utilized in the industry!