Young-han Kim's Practical Database - Design Part 2, 9 Design Patterns You Must Encounter in Practice

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.

(5.0) 93 reviews

2,477 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

탁형

29% enrolled

About 6 years ago, when I had a stagnant career, I started pulling my weight after taking Young-han Kim's JPA course, and now I've reached a point where I'm evaluated as a high performer at my company. Now, ahead of a job change where I'm scheduled to take on the roles of PM and Team Leader, this DB course was released at the perfect time. Even though I find backend development easy now, DB was always the area where I felt lacking, but this roadmap is truly resolving many of the concerns I've had in practice. I would like to express my sincere gratitude to Mr. Young-han Kim for saving my career once again.

5.0

widn45

31% enrolled

I'm really enjoying listening! I'm always rooting for you. Fighting!

5.0

idmist78

100% enrolled

Practical experience in DB design is truly difficult. Once you start, it takes a long time, and even after doing it for several years, the opportunities are few and far between... I was able to gain valuable experience through your excellent lecture, Young-han. Thank you.

What you will gain after the course

  • Practical database design and implementation skills

  • Mastering 9 Design Patterns You'll Inevitably Encounter in Practice

There is no right answer in design.
In the end, what matters is the ability to make trade-offs

Practical design is not about finding a fixed correct answer, but a process of choosing the best trade-off for the given situation. Therefore, rather than just delivering refined theories, I wanted to share with you the design methods and decision criteria that I have actually agonized over and chosen through various projects in this course.

Design skills are not built overnight. They are accumulated bit by bit through a repeated process of designing, failing, and improving again. Try applying the patterns learned in this lecture to your actual projects. There will come a moment when a pattern naturally comes to mind just by hearing the requirements.

I sincerely hope this course serves as an opportunity for your design skills to grow to the next level.

Younghan Kim's Practical Database Roadmap

This course is the fourth lecture in the Practical Database Roadmap, and it covers how to solve problems encountered when designing actual service structures after modeling from a design pattern perspective.

📘 Roadmap Composition


📘 Roadmap Learning Guide

Recommended for
these people

Who is this course right for?

  • Job seekers and students preparing for careers in the IT field

  • Backend Developer

  • Aspiring Database Administrator (DBA)

  • Data Analyst

Need to know before starting?

  • Young-han Kim's Practical Database: Fundamentals

  • Young-han Kim's Practical Database Design Part 1

Hello
This is yh

Inflearn Verified

603,800

Learners

42,364

Reviews

9,115

Answers

5.0

Rating

26

Courses

More

Curriculum

All

87 lectures ∙ (13hr 17min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

93 reviews

5.0

93 reviews

  • widn451695님의 프로필 이미지
    widn451695

    Reviews 29

    Average Rating 5.0

    5

    31% enrolled

    I'm really enjoying listening! I'm always rooting for you. Fighting!

    • yh
      Instructor

      Thank you for your valuable review, widn45!!

  • kimbokyun3112339님의 프로필 이미지
    kimbokyun3112339

    Reviews 2

    Average Rating 5.0

    Edited

    5

    100% enrolled

    Thank you for the great lecture. I have gained confidence in DB design. I am looking forward to the next lecture as well.

    • yh
      Instructor

      Thank you so much for listening so attentively, Uhahahahahehe! ^^

  • dkfkskgks님의 프로필 이미지
    dkfkskgks

    Reviews 9

    Average Rating 5.0

    5

    61% enrolled

    It was a great DB design lecture. Thank you for the wonderful lecture! I'm looking forward to the next advanced DB lecture as well. haha

    • yh
      Instructor

      I'm rooting for you, Fantasy World~

  • mist님의 프로필 이미지
    mist

    Reviews 21

    Average Rating 4.8

    Edited

    5

    100% enrolled

    Practical experience in DB design is truly difficult. Once you start, it takes a long time, and even after doing it for several years, the opportunities are few and far between... I was able to gain valuable experience through your excellent lecture, Young-han. Thank you.

    • nujkat님의 프로필 이미지
      nujkat

      Reviews 34

      Average Rating 4.7

      5

      29% enrolled

      About 6 years ago, when I had a stagnant career, I started pulling my weight after taking Young-han Kim's JPA course, and now I've reached a point where I'm evaluated as a high performer at my company. Now, ahead of a job change where I'm scheduled to take on the roles of PM and Team Leader, this DB course was released at the perfect time. Even though I find backend development easy now, DB was always the area where I felt lacking, but this roadmap is truly resolving many of the concerns I've had in practice. I would like to express my sincere gratitude to Mr. Young-han Kim for saving my career once again.

      • yh
        Instructor

        Thank you, Tak-hyung. It’s great to see that you haven't just let the time pass, but have consistently studied and put in the effort. I hope you continue to care for your colleagues and grow even more with a broader perspective :) I’m rooting for you!

    yh's other courses

    Check out other courses by the instructor!

    Similar courses

    Explore other courses in the same field!