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) 71 reviews

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

최재훈

100% enrolled

It was a bit difficult because I don't have practical experience, but I gained so much from this lecture. Thank you for the great lecture, Young-han! (I'm dying to take the performance optimization lecture)

5.0

램쥐뱅

100% enrolled

I gained a lot from this lecture as well. Looking back at the course history, all of Young-han's lectures were truly sincere and every single one was helpful. I look forward to the next lecture. It’s been about 3 years since I started using AI in my work, and I think there have been many changes in my development methods over the past 3 years. In particular, lately, I’ve been having more and more thoughts about the changing role of developers. I’m curious about your thoughts, Young-han, and how your future lectures might change!

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

598,635

Learners

41,757

Reviews

9,104

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

87 lectures ∙ (13hr 17min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

71 reviews

5.0

71 reviews

  • yess70770210님의 프로필 이미지
    yess70770210

    Reviews 15

    Average Rating 4.8

    Edited

    5

    100% enrolled

    I have gained a lot of clarity regarding database design. Thank you for the great lecture.

    • yh
      Instructor

      For ever, you've organized the important DB design very well! Thank you for leaving a course review. haha

  • 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!

  • wogns2139209님의 프로필 이미지
    wogns2139209

    Reviews 17

    Average Rating 5.0

    5

    100% enrolled

    It was a bit difficult because I don't have practical experience, but I gained so much from this lecture. Thank you for the great lecture, Young-han! (I'm dying to take the performance optimization lecture)

    • yh
      Instructor

      Thank you, Jaehoon Choi :) I am also working incredibly hard to prepare the performance optimization lecture! Please look forward to it!

  • h2g2marvin님의 프로필 이미지
    h2g2marvin

    Reviews 2

    Average Rating 5.0

    5

    100% enrolled

    It was great to understand the background of why patterns frequently used in practice emerged and to clearly see the trade-offs regarding what to keep in mind during actual use. I am also looking forward to the upcoming performance optimization section.

    • yh
      Instructor

      Thank you, Marvin. I'm always rooting for you^^

  • jusungpark님의 프로필 이미지
    jusungpark

    Reviews 25

    Average Rating 4.8

    5

    100% enrolled

    I gained a lot from this lecture as well. Looking back at the course history, all of Young-han's lectures were truly sincere and every single one was helpful. I look forward to the next lecture. It’s been about 3 years since I started using AI in my work, and I think there have been many changes in my development methods over the past 3 years. In particular, lately, I’ve been having more and more thoughts about the changing role of developers. I’m curious about your thoughts, Young-han, and how your future lectures might change!

    • yh
      Instructor

      It's been a while, Ram쥐뱅-nim :) I have also been thinking a lot about this part. First of all, I believe productivity in the AI era is defined as (one's own fundamentals * AI utilization skills). I intend to focus on the fundamentals of development here. The methods of developing through AI change so rapidly that they often become volatile knowledge that evaporates quickly. On the other hand, essentials like object-oriented programming or database architecture do not change. In an era where AI writes code quickly, a developer's insight and design skills—judging whether that code is correct and if there are any issues with system performance—will become the true competitive edge. Therefore, my lectures will continue to move in the direction of covering deep, unchanging operating principles. In the upcoming 'Database Performance Optimization' lecture, I also focused on solidifying these foundations. I sincerely support you in creating your own wonderful synergy by placing the powerful weapon of AI on top of a solid foundation. I will prepare the next lecture with great care so that it can provide practical help. Thank you always! :)

yh's other courses

Check out other courses by the instructor!

Similar courses

Explore other courses in the same field!