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.

This is a practical backend course designed to cultivate the service planning and design thinking skills that developers need in the AI era.

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

Starting from installing MariaDB and understanding its structure, you will learn step-by-step from writing SQL queries and utilizing functions to joins and subqueries. You will master core practical features such as table design, performance management, backup, and recovery through hands-on practice, completing the practical skills necessary for database development and operation.

A must-have subject for aspiring developers and those looking to get a job in big data!!

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

I'll show you everything about how to build servers for stateful services and how zero-downtime deployment works.

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.

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 common components of global-scale services through popular papers, books, and articles.

This course will solidify the basics of SQL through various problems that can be encountered in the actual IT industry. Solve the problem-solving quests, take the first step toward data analysis, and strengthen your SQL skills that can be applied in real life!

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

"SQLD is an exam where past questions are not released." In preparation for the upcoming 62nd exam (2026.08.22)- Practical materials featuring 50 questions per subject and chapter, vividly reconstructed by directly recalling the latest 61st exam!

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 🚀

SQLD, where should I start? For those of you feeling completely overwhelmed, this is the lecture for you. You will meet a transformed version of yourself after completing the course. SQLD All-in-One Pass!

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.

This is a full-stack restaurant map tutorial that allows you to learn everything from front-end, back-end, Kakao Map API usage, and deployment all at once while creating a restaurant map of your favorite YouTuber.

This course focuses more on data modeling through entity design than on JPA technical explanations. Based on the principle that solid DB design is the foundation of application development, we analyze various design patterns—such as one-to-many, many-to-many, inheritance, and collections—alongside business scenarios. You will learn by directly observing the process of code being transformed into actual tables on screen. To ensure immediate practical application, we provide business use cases, source code, and test codes for each design pattern.

How does the architecture change when an LLM is integrated into an existing backend? This is an introductory system design course that goes beyond simple LLM API calls to help you understand core AI service components such as Model Routers, LLM Gateways, and Vector DBs, and step-by-step design an operational AI service architecture including RAG and AI Agents. It is designed to help those who want to create their own LLM-based AI services quickly master the design workflow.