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

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.

(5.0) 216 reviews

2,690 learners

Level Basic

Course period Unlimited

SQL
SQL
MySQL
MySQL
DBMS/RDBMS
DBMS/RDBMS
software-design
software-design
SQLD
SQLD
SQL
SQL
MySQL
MySQL
DBMS/RDBMS
DBMS/RDBMS
software-design
software-design
SQLD
SQLD

Reviews from Early Learners

5.0

5.0

코틀린자바

98% enrolled

While theory doesn't change and can be learned just by purchasing books, this lecture is incredibly valuable for its explanations of theory and insights gained from experience. It would have taken years to understand why certain things work well in specific situations, which Young-han experienced firsthand, but I was able to learn it all within 16 hours through this lecture, which was great.

5.0

개foot

39% enrolled

By presenting scenarios and test cases for designs that could easily be taken for granted, this class made it easy and fun to establish a database perspective on difficult concepts.

5.0

석이네토마토

60% enrolled

For backend developers, all of Young-han's lectures are the bible.

What you will gain after the course

  • Mastering the 3 Stages of Systematic Database Design: Conceptual, Logical, and Physical Modeling

  • Experience in practical database design and construction through an actual shopping mall project

  • Normalization Theory and Practice for Data Integrity

  • Physical design and implementation skills with performance in mind

  • Understanding modern design techniques and the latest trends

  • Practical know-how from industry experts and data-related problem-solving skills

No. 1 in cumulative students in the domestic development field,
Young-han Kim's Practical Database


Good DB design is not about a single right answer, but
starts with the insight to make good decisions.

I love database design and application design. I have always contemplated better designs, and I have spent a long time thinking about how to effectively convey that process to all of you. That is why this lecture was a very enjoyable time for me as well, and I prepared it with the hope of sharing even one more thing with you.

There is no single right answer in database modeling. Options vary depending on the situation, and ultimately, the decision you make is what matters. That is why in this lecture, rather than just showing you the results, I wanted to share the process of what considerations I went through to make those choices.

I hope this lecture serves as a reliable guide that helps you develop the insight needed to make design decisions in the field.


Younghan Kim's Practical Database Roadmap

This course is the third installment of the Practical Database Roadmap, designed to help you systematically acquire the essential insights and fundamentals for real-world design through the three stages of database modeling.

📘 Roadmap Composition

📘 Roadmap Learning Guide

In the "Database Design Part 2" to be studied later,

It focuses on database design patterns and application techniques proven in practice.
We will review the core rules essential for modern design and, based on them, step-by-step learn the patterns and techniques frequently used in the field.

Recommended for
these people

Who is this course right for?

  • Job seekers and students preparing for a career in the IT field

  • Backend Developer

  • Service/Product Planner

  • Aspiring Database Administrator (DBA)

  • Data Analyst

  • Startup Founders and Tech Leaders

Need to know before starting?

  • Young-han Kim's Practical Database Fundamentals

Hello
This is yh

586,870

Learners

41,166

Reviews

9,091

Answers

5.0

Rating

26

Courses

My goal is to provide education so that you can become a truly practical and competent developer.

 

The story of my life as a developer

EO Interview Video

Gaebalbadak - A Country Youth Becomes the King of Development

Solving concerns about employment and career changes

 

More

Curriculum

All

83 lectures ∙ (16hr 11min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

216 reviews

5.0

216 reviews

  • kotlinjava님의 프로필 이미지
    kotlinjava

    Reviews 22

    Average Rating 5.0

    Edited

    5

    98% enrolled

    While theory doesn't change and can be learned just by purchasing books, this lecture is incredibly valuable for its explanations of theory and insights gained from experience. It would have taken years to understand why certain things work well in specific situations, which Young-han experienced firsthand, but I was able to learn it all within 16 hours through this lecture, which was great.

    • yh
      Instructor

      That's right, KotlinJava. I hope that the next generation of developers can quickly absorb what I've felt and experienced over a long time, so they can focus on better concerns. Seeing your course review, KotlinJava, makes all the hard work I put into preparation worthwhile :) Thank you.

  • dirend79555님의 프로필 이미지
    dirend79555

    Reviews 55

    Average Rating 5.0

    5

    39% enrolled

    By presenting scenarios and test cases for designs that could easily be taken for granted, this class made it easy and fun to establish a database perspective on difficult concepts.

    • yh
      Instructor

      Thank you, Gaefoot! I'm rooting for you!^^

  • inhwanhan4915님의 프로필 이미지
    inhwanhan4915

    Reviews 5

    Average Rating 5.0

    5

    30% enrolled

    Wow... I feel like I'm learning so much as I reorganize the things I've felt deep in my bones after getting a job in the "wild." Even for things I already knew, listening to them again and realizing, "Ah, so that's why it was like that," feels like true learning.

    • yh
      Instructor

      Mr. In-hwan Han, it's very rewarding for me as well because you listen so attentively^^ Thank you^^!!

  • yongsdev님의 프로필 이미지
    yongsdev

    Reviews 6

    Average Rating 5.0

    5

    60% enrolled

    For backend developers, all of Young-han's lectures are the bible.

    • yh
      Instructor

      Thank you, Seokine Tomato!!!!!!!!!!!!

  • foem6293367님의 프로필 이미지
    foem6293367

    Reviews 19

    Average Rating 5.0

    5

    100% enrolled

    It felt like drinking a concentrated extract of database essentials! 👍 I really enjoyed the lecture! I get the feeling that if I were to look inside the Baemin database, all of this essence would be melted right into it. Thank you for the great lecture 😌

    • yh
      Instructor

      Thank you as well, Choi Chi-won, for listening so attentively!

yh's other courses

Check out other courses by the instructor!

Similar courses

Explore other courses in the same field!