SQL problem solving for data analysis (Advent of SQL 2024)

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.

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

Have you switched to GA4 but feel lost on how to use it? By learning three principles for effective data viewing and practical GA4 examples, you can immediately apply them to your work starting tomorrow!

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.

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

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.

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

If you were curious about what A/B testing is and how other companies experiment, attend this November 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!

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!

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!

How do IT startups make data-driven decisions? At the April seminar, you can hear examples from DataLean and Postype!

Are you having trouble persuading others with data? Learn how to present your data simply and powerfully using Google Sheets!

Have you ever seen an actual resume used by a data analyst when applying for jobs? Here are all the resume writing tips from analysts who successfully landed jobs as non-majors!

Don't miss out on Datarian's April seminar, packed with everything from profitable sales analysis to cohort analysis frameworks.

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 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 the data, but I don’t know how to look at it.” This is the most common concern for those starting on-chain analysis for the first time. In this course, a 10-year veteran data analyst and on-chain researcher fully reveals all the tools and interpretation techniques used in actual market analysis. ㆍWhich indicators react first before coin prices move ㆍWhether whales are accumulating or dumping ㆍHow to read market sentiment through bridge and stablecoin flows ㆍHow to extract data via Etherscan and Dune without programming ㆍAnd the interpretation patterns and strategies used by professional analysts This course is designed to help you go beyond "just looking" at on-chain data and build an analytical framework that leads to actual investment decisions.

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

Learn how to use the most commonly and importantly used advanced T-SQL queries in practice from a SQL Server expert consultant and Microsoft MVP, so you can write SQL in a more SQL-like way.

You will systematically learn database design through three stages—conceptual, logical, and physical—and strengthen your skills through a practical shopping mall project. Gain real-world know-how through modern design techniques and the latest trends.

SQLD Yellow Book 176 Problem-Solving Course for those who studied but can't solve problems. After completion, you'll go beyond passing to become an expert. SQLD All-in-One Pass!

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.

Not only developers, but also planners and data analysts learn databases step-by-step, starting from the basics of SQL.

"SQLD is an exam where past questions are not officially released." In preparation for the upcoming 61st exam (May 31, 2026)— Practical materials featuring 50 questions per subject and chapter, vividly reconstructed by directly recalling the latest 60th exam!

Let's understand data analysis tailored for advanced retail businesses and learn how to use the tools utilized in the industry!

This course aims to obtain the state-certified SQLD (SQL Developer) certification. An SQLD refers to a developer who can write accurate SQL to manipulate and extract data while developing application software based on knowledge of databases and data modeling.

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!