강의

멘토링

로드맵

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

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


🤬 Oh my, I can't eat this!

My name is Jaeseong Park , and I started out as a developer without a major, worked as a CTO at several companies, and am currently working as an educator. There was a time when I also started as a developer without a major and studied MySQL performance optimization.

There were more than one or two points that I found difficult while studying MySQL performance optimization. First of all, there were too many difficult and unfamiliar terms. B+Tree, covering index, full table scan, random access, etc. There were so many unfamiliar terms that I felt a sense of resistance.

I overcame this resistance and barely managed to read a book on performance improvement, but there weren't many examples of how to optimize MySQL's performance in certain situations. As a result, I didn't know how to improve performance in an actual project.

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

Four points I paid attention to while creating the lecture

After learning the concepts, we need to experience tuning SQL statements using the concepts. To do that, we need enough examples to practice SQL tuning. So, we have prepared a total of 17 practical examples.

I will teach you only the core concepts that are necessary for actual performance improvement . If you know just a few frequently used concepts, there will be no major problems in improving performance. I will not teach you useless concepts. If you learn this way, you will learn really quickly and can apply it right away in real life.

I thought that if you can't apply it in real life even after listening to the lecture, it was a bad lecture. I tried to structure the lecture as a practical lecture that can be applied directly to real work, rather than an academic method that studies theories in depth .

Rather than just explaining the theory, I will show you the process of improving performance step by step with examples. By showing you this improvement process, you can easily learn how to improve DB performance in practice.

👍 People like this will like it!

By watching YouTube or blogs
I'm having trouble learning MySQL performance optimization.
Anyone who has

Because I am not a major
Difficult concepts and terms
People who are slow to understand Korea

Anyone who wants to directly diagnose inefficient parts of SQL in the field and improve performance

🙊 After listening to this lecture?

You will be able to identify for yourself what factors are slowing down the performance of a specific SQL statement. And you will be able to make meaningful performance improvements yourself.

🍡 Taste

'What is an Index?' in class

In the class 'Understanding MySQL Structure for Performance Improvement / Core of SQL Tuning'

' [Practice] Tuning SQL statement to search posts by number of likes ' In class

Note

The class is conducted on the assumption that you have a basic understanding of SQL statements. Therefore, I recommend that you take this course after learning basic SQL statements . If you come across a part that you do not understand while studying, please use the Q&A bulletin board or 1:1 open chat room to ask questions right away . 😊

🚨 Be sure to check who is teaching you!

If you meet the wrong doctor, you may die at that moment because you cannot cure your illness. However, death ends with the pain of that moment. However, if you meet the wrong teacher and receive the wrong education, you will suffer throughout your life.

Due to wrong education, you may end up going to a company you don't want to work for, receiving a salary that is lower than you expected, and living a life of suffering because of it. Not only that, but because of the wrong education, your children will also inherit the wrong education.

I think that education can really change a person's life in a positive way, but on the other hand, it can also completely destroy a person's life. I think that's why education is such a heavy responsibility.

Therefore, please check who the person teaching you is, what kind of person they are, and what path they have taken, and then make a careful decision.

👋 Hello!
Now I introduce myself ( ⸝⸝•ᴗ•⸝⸝ )੭⁾⁾

hello!

I started studying development as a non-major . I have already been a developer for 6 years! Recently, I have been working as a developer while serving as CTO at two companies . Whenever I have free time, I have been giving coding lectures, consulting on company development, and giving lectures.

The number of students I have taught so far has already exceeded 24,000 (as of July 25th) ! I feel this every time I teach many students, but I cannot forget the sense of pride I feel in education, so I will continue to provide education at Inflearn.
(* Among the students, there are those who passed the exams at Kakao Pay, Yanolja, and Woowa Brothers)

Just as I have received a lot of help when I was going through hard times, I wanted to become someone who could help many other people. And I feel most proud and happy when the value I created through development has had a positive impact on others.

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

thank you!

🏆 Best Reviews of Lectures

** This is a review written for the previously produced <AWS Introduction/Practice that Non-Majors Can Understand>.


🚌 What if you don’t know what order to take the lectures in?

Please refer to ' [2025] Essential Curriculum for Employment as a Backend Developer (IT Service Company) ' !



🐶 Get a discount on courses with Roadmap

Performance optimization for handling large-scale traffic ( 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

27,149

Learners

1,572

Reviews

613

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

116 reviews

5.0

116 reviews

  • kendrick171799님의 프로필 이미지
    kendrick171799

    Reviews 1

    Average Rating 5.0

    5

    100% enrolled

    At first, I thought it was too basic, but as I went on, it definitely helped me with the tuning part! After finishing the practice, the teacher extracted only the main points, so I understood it well without any questions. Thank you. I'm going to watch other lectures.

    • jscode
      Instructor

      Young-nim~ I think you followed along very well since you understood all the content just from the lecture! I will gain strength and prepare hard for other lectures :) Thank you so much for the course review~ 😊

  • kukaeden님의 프로필 이미지
    kukaeden

    Reviews 469

    Average Rating 5.0

    5

    100% enrolled

    This was a valuable time to think about SQL performance improvement and tuning from various angles! Thank you for the great lecture~!

    • wsde43665님의 프로필 이미지
      wsde43665

      Reviews 24

      Average Rating 5.0

      5

      100% enrolled

      Thank you. I gained some good insights!

      • jscode
        Instructor

        Cheolhyun, you've worked so hard to complete the whole course, and I'm relieved to hear that you've gained some help from it. Thank you for leaving such a great review!

    • soohyunkim9644님의 프로필 이미지
      soohyunkim9644

      Reviews 4

      Average Rating 5.0

      5

      100% enrolled

      It was a practical lecture that could be immediately applied to SQL performance improvement.

      • jscode
        Instructor

        Soohyun, you've worked hard to listen to all the lectures! Thank you for leaving a great review 😊😊

    • ghffu4068032님의 프로필 이미지
      ghffu4068032

      Reviews 2

      Average Rating 5.0

      5

      63% enrolled

      I recommend this lecture if you like learning concepts briefly and then immediately putting them into practice. The conceptual part is taught very briefly, so supplementary study is needed. However, I liked that I could apply it right away. If you study the B-Tree index structure and how MySQL performs index searches and index scans, and then follow along with the practice exercises, you can immediately picture it in your head.

      • jscode
        Instructor

        Hello 13123213! As you mentioned, studying theoretical content in addition to practical exercises will allow you to learn in much greater depth 😊 It seems like you've been balancing supplementary study and lectures well! Be sure to apply what you've learned in real-world situations as much as possible!

    Limited time deal ends in 1 days

    $41.80

    29%

    $59.40

    jscode's other courses

    Check out other courses by the instructor!

    Similar courses

    Explore other courses in the same field!