Young-han Kim's Practical Database - Design Part 1, Complete Mastery of Modern Data Modeling

Solve the challenges you inevitably face in real-world design—such as common codes, category hierarchies, history tracking, soft deletes, statistics, dynamic design, and JSON utilization—with 9 core patterns. This is not just simple theory; it contains practical know-how and selection criteria for various scenarios, proven across numerous projects. Now, become a true design expert who can confidently handle any requirement that comes your way.

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.

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

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

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

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.

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

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

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

You can understand and master all the web technologies required to develop web applications from the basics. You can understand the core principles and structure of Spring MVC and grow into a more in-depth backend developer.

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

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

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.

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.

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

Solve everything from the basics of querydsl to practical use all at once!

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.

You can utilize and implement the database data access technologies required for backend development. You will understand the principles and structure of Spring DB access technologies and grow into a more in-depth backend developer.

Spring Data JPA goes beyond the limitations of the past and allows you to complete development with just an interface, without implementing classes in the repository, as if by magic. It also provides all the basic CRUD functions that have been developed repeatedly. We will share practical know-how on Spring Data JPA.

You can understand and perfect the basics of DB data access technology required for backend development. You can understand the principles and structure of Spring DB access technology and grow into a more in-depth backend developer.

Solve the challenges you inevitably face in real-world design—such as common codes, category hierarchies, history tracking, soft deletes, statistics, dynamic design, and JSON utilization—with 9 core patterns. This is not just simple theory; it contains practical know-how and selection criteria for various scenarios, proven across numerous projects. Now, become a true design expert who can confidently handle any requirement that comes your way.

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.

Learn how to model data in a distributed database environment.

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

We covered the concepts considered while migrating 20 billion data items managed through the existing MongoDB to MySQL.

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

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

This course is designed to help you learn the core functions of FastAPI, as well as the entire process of web service development. Through this course, we will help you become a FastAPI expert developer needed in the field.

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.

This course goes beyond simple CRUD-level database usage to help you acquire PostgreSQL skills necessary for the AI era from a practical perspective. Based on AI development experience in Silicon Valley, you will learn step-by-step how to design and utilize JSON, indexes, transactions, and even pgvector in real-world services, while mastering methods to solve complex data structures and performance issues.

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.

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.

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

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

Technology should also start with interest. I have prepared a story about a person who analyzes MBTI of his coworkers. I hope that those who have been daunted by SQL will start studying it with enjoyment.

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

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

This lecture comprehensively organizes the content that would be good for those who want to get a job as a new Spring Java backend developer, especially those who are about to have an interview.

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 🚀

A practical course on easily building a super simple bulletin board with Spring Boot and React.js! This course focuses less on theory and more on hands-on practice, covering the web application development process for quick completion.