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

🤬 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

👍 People like this will like it!

🙊 After listening to this lecture?

🍡 Taste

✔ 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 )