inflearn logo

Kim Young-han's Practical Database - Performance Optimization, Complete Mastery of Execution Plans and Indexes

"A query that ran perfectly during development suddenly slows down as data accumulates." At such times, the mark of a truly skilled developer is identifying the root cause based on solid evidence rather than guesswork, and optimizing a 30-second query down to 0.1 seconds. Master the core principles of database performance—from execution plans, indexes, and optimizers to joins and sorting—using millions of rows of real-world data. Elevate your skills and become a top-tier developer capable of independently analyzing and resolving slow queries in production environments.

(5.0) 31 reviews

1,924 learners

Level Intermediate

Course period Unlimited

SQL
SQL
MySQL
MySQL
DBMS/RDBMS
DBMS/RDBMS
sql-tuning
sql-tuning
SQLD
SQLD
SQL
SQL
MySQL
MySQL
DBMS/RDBMS
DBMS/RDBMS
sql-tuning
sql-tuning
SQLD
SQLD

Reviews from Early Learners

5.0

5.0

박종철

9% enrolled

Hello. I sincerely congratulate you, Kim Young-han, on completing your incredible 7-year journey! I have been taking your classes ever since my first one in January 2023, eagerly waiting for the notifications of new course releases to pop up. Looking back now at those late-night study sessions after work, rubbing my sleepy eyes to stay awake, I sometimes wonder how I managed to keep at it. It was grueling and a bit daunting, but it also filled me with immense pride and happiness. It has been a tremendous privilege and a source of great pride to have accompanied you to the very end of this monumental journey, one in which you poured your heart and soul into every meticulous detail. Once again, thank you from the bottom of my heart for tirelessly completing this remarkable roadmap over the past 7 years.

5.0

이수현

94% enrolled

When I was preparing for employment, I used to be amazed by how easy it was to understand Mr. Kim Young-han’s lectures. They also helped strengthen my determination to find a job and motivated me to work hard in my preparation. Now that I’m employed, I’ve reached the stage where I think not only about basic database design but also about performance optimization. Even as I continue gaining hands-on experience, I’m very happy and grateful to still be learning alongside Mr. Kim Young-han’s lectures. Studying while envisioning an actual production database seems to make the lectures even more helpful. Thank you so much, as always, for your excellent lectures.

5.0

widn45

15% enrolled

You explained MySQL so clearly! Thank you.

What you will gain after the course

  • The ability to read an execution plan and independently diagnose the cause of a slow query.

  • The ability to independently design indexes tailored to specific situations.

  • Real-World Experience in Optimizing Queries by 10x to 100x Across Millions of Data Records

  • Understanding Database Internals Beyond Indexes

Recommended for
these people

Who is this course right for?

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

  • A backend developer who encountered a slow query in a live service but is at a complete loss as to where to begin troubleshooting.

  • A developer who is comfortable with feature development using SQL, but lacks confidence when faced with performance issues.

  • Aspiring Database Administrator (DBA)

Need to know before starting?

  • Kim Young-han's Practical Database Fundamentals

Hello
This is yh

Inflearn Verified

613,329

Learners

43,041

Reviews

9,134

Answers

5.0

Rating

27

Courses

More

Curriculum

All

104 lectures ∙ (21hr 10min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

31 reviews

5.0

31 reviews

  • brian1103269537님의 프로필 이미지
    brian1103269537

    Reviews 3

    Average Rating 4.7

    5

    94% enrolled

    When I was preparing for employment, I used to be amazed by how easy it was to understand Mr. Kim Young-han’s lectures. They also helped strengthen my determination to find a job and motivated me to work hard in my preparation. Now that I’m employed, I’ve reached the stage where I think not only about basic database design but also about performance optimization. Even as I continue gaining hands-on experience, I’m very happy and grateful to still be learning alongside Mr. Kim Young-han’s lectures. Studying while envisioning an actual production database seems to make the lectures even more helpful. Thank you so much, as always, for your excellent lectures.

    • yh
      Instructor

      It makes me truly proud and happy to see that you’ve been with us since your days preparing for employment and have now grown into an amazing developer who considers performance optimization in your professional work, Suhyeon Lee :) I sincerely support your journey as a developer, as you continue to grow without pause, and I hope you’ll keep achieving great things in the future.

  • maxjc님의 프로필 이미지
    maxjc

    Reviews 36

    Average Rating 4.8

    Edited

    5

    9% enrolled

    Hello. I sincerely congratulate you, Kim Young-han, on completing your incredible 7-year journey! I have been taking your classes ever since my first one in January 2023, eagerly waiting for the notifications of new course releases to pop up. Looking back now at those late-night study sessions after work, rubbing my sleepy eyes to stay awake, I sometimes wonder how I managed to keep at it. It was grueling and a bit daunting, but it also filled me with immense pride and happiness. It has been a tremendous privilege and a source of great pride to have accompanied you to the very end of this monumental journey, one in which you poured your heart and soul into every meticulous detail. Once again, thank you from the bottom of my heart for tirelessly completing this remarkable roadmap over the past 7 years.

    • yh
      Instructor

      Mr. Jong-cheol Park, thank you so sincerely for being with me on this long journey since 2023 and for celebrating the final period with me. Thanks to people like you, I was able to find the strength to complete the roadmap. I will be sincerely rooting for you, wishing that the path you walk ahead is always filled with great achievements and happiness!!!

  • widn451695님의 프로필 이미지
    widn451695

    Reviews 30

    Average Rating 5.0

    5

    15% enrolled

    You explained MySQL so clearly! Thank you.

    • yh
      Instructor

      Thank you for listening so cleanly, widn45^^!

  • whh123459562님의 프로필 이미지
    whh123459562

    Reviews 121

    Average Rating 5.0

    5

    61% enrolled

    • chaeyunpark07829님의 프로필 이미지
      chaeyunpark07829

      Reviews 16

      Average Rating 5.0

      5

      61% enrolled

      yh's other courses

      Check out other courses by the instructor!

      Similar courses

      Explore other courses in the same field!

      25% off for new members

      $88.80

      25%

      $118.80