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

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.