강의

멘토링

커뮤니티

BEST
Programming

/

Database

MySQL Performance Optimization Guide for Non-Specialists: Beginner to Advanced (SQL Tuning Edition)

I've created the 'MySQL Performance Optimization Intro/Practical (SQL Tuning Edition)' course, easy for non-majors to understand and immediately applicable in practice!

(5.0) 126 reviews

1,195 learners

  • jscode
이론 실습 모두
취준생
비전공자
MySQL
DBMS/RDBMS
query-tuning
SQL

Reviews from Early Learners

What you will learn!

  • Self-directed SQL statement tuning methods

  • Practical Index Techniques

  • MySQL Performance Improvement Methods

  • Practical DB Performance Improvement Methods

  • Identifying SQL Performance Bottlenecks with Execution Plans


🤬 Damn it, I can't do this anymore!

I'm Park Jaesung, who started development as a non-major and worked as CTO at various companies, and am currently active as an educator. I also started development as a non-major and had a time when I was studying MySQL performance optimization.

While studying MySQL performance optimization, there were quite a few points that I found difficult. First, there were too many difficult and unfamiliar terms. B+Tree, covering index, full table scan, random access, and many other unfamiliar terms made me feel resistant to learning.

I overcame this reluctance and managed to read through books related to performance improvement, but there were not many examples of how to optimize MySQL performance in different situations. As a result, I didn't know how to actually improve performance in real projects.

Since I also went through such difficulties, I thought I should create a MySQL performance optimization course that even non-majors can immediately apply in real-world situations.

✨ 4 Points I Focused on While Creating the Course

Now that we've learned the concepts, we need to directly experience actually tuning SQL statements by utilizing those concepts. To do that, we need sufficient examples to practice SQL tuning. So I've prepared a total of 17 practical examples.

We'll carefully select and teach you only the core concepts you actually need for performance improvement. Just knowing a few commonly used concepts will be more than enough for performance optimization. We won't teach you unnecessary concepts. By learning this way, you can learn really quickly and apply it directly in real-world situations.

I thought that if you can't apply what you've learned in real situations even after completing the entire course, then it's a poorly designed course. I tried to structure it as a practical course that can be immediately applied to real work, rather than an academic approach that focuses on deep theoretical learning.

We won't just explain theory, but will show you every step of the performance improvement process using examples. By showing you this improvement process, you can easily learn what steps you can take to improve DB performance in real-world situations.

👍 Great for these types of people!

Someone who is having difficulty
learning MySQL performance optimization by watching
YouTube or reading blogs

Someone from a non-major background who
has slow understanding of
difficult concepts and terminology

Those who want to directly diagnose inefficient parts of SQL in real-world work and personally improve performance

🙊 After completing this course?

You will be able to identify on your own what factors are causing specific SQL statements to perform slowly. And you will be able to directly achieve meaningful performance improvements.

🍡 Tasting

'What is an Index?' lesson

'Understanding MySQL Structure for Performance Improvement / Core of SQL Tuning' Class

[[STRONG_1]]'[[/STRONG_1]][실습] 좋아요 많은 순으로 게시글 조회하는 SQL문 튜닝하기[[STRONG_2]]'[[/STRONG_2]] 수업 中

Reference Notes

The course proceeds under the assumption that you have basic knowledge of SQL statements. Therefore, we recommend taking this course after you have learned basic SQL statements. If you encounter any parts that are difficult to understand while studying, please feel free to ask questions immediately using the Q&A board or 1:1 open chat room😊

🚨 Make sure to check what kind of person is providing the education!

If you meet the wrong doctor, you might face death because your illness cannot be cured at that moment. However, death ends with the pain of that moment. But if you meet the wrong teacher and receive poor education, you will suffer throughout your entire life.

Poor education can lead you to unwanted companies, smaller salaries than expected, and a lifetime of suffering. Not only that, but the wrong education you received can be passed down to your children as well.

Education can truly change a person's life in a positive way, but on the other hand, I think it can also completely ruin a person's life. That's why I believe education carries such heavy responsibility.

Therefore, please check who is providing the education, what kind of person they are, and what path they have walked, and make a careful judgment.

👋 Hello!
I'm finally introducing myself now ( ⸝⸝•ᴗ•⸝⸝ )੭⁾⁾

Hello!

I started studying development as a non-major. I've already become a 6-year developer! Recently, I worked as a developer while serving as CTO at two companies. Whenever I had time, I've been doing coding lectures, company development consulting, and presentations.

The number of students I've taught has now exceeded 24,000 (as of July 2025)! Every time I teach various students, I always feel the same way - I can't forget the sense of fulfillment from education, so I plan to continue providing education consistently on Inflearn.
(* Students who passed interviews at Kakao Pay, Yanolja, and Woowa Brothers among my learners)

Just as I received a lot of help during difficult and challenging times, I wanted to become someone who could help many other people as well. And I felt most proud and happy when the value I created through development had a positive impact on others.

For these reasons, I hope that by sharing and giving what I have worked hard to achieve, those people can live a slightly better life.

Thank you!

🏆 Course Best Review

** This is a review written for the previously created .


🚌 Feeling overwhelmed about what order to take the courses?

'[2025] Essential Curriculum for Getting a Job as a Backend Developer (IT Service Companies)' Please refer to this!



🐶 Get Course Discounts with Roadmaps

➡ Performance optimization for large-scale traffic handling (https://inf.run/ecBS1)

Recommended for
these people

Who is this course right for?

  • Backend Developer seeking IT service firm roles

  • Job seeker seeking unique qualifications

  • MySQL Performance Improvement: Hands-on?

  • Those needing to improve DB performance in their practical work.

  • Those who want to learn SQL tuning

  • For those who want to directly analyze and fix slow SQL.

Need to know before starting?

  • SQL query

Hello
This is

28,316

Learners

1,872

Reviews

684

Answers

4.9

Rating

16

Courses

 

[Sites]
Youtube 바로가기
LinkedIn 바로가기

 

[Career]
現) JSCODE - 대표 멘토, CEO
前) (주)트라이포드랩 - CTO
前) (주)온리원유니버스 - CTO
前) 달리(DALY) - CTO
前) 팀메이트(Teammate) - CEO

 

[Books]

『Do it! JSCODE의 AWS 입문』, 이지스퍼블리싱 (2025.05)

 

[ETC]
- 기업 대상 개발 컨설팅 및 코딩 교육 활동

Curriculum

All

39 lectures ∙ (2hr 42min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

126 reviews

5.0

126 reviews

  • Young님의 프로필 이미지
    Young

    Reviews 1

    Average Rating 5.0

    5

    100% enrolled

    처음에는 너무 기초적인 내용아닌가 싶었는데 뒤로 갈수록 튜닝파트에서 확실히 도움되는 내용이었어요! 실습도 다 끝내고 선생님이 요점만 쏙쏙 잘 뽑아내주셔서 의문이 드는 점 없이 이해가 잘되었습니다. 감사합니다 다른 강의도 보려구용

    • JSCODE 박재성
      Instructor

      Young님~ 강의만으로 내용들을 모두 이해하셨다니 너무 잘 따라오신 것 같아요! 다른 강의도 힘 얻어서 열심히 준비해볼게요 :) 수강평 넘 감사드려요~ 😊

  • 쿠카이든님의 프로필 이미지
    쿠카이든

    Reviews 485

    Average Rating 5.0

    5

    100% enrolled

    SQL 성능향상과 튜닝에 대해 여러 방면으로 생각을 할 수 있었던 시간이었습니다! 좋은 강의 감사드립니다~!

    • service님의 프로필 이미지
      service

      Reviews 24

      Average Rating 5.0

      5

      100% enrolled

      감사합니다. 좋은 인사이트 얻고갑니다!!!

      • 철현님~ 완강까지 하시느라 수고 많으셨는데 도움을 얻으신것같아 마음이 놓이네요😊 좋은 수강평 남겨주셔서 감사합니다~!!

    • 김수현님의 프로필 이미지
      김수현

      Reviews 4

      Average Rating 5.0

      5

      100% enrolled

      sql 성능 개선에 바로 적용할 수 있는 실용적인 강의였습니다

      • 수현님~~ 강의 전부 들으시느라 수고 많으셨어요~! 좋은 후기 남겨주셔서 감사합니다😊😊

    • 13123213님의 프로필 이미지
      13123213

      Reviews 2

      Average Rating 5.0

      5

      63% enrolled

      개념은 간단히 배우고 바로 실습하는 것을 좋아하면 강의 추천해요. 개념부분은 정말 간단히 알려주셔서 보충 공부가 필요합니다. 하지만 바로 적용할 수 있는 부분이 좋았습니다. BTree인덱스 구조와 MySQL에서 인덱스 탐색, 인덱스 스캔을 어떤식으로 하는지 공부하고 실습 따라가면 머릿속에서 그림이 바로 그려져요.

      • 안녕하세요 13123213님! 말씀해주신 대로 이론적인 내용을 추가적으로 같이 학습하시면 훨씬 더 깊이 있게 배우실 수 있습니다😊 보충 공부와 강의를 잘 병행하셔서 학습하신 것 같네요!! 배우신 내용을 실전에서도 많이많이 써먹어보시기 바랍니다~~!!

    $68.20

    jscode's other courses

    Check out other courses by the instructor!

    Similar courses

    Explore other courses in the same field!