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

Hello. I'm Young-han Kim.

We are introducing the Younghan Kim's Backend Master Pass, which many of you have requested for a long time, for a limited period.

Link: https://inf.run/LR9Sp

A 7-year journey, and its completion

It has already been 7 years since I started my first lecture. During that time, I have created a total of 26 lectures and received overwhelming support with a cumulative total of 590,000 students.

When I first started teaching, I made a promise to myself. Thinking of the countless new, junior, and senior developers I met in the field, I vowed to create "real-world development courses that truly enable growth." My goal was to deliver every practical skill needed to grow from a newcomer to a junior, and from a junior to a senior—and it has finally been completed after 7 years.

Pass Product Composition — Integration of 4 Core Roadmaps

This Master Pass is a 'lifelong roadmap' that accompanies a developer's entire career cycle, from the basics of their junior days to the performance optimization challenges they must face as a senior.

• Young-han Kim's Practical Java Roadmap

• Young-han Kim's Spring Complete Mastery Roadmap

• Young-han Kim's Roadmap for Mastering Spring Boot and JPA in Practice

• Young-han Kim's Practical Database Roadmap

Includes new lecture to be released in July

In addition to this, the 「Young-han Kim's Practical Database - Performance Optimization」 course, scheduled for release in July, will be provided. (Expected price: 154,000 KRW)

This is the course I am putting the most effort into creating. This is because 80% of practical system failures stem from database performance issues. As a service grows and begins to handle large-scale traffic, no matter how cleanly you write your backend application code, the final bottleneck will eventually explode at the database level.

After mastering this course, you will possess the 'true senior's' perspective to accurately pinpoint bottlenecks without panicking, even in the face of failures or slow queries.

A reward for existing students

I have prepared some benefits for those who have trusted and followed me for a long time.

- Existing Course Purchasers: A higher discount rate will be applied to the remaining courses based on the number of courses (amount) already owned.

- Purchasers of all courses (Super Fans): Master Pass provided as a gift (free)

As a special thank you to my true fans who have trusted and followed all of my lectures so far, I am giving the 'Pass Product' and the 'Practical Database Performance Optimization' lecture, which will be released in July, as a gift. (Please make sure to select the 0 won purchase for the Pass Product!)

The AI Era: Why Fundamentals Matter

An era where AI writes code for us. Has the gap between skilled and unskilled developers narrowed? In the field, the opposite result is actually occurring.

AI is not a tool to replace a developer's ability, but a tool to amplify it.

Skilled developers can ask AI the right questions and determine whether the code generated by AI is high-quality or dangerous. They can quickly identify if the design is flawed, if there are hidden performance issues, or if it could lead to failures in a production environment.

Conversely, if you lack the fundamentals, it is difficult to verify the results generated by AI. Even if it appears to work on the surface, the design might be flawed, database performance issues could be hidden, or problems could erupt in the production environment.

AI technology will continue to change rapidly. However, there are things that do not change.

• The basic principles of object-oriented programming

• The eye to distinguish between good code and bad code

• The operating principles of HTTP and the web

• Transactions and Data Access Technologies

• Database design and performance optimization

   

These fundamentals become even more important in the AI era. This is because you need to know to ask questions, you need to know to verify, and you need to know to make improvements.

This Backend Master Pass contains those very unchanging essentials.

Continuous lecture renewals, at no additional cost

Going forward, existing lectures will also be continuously renewed. Depending on the need, we will proceed with full video renewals, partial video renewals, manual version updates, and more.

Those who purchase the Master Pass now will receive free updates without any additional cost, even if the price of the renewed lectures increases later. This is my minimum courtesy and promise to those who have trusted and chosen me. I plan to begin full-scale renewal work after the release of the Practical Database Performance Optimization lecture.

Lastly

This pass is not simply a product for selling knowledge. It is the culmination of seven years of effort, created to pass on to you everything I have learned, experienced, and fiercely contemplated in the field for over a decade.

Until the day you grow from a newcomer to a junior, from a junior to a senior, and finally become a developer whom your colleagues sincerely want to work with—I will be by your side as a reliable guide.

Thank you.

Hello everyone
The Database Design Part 1 course has finally opened.

To celebrate the opening, I'm offering 30% off all my courses 🙂

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

• Number of lectures: 83

• Lecture Duration: 16 hours 11 minutes

• Lecture PDF materials: approximately 400 pages

Link: https://inf.run/SEdxb

[Course Introduction]

Databases are the foundation of all applications.
However, if not designed properly, projects quickly hit their limits, and maintenance becomes hell.

This course doesn't simply teach you how to create tables, but systematically shows you modern database design methods that work in real-world practice. And I've packed this course with the results of my extensive hands-on experience and long deliberation.

[Key Lecture Points]

Conceptual → Logical → Physical Modeling
Master DB design completely with a 3-step approach.

Design know-how you can use immediately in practice
We don't just stay in theory, but use a shopping mall project as an example.

Avoiding the Pitfalls of Poor Design
Through hands-on practice, you'll understand why ERDs are important, why normalization is necessary, and when denormalization should be applied.

The Essence of Key and Relationship Design
We cover natural keys vs surrogate keys, one-to-one, one-to-many, and many-to-many relationships, and identifying vs non-identifying relationships in depth.

Reflecting the Latest DB Design Trends
We don't stay stuck in textbooks from decades ago, but present modern data modeling methodologies.

[What You'll Learn]

• Requirements Analysis and Core Entity Extraction

• ERD Creation and Terminology Dictionary Management

• Normalization (1NF ~ BCNF) and Its Limitations

• Index and Performance-Considered Physical Modeling

• Shopping Mall Project Complete DB Design Practice

[Target Audience]

• Developer: Someone who wants to design a proper database before writing code

• Planner/Analyst: Those who want to fundamentally understand data flow and structure

• Job seekers: Those who want to demonstrate differentiated DB design capabilities in interviews

• Junior Developer: Those who want to learn design principles that can be applied immediately in practice

• Senior Developer/Lead: Those who want to improve the quality of their team's database design

[Complete Course Curriculum]

1. Course Introduction and Class Materials

* 1-A. Windows - MySQL Installation Guide

* 1-B. macOS - Installation Guide

2. The Importance of Design

* The First Step in Database Design

* The Disaster Caused by Poor Design

* 3 Stages of Design - Conceptual, Logical, Physical

* Summary

3. Conceptual Modeling

* Requirements analysis and identification of key elements

* What is an entity?

* Entity Classification 1

* Entity Classification 2

* Properties and Identifiers

* Cardinality and Participation

* Complete the ERD

* Related Entity - Resolving Many-to-Many Relationships

* Glossary

* Summary

4. Conceptual Modeling - Practice

* Practical Requirements Analysis

* Practical Conceptual Modeling - Getting Started

* Practical Conceptual Modeling - ERD Creation

* Practical Conceptual Modeling - Glossary Creation

* Summary

5. Logical Modeling 1 - Keys

* Various types of keys

* Natural Key vs Surrogate Key1 - Natural Key

* Natural Key vs Surrogate Key2 - Surrogate Key

* Natural Key vs Surrogate Key3 - Performance Trade-offs

* Natural Key vs Surrogate Key4 - Modern Design

* Composite key design

* Many-to-Many Relationships and Composite Keys

* Summary

6. Logical Modeling 2 - Participation and One-to-Many Relationships

* Logical Modeling - Relationships

* Participation

* One-to-Many (1:N) Many-to-One (N:1) Relationships - Foreign Key Position 1

* One-to-Many (1:N) Many-to-One (N:1) Relationships - Foreign Key Position 2

* One-to-Many (1:N) Many-to-One (N:1) Relationships - Joins and Data Inflation

* Summary

7. Logical Modeling 3 - One-to-One, Many-to-Many Relationships

* One-to-one (1:1) relationship - Start

* One-to-one (1:1) relationship - Foreign key location

* One-to-One (1:1) Relationship - [Practice] Flexibility of Relationship Extension

* One-to-one (1:1) relationship - FK in the main table

* Many-to-Many (M:N) Relationship - Limitations of the Relational Model

* Many-to-Many (M:N) Relationship - Junction Table

* Many-to-Many (M:N) Relationship - Attributes

* Many-to-Many (M:N) Relationship - Conceptual and Logical Modeling

* Summary

8. Logical Modeling 4 - Identifying Relationships, Non-Identifying Relationships

* Identifying Relationship vs Non-Identifying Relationship - Concepts

* Identifying Relationship vs Non-Identifying Relationship - One-to-Many (1:N)

* Problems with Identifying Relationships

* Identifying Relationship vs Non-Identifying Relationship - SQL Queries, Performance

* Identifying Relationship vs Non-Identifying Relationship - One-to-One (1:1)

* Identifying Relationship vs Non-Identifying Relationship - Many-to-Many (M:N) 1

* Identifying Relationship vs Non-Identifying Relationship - Many-to-Many (M:N) 2

* Identifying Relationships vs Non-Identifying Relationships - Modern Design Trends

* Summary

9. Logical Modeling - Practice

* Practical Logical Modeling - Getting Started

* Practical Logical Modeling - ERD Creation

10. Normalization

* Normalization - Start

* First Normal Form

* Second Normal Form

* Third Normal Form

* BCNF Normal Form

* Practice and Normalization

* Summary

11. Physical Modeling

* Physical Modeling Overview

* Table and Column Conversion Rules 1 - Basic Rules

* Table and Column Conversion Rules 2 - Abbreviations and Singular/Plural

* Data Type 1 - Character, Number, PK Type

* Data Types 2 - Date and Time Types

* Denormalization

* Table Definition Document

* Summary

12. Physical Modeling - Practice

* Physical Modeling - Practice Start

* Index Design - Practice

* Denormalization - Practice

* Shopping Mall Table Definition Document

* Creating Shopping Mall DDL and DB

* Physical Model - Automatic ERD Generation

* Shopping mall feature check 1

* Shopping mall feature check 2

* Summary

Thank you.