Kim Young-han's Practical Database - Performance Optimization, Complete Mastery of Execution Plans and Indexes

You can learn how to solve concurrency problems, how to tune procedures, and how to speed up query execution. You can also learn various know-hows such as common mistakes and problems that occur in practice. (The only refactoring lecture in the world)

Introduction to SQL Data Analysis! Quick and easy to understand with practical problem solving!

Secrets of people who are good at their jobs! How should I start with SQL? It covers everything from SQL installation and basic environment configuration to simple practical exercises that can be used in real life! You can also learn basic commands step by step through practical exercises.

SQL data analysis! We will teach you how to solve practical problems that are applicable in the field, quickly and easily!

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

In this lecture, we aim to create a Web Scraping API server using the Naver Shopping site. We will show you how to configure a managed API server by connecting MySQL and configuring a 3-tier architecture!!

We will learn how to create a system to support large amounts of data and traffic by creating it directly with Spring Boot.

A guide to the exam for nationally recognized SQL qualifications! Establish a comprehensive knowledge system related to SQL.

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

In this course, we will practice step-by-step how to use React and FastAPI to implement social features such as real-time voting, comments, and likes, as well as how to monetize by integrating payment systems (Kakao Pay, Toss Pay, etc.).

How can you withstand skyrocketing traffic? Learn how to build a resilient and flexibly scalable architecture through practical design patterns based on EDA (Event-Driven Architecture) using Kafka, Spring, CDC, and Temporal. Explained clearly and simply—even for non-majors—alongside the real-world experience of a Kakao developer. A hands-on course covering everything from real-time data flows and event processing to microservice integration!

This course goes beyond basic CRUD-level database usage, helping you develop the PostgreSQL skills needed in the AI era from a practical, real-world perspective. Drawing on AI development experience in Silicon Valley, you’ll gradually learn how to design and use JSON, indexes, transactions, and pgvector in actual services, while gaining the skills to solve complex data structure and performance problems.

From the fundamentals of MySQL usage to the advanced techniques required in real-world service environments, you will learn progressively. The course also covers a wide range of topics, including data modeling techniques based on various cases and practical data, evaluating the effectiveness of Foreign Key design, analyzing the Google Calendar schema DDL, and modern DDL design principles. It provides an in-depth understanding of how to use MySQL as a core component of a system, rather than merely as a database.

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 🚀

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

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.

We enable you to fundamentally understand and resolve issues where Hangeul appears broken on web pages or in databases, or files contain unknown characters.

This course is designed for those who are new to Debezium-based CDC and unsure where to begin. You will gain hands-on experience with the entire process of collecting MySQL change data in real time via Kafka and delivering it to PostgreSQL. By learning everything from the basic principles of CDC to configuration and operational best practices, you will be able to build real-time data pipelines on your own.

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.

If you can master DB and programming, you should be more than halfway prepared for the information processing engineer exam. Let's take a look at the DB and programming parts, which are worth 45 to 55 points in the practical exam, and pass the written exam steadily.