Kim Younghan's Practical Database Introduction - SQL First Steps for All IT Professionals (Step by Step from SQL)

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.

Hello everyone
The Database Design Part 1 course is finally ready to open.

The Design Part 1 to be released this time is scheduled to launch between September 16th and September 19th.

Database Roadmap - Course Release Schedule

• Design Part 1 – Complete Mastery of Modern Data Modeling - Expected release in mid-September

• Design Part 2 - Mastering Practical Design Patterns and Application Techniques - Scheduled for release at the end of 2025

• Performance Optimization and Advanced Features - Scheduled for release in early 2026

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

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 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 Points of the Lecture

* Conceptual → Logical → Physical Modeling

Completely master DB design with a 3-step approach.

* Design know-how for immediate practical use

We don't just stay in theory, but use a shopping mall project as an example.

* Avoiding the Pitfalls of Poor Design

You'll realize through hands-on practice why ERD is important, why normalization is necessary, and when denormalization should be applied.

* The Essence of Key and Relationship Design

Natural Key vs Surrogate Key, One-to-One, One-to-Many, Many-to-Many relationships, and Identifying vs Non-Identifying relationships are covered in depth.

* Reflecting the Latest DB Design Trends

It presents modern data modeling methodologies without being stuck in textbooks from decades ago.

What You'll Learn

• Requirements Analysis and Core Entity Derivation

• 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

* First Steps 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 Classification2

* 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 Multiplication

* 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 Database

* Physical Model - Automatic ERD Generation

* Shopping mall feature check 1

* Shopping mall feature check 2

* Summary

Thank you.

Hello, everyone

The two introductory database fundamentals lectures have finally been launched: Now available.

We've decided to offer an introductory database course for free so that even beginners can learn databases without any pressure.

Kim Young-han's Practical Database Roadmap

1. Practical Database Introduction by Kim Young-han - Step-by-Step from SQL (Now Open)

2. Kim Young-han's Practical Database - Basic Course (Now Open)

3. Kim Young-han's Practical Database - Design Edition (Scheduled for Second Half of 2025)

4. Kim Young-han's Practical Database - Performance Optimization and Advanced Features (Scheduled for Second Half of 2025)

Target Audience

For your reference, this lecture has been designed to be accessible not only to developers but also to planners and data analysts.

• Developer: Juniors, non-majors, and job seekers who want to build a solid foundation in database basics

• Planner/Marketer: For those who need data-driven decision making

• Data Analyst: Beginner who wants to build SQL skills

[Introducing the Roadmap from a Developer's Perspective]

If you're a developer, I recommend following the entire roadmap.

Many developers will relate to this: truly outstanding applications are ultimately built on well-designed databases. This is because there are problems that simply cannot be solved by application code alone—they lie within the database layer. This roadmap will fill in that other half of essential expertise, elevating you to the next level as a developer.

Beginner Course: First, build a foundation in databases and SQL basics through the 'Beginner Course'.

Basic Course: The basic course covers essential database fundamentals that every junior developer must know.

• You'll gain the ability to solve any complex business requirement using SQL through joins, subqueries, unions, and case statements.

• Build a solid foundation in essential SQL performance optimization for real-world applications by thoroughly understanding how indexes work.

• You can develop stable applications that prevent data corruption by gaining a deep understanding of transactions and data integrity.

Design Course: The design course will elevate you to a higher level of developer. You'll learn how good database design determines an application's maintainability and scalability, and develop the ability to systematically model complex real-world requirements.

Performance Optimization and Advanced Features: Performance Optimization and Advanced Features is the final gateway to becoming a senior developer capable of handling large-scale traffic. You will master advanced techniques to identify database performance bottlenecks that no one else can solve and push your service to its limits.

By mastering this roadmap, you'll grow into a truly skilled developer who goes beyond simply implementing features—gaining deep understanding and optimization skills for both applications and databases, enabling you to find solutions to any challenging situation.

[Introduction to Roadmap from a Planning and Data Analyst Perspective]

If you're a planner or data analyst, I recommend taking the introductory course and continuing through the basic course.

Beginner Course: By learning the basics of SQL through the beginner course, you'll gain the speed and independence to instantly get the answers you need, no longer having to request data and wait.

Basic Course: In the Basic Course, we take one step further.

You'll enhance the depth of your analysis by using advanced SQL techniques like joins, subqueries, unions, and CASE statements to combine scattered data from multiple sources and reprocess it according to your own criteria.

With just these two courses, you'll become a key talent capable of improving services based on data, persuading organizations, and communicating effectively with development teams.

If you want to directly lead data-driven products, taking the advanced 'Design' course to deepen your understanding of data structures could be a great choice.

This roadmap's introductory and foundational sections will completely transform the way planners and analysts work with data.

Beginner Course - Section Contents

1. Course Introduction and Study Materials

2. Introduction to Databases

3. Starting the Database

4. SQL - Data Management

5. SQL - Retrieval and Sorting

6. SQL - Data Processing

7. SQL - Aggregation and Grouping

Beginner Course - Section Contents

1. Course Introduction and Study Materials

2. Join 1 - Inner Join

3. Join 2 - Outer Joins and Other Joins

4. Subquery

5. UNION

6. CASE Statement

7. 뷰(View)

8. Index1

9. Index 2

10. Data Integrity

11. Transaction

12. Stored Procedures, Functions, and Triggers

I've gathered your questions about roadmap progress and will answer them.

1. Basic Order of Progressing Through the Database Roadmap

- The basic order is Java -> Database -> Spring -> Spring Boot and JPA application.

2. Recommended Order for Progressing Through the Database Roadmap

The most effective learning sequence is to study the introductory and basic database courses right before Spring DB1 in the Spring roadmap.

Therefore, you will learn in the following order.

- ...

- Spring MVC2

- Database Fundamentals

- Database Fundamentals

- Spring DB Part 1

- Spring DB Part 2

- ...

We recommend completing at least the Database Fundamentals course before proceeding with the Spring Boot and JPA application roadmap.

I'll reorganize and let you know again about the database design section, performance optimization, and advanced features once they're released.

3. Will the course be based on MySQL or Oracle?

The hands-on exercises focus on MySQL, but the lecture content emphasizes universal knowledge that covers not only MySQL but relational database management systems (RDBMS) in general. Therefore, the goal is to achieve a broad understanding that isn't limited to any specific database.

To use an analogy, in this course we'll learn how to drive a car called MySQL. But rather than simply learning how to operate one specific car model, we'll focus on mastering the fundamental driving principles—like accelerators, brakes, and steering wheels—that apply to any car (RDBMS). These core concepts of RDBMS will be beneficial when working with other RDBMS systems as well.

Thank you.