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.

230 learners are taking this course

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

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

604,306

Learners

42,428

Reviews

9,115

Answers

5.0

Rating

27

Courses

More

Curriculum

All

104 lectures ∙ (21hr 10min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

Not enough reviews.
Please write a valuable review that helps everyone!

yh's other courses

Check out other courses by the instructor!

Similar courses

Explore other courses in the same field!

Limited time deal

$83.60

29%

$118.80