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.

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

A beginner's guide to SQL coding! We'll teach you the secrets of writing, interpreting, and validating SQL.

Let's edit and process the countless data generated through public services to build our own database, and discover another hidden world through a series of tasks that occur in the process and by utilizing SQL.

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.

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 current database expert from a major global company generously shares 20 years of corporate practice and teaching experience!

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

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

"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!

This course is structured to help even learners new to data architecture understand the material, progressing from basic data concepts → data structures and design → data modeling → databases → enterprise data architecture → AI data architecture → data architecture in practice and future strategies. In particular, it uses an online shopping company as a recurring case study to connect the foundational concepts covered in the course to real-world data design and AI applications.

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

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.

A demo takes a day; production is another matter. We’ll build a Text-to-SQL chatbot with local Claude Code, measure its accuracy against 50 questions with known answers, and show with real-world measurements how to protect a production database using guardrails, read-only accounts, privacy protections, and permissions.

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.

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!

Knowledge Graph-based RAG System Implemented with Neo4J: Next-Generation Search Technology Utilizing Data Relationships Beyond Simple Vector Search Maximizing RAG Performance with the Power of Graph Databases!

A Channel Talk interviewer will personally analyze the difference between unsuccessful and successful answers to the same questions, and prepare you for real interview follow-up questions.

"SQLD is an exam where past questions are not officially released." Preparing for the upcoming 60th exam (2026.3.7)— Practical study material featuring 50 vividly reconstructed questions by subject and chapter, based on the latest 59th exam!

You can solve design problems by writing code in a formatted way. You can understand code or patterns written by other programmers.