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

1,475 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

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

Jace Alan

31% enrolled

The best!

5.0

김동현

31% enrolled

I've been listening consistently! It's been very helpful! 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

586,413

Learners

41,078

Reviews

9,087

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

58 reviews

5.0

58 reviews

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

  • jacealan님의 프로필 이미지
    jacealan

    Reviews 5

    Average Rating 5.0

    5

    31% enrolled

    The best!

    • yh
      Instructor

      Go for it, Jace Alan!!!

  • nieve777772461님의 프로필 이미지
    nieve777772461

    Reviews 3

    Average Rating 3.7

    5

    100% enrolled

    Thank you for the great lecture.

    • yh
      Instructor

      nieve77777, thank you for listening so attentively.

  • kk091209044331님의 프로필 이미지
    kk091209044331

    Reviews 5

    Average Rating 5.0

    Edited

    5

    31% enrolled

    I've been listening consistently! It's been very helpful! Thank you.

    • yh
      Instructor

      Mr. Dong-hyun Kim, it's very rewarding for me to see you listening so attentively^^ Thank you.

  • klord님의 프로필 이미지
    klord

    Reviews 9

    Average Rating 5.0

    5

    82% enrolled

    Even though it's information I already know, it's worth every penny. I'm enjoying it because it helps connect fragmented knowledge into a single flow. Please bring on the next lecture quickly.

    • yh
      Instructor

      Thank you so much for listening so attentively, klord!! I am working hard on preparing the next lecture as well^^!

yh's other courses

Check out other courses by the instructor!

Similar courses

Explore other courses in the same field!

$93.50