[A hundred words are not as good as seeing once] Intermediate SQL for data analysis

Datalian's SQL basics lecture with over 10,000 cumulative students and rich online/offline lecture experience. Learn SQL basics theory and solve 10 HackerRank problems together.

Datalian's SQL intermediate problem-solving lecture with over 10,000 cumulative students and rich online/offline lecture experience. We will solve several problems together to practice the SQL intermediate theory.

Datalian's advanced SQL problem-solving lecture with over 10,000 cumulative students and rich online/offline lecture experience. We will solve several problems together to practice advanced SQL content.

Datalian's advanced SQL lecture with over 10,000 cumulative students and rich online/offline lecture experience. Learn advanced SQL theory and solve practice problems together.

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 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.

In the cookie-less era, how will marketing change? If you don't know how to start marketing performance analysis, attend the November 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!

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!

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

Datalian's SQL practical lecture with over 10,000 cumulative students and rich online/offline lecture experience. How is SQL used in practice? Let's become a data analyst who solves problems using real data from Microsoft's Yammer service.

No need for developers! It doesn't matter if you don't know development. I'll show you how anyone can easily install GA4 with just a few clicks.

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!

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!

Datalian's advanced SQL lecture with over 10,000 cumulative students and rich online/offline lecture experience. Learn advanced SQL theory and solve practice problems together.

Datalian's SQL basics lecture with over 10,000 cumulative students and rich online/offline lecture experience. Learn SQL basics theory and solve 10 HackerRank problems together.

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.

'Complete Mastery of Practical SQL in 49 Sessions I - Basic Course' contains essential content that you must know for SQL. By learning using a practical database, you can apply it right away in the field, and it is structured so that you can fully learn the learning content through theoretical explanations, practice, and solving a total of 200 application problems. For intuitive understanding, practice is conducted using a database written in Korean.

Through this lecture, you can learn about understanding SQL and databases, SQL syntax, database design for practical application, database utilization through programming, and even data analysis application cases.

SQLD Yellow Book 176 Problem Solving Lecture for You Who Studied but Cannot Solve Problems. After Completing the Course, You Will Become an Expert Beyond Passing. SQLD All-in-One Pass!

From Java basics to advanced concepts, and Oracle SQL too, Backend web development series with hands-on practice, taught by star instructor Young Cody Kim who explains clearly for non-majors and coding beginners

SQLD, where should I start? This course is for you who feel so overwhelmed; you'll meet a changed you after completing it. SQLD All-in-One Pass!

This course teaches MS-SQL through baseball/company databases.

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.

From understanding SQL to using actual functions, Complete preparation for SQLD certification with the latest past exam questions!

This course is designed to help you learn the core functions of FastAPI, as well as the entire process of web service development. Through this course, we will help you become a FastAPI expert developer needed in the field.

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 course aims to acquire the state-authorized SQLD certification. SQLD refers to a developer who, based on database and data modeling knowledge, can write accurate SQL for manipulating and extracting data while developing application software.

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