Kim Young-han’s Practical Database – Design Part 2: 9 Design Patterns You’ll Definitely Encounter in Real-World Practice

Learn database design systematically across three levels—conceptual, logical, and physical—and strengthen your skills through a practical, project-based e-commerce store. Gain hands-on expertise through modern design techniques and the latest trends.

Learn the essential fundamentals of SQL and databases needed for practical work. Not only developers, but also planners and data analysts will learn SQL in depth.

For learners struggling with large-scale data analysis and slow queries, I provide practical, hands-on guidance from design through tuning.

Through the implementation of a first-come, first-served coupon system, you will solve key real-world backend challenges such as concurrency issues, data consistency, and handling peak traffic. By writing the code yourself, you will identify problems and master essential practical skills, including synchronous/asynchronous processing and queue management. This project-based course is designed to help junior developers and job seekers gain hands-on experience.

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

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

"I have a backend technical interview in a week. What should I start with?" The secret to answers that make interviewers nod Master the actual answer patterns of successful applicants to Naver, Kakao, Coupang, and Toss in just 3 days!

This course covers how to set up multi-module projects from scratch using Kotlin and Spring Boot. It proceeds with a hands-on approach, covering everything from the basic concepts of modularization to Gradle configuration, managing dependencies between modules, and actual application development. If you are a beginner or intermediate developer looking to learn the fundamentals and practical application of multi-modules, please refer to this course.

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 🚀

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

This course teaches you how to build a practical Unity game with a database. It covers difficult-to-access topics in an easy-to-follow lecture format.

Learn the SAGA transaction management technique for maintaining data consistency in distributed environments through a hands-on approach. You will configure three microservices using Spring Boot and Docker, and implement both Orchestration and Choreography patterns using Kafka and MySQL. Through this course, you will master core concepts applicable to real-world scenarios, including the operational principles of distributed transactions, designing compensating transactions, and handling fault recovery.

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.

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

Learn common components of global-scale services through popular papers, books, and articles.

Does game backend development feel daunting and vague? With know-how gained from firsthand experience with numerous projects, I will show you how to perfectly integrate complex Firebase features into actual games. We will connect Firebase to a Unity 6 Watermelon Game to implement online features such as login, cloud database (Firestore) save/load, rankings, bulletin boards, and mailboxes. This is a practical course that also covers security rules, Remote Config operations, and code design based on a layered architecture (UI, logic, and data access).

Channel Talk interviewers will directly analyze the difference between failing and passing answers to the same questions, and help you prepare for actual follow-up questions.

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.

Beyond the basics of API design, CRUD implementation, and JWT authentication, all the way to backend architecture design! This is an introductory system design course to help you create 'your own backend architecture' so you can confidently discuss design experience in interviews.