Young-han Kim's Practical Database - Design Part 2, 9 Design Patterns You Must Encounter in Practice

"A query that ran perfectly during development suddenly slows down as data accumulates." At such times, the mark of a truly skilled developer is identifying the root cause based on solid evidence rather than guesswork, and optimizing a 30-second query down to 0.1 seconds. Master the core principles of database performance—from execution plans, indexes, and optimizers to joins and sorting—using millions of rows of real-world data. Elevate your skills and become a top-tier developer capable of independently analyzing and resolving slow queries in production environments.

Learn practical core Java object-oriented concepts easily via example code.

Learn Java generics and collection frameworks in depth with a focus on practical applications. Also learn the basics of data structures.

You will systematically learn database design through three stages—conceptual, logical, and physical—and strengthen your skills through a practical shopping mall project. Gain real-world know-how through modern design techniques and the latest trends.

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

This book provides an in-depth study of various intermediate-level Java features necessary for practical work, using example code.

Spring beginners can grasp core principles and solidify basics via examples.

Learn the core HTTP features essential for practical use and how to design proper HTTP APIs.

This is a Java course for those who are new to programming. You can easily learn Java by following along with the code.

Learn the essential modern Java technologies of Lambda, Stream, and functional programming with Java, from the basics to the practical level, in depth.

For those who are new to JPA or who use JPA in practice but lack basic theory, By learning the basic theory of JPA solidly, even beginners can confidently use JPA in practice.

This course provides an in-depth study of multithreading and concurrency, from basic principles to practical applications.

With a practical example, we will design and develop a web application using Spring Boot and JPA. Through this process, you will understand how to use Spring Boot and JPA in practice.

Learn I/O, networking, reflection, and annotations in depth, from the basics to the practical level. Build a web application server (WAS) directly in Java.

Beginners to Spring can quickly learn the entire Spring web application development process by creating examples.

Develop APIs using Spring Boot and JPA. And learn how to optimize JPA's extreme performance.

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

You can understand all the web technologies required for web application development from the basics and complete your learning. In MVC Part 2, you can learn all the practical application techniques needed for real-world web development, building upon the core principles and structures from MVC Part 1.

You will learn the core principles and advanced technologies of Spring in depth and be able to use Spring confidently.

This course will cover everything you need to know about Spring Boot for practical use.

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

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

Learn how to analyze 5 million records of Korean apartment transaction data using PostgreSQL. It covers the process of deriving meaningful insights through data cleaning, transformation, and various SQL queries.

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 a first-come, first-served coupon system, you will solve core real-world backend challenges such as concurrency issues, data integrity, and peak traffic handling. You will discover problems by writing code yourself and gain hands-on experience with essential industry skills like synchronous/asynchronous processing and queue management. This is a project-based course designed for junior developers and job seekers to build practical experience.

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

I have summarized the essential SQL SELECT statements and basic usage of Google Sheets that I learned while working as an analyst at a service company.

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.

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

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 🚀

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

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.

In the software system design course taught by Silicon Valley engineers, you will learn the design principles and architectural patterns of large-scale systems and how to build stable and scalable software solutions. In addition, you will cover performance optimization and fault response strategies through practical cases.

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

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

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.

A current database expert from a major global company generously shares 20 years of corporate practice and teaching experience!

This course provides a step-by-step learning path, ranging from the fundamental usage of MySQL to advanced techniques required in real-world production environments. It covers a wide range of topics, including data modeling techniques based on various case studies and practical data, evaluating the effectiveness of Foreign Key designs, analyzing Google Calendar schema DDL, and modern DDL design principles. Through this course, you will gain an in-depth understanding of how to utilize MySQL as a core system component rather than just a simple database.

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

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