inflearn logo

MySQL learned from a Toss developer who processes over 500 billion pieces of financial data

Learn how to design and handle large-scale data architectures that process hundreds of billions of records using only pure SQL and core MySQL features, alongside a Toss developer who handles hundreds of billions of financial traffic transactions and a developer who started as a non-major and is now developing platforms in Pangyo.

(4.7) 50 reviews

818 learners

Level Beginner

Course period Unlimited

MySQL
MySQL
Jetbrains
Jetbrains
mysql-query
mysql-query
MySQL
MySQL
Jetbrains
Jetbrains
mysql-query
mysql-query

Reviews from Early Learners

4.7

5.0

에이미

88% enrolled

I really enjoyed the lecture. While listening to it, I thought about parts that other people might find helpful as reference, so let me organize the areas where I found it beneficial. Advantages: 1. It's really realistic. When covering topics, the instructor directly mentions if certain forms aren't commonly used in practice, often saying "I'm covering this because it's good to know, even though it's not frequently used." I think this shows that a truly skilled developer is making an effort to share both realistic and less practical aspects. 2. The content itself is really valuable. From general and simple CRUD operations to explanations of various architectural perspectives possible with MySQL - it's not just content limited to databases, but contains rich material about development itself. 3. These seem like topics you can't hear anywhere else. Most MySQL or database lectures are limited to how to write queries and what functions are available, but this lecture uses procedures and explains well the essential topics of how databases should be used. However, honestly, I think this lecture has some disadvantages as much as it has advantages. 1. The difficulty level doesn't seem easy. Beginners in development might find it difficult to follow due to lack of basic knowledge. 2. The explanations aren't that rich and Kind. While covering really diverse topics, the explanations aren't proportionally detailed. To put it simply, it feels somewhat like having a mentor who's really good at development, but from the mentor's perspective, some things are so obvious that they just skip over them. Conclusion: But even excluding all these points, I think it's a really good lecture. If you actually have the will to study and want to learn many aspects, this lecture would be suitable. Conversely, if you're fine with learning just the basics and want to be spoon-fed, this lecture probably won't be of much help. From my perspective, it was a really satisfying lecture because I could learn not only about MySQL but also think about its applications and study from an architectural perspective. I was so impressed that I'm leaving a comment like this for the first time.

5.0

미래 1인 개발자

79% enrolled

I'm a server developer working at Toss who participated most deeply in this MySQL course. Hong previously prepared and created a Kafka-related course together with Choi, and since that topic was really good and I also wanted to share my knowledge in a deeper way, I decided to participate like this. - Of course, I had participated indirectly or directly before, but I was more immersed and engaged in this course. Actually, I don't think simply covering MySQL content alone would have that great of a learning effect for you all. Currently, with AI advancement, AI actually writes queries better than we do. What you need to know here is "what aspects you can consider" and "what methods are available." I think the ability lies in knowing these aspects and knowing how to instruct AI accordingly. I hope this course will be very helpful to you all from that perspective. Please show lots of interest. Thank you!!

5.0

lsls ks

83% enrolled

I think this is a great topic for gaining truly deep knowledge about MySQL. It covers some basic CRUD operations and focuses only on queries that are realistically used, which makes it even more helpful. However, the more important part seems to be the design patterns at the end. It was a great help in gaining the perspective to see the forest. Thank you.

What you will gain after the course

  • MySQL Horizontal Scaling Techniques Using Sharding and Partitioning

  • Is sharding always the right approach? Knowledge regarding that fundamental question.

  • Traffic distribution strategies and load balancing using replication, and the resulting methods for ensuring HA.

  • Concurrency control using Transaction & Lock and MVCC for ensuring performance

  • MySQL API for mastering only the CRUD operations actually used in real-world practice.

  • Advanced optimization techniques for SELECT queries, which account for 90% of traffic.

  • Index analysis and query analysis through query pre-planning

  • Database structure design principles for scalable system design

Recommended for
these people

Who is this course right for?

  • 1–3 year backend developers who feel limited by doing only CRUD.

  • A developer who has experienced service performance degradation due to slow queries

  • Those who want to take on the challenge of designing scalable systems that can handle high-volume traffic

  • Server developers who want in-depth communication with DBAs and data engineers

  • Those who want to develop real-world problem-solving skills rather than just learning theoretical SQL.

  • An engineer who wants to work on systems where stability and performance are critical, such as financial data.

Hello
This is Hong

Inflearn Verified

Career Verified

10,230

Learners

653

Reviews

165

Answers

4.7

Rating

34

Courses

I started studying development after becoming interested in it while idling at home, and I am currently responsible for platform server development in Pangyo. I am continuing my activities as a knowledge sharer because I want to provide you with the methods I used to study, as well as the various problems and solutions you may encounter in practice.

 

These lectures are not created solely through my own knowledge. There are others who collaborate on every lecture.

 

[Instructor Career]

[Former] Blockchain developer related to Sandbox IP

[Former] Metaverse Backend Developer

[Current] A server developer becoming a veteran in Pangyo

 

[Interview History]

[Other Inquiries]

[Official Site]

More

Curriculum

All

24 lectures ∙ (4hr 41min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

50 reviews

4.7

50 reviews

  • tttos님의 프로필 이미지
    tttos

    Reviews 8

    Average Rating 5.0

    5

    79% enrolled

    I'm a server developer working at Toss who participated most deeply in this MySQL course. Hong previously prepared and created a Kafka-related course together with Choi, and since that topic was really good and I also wanted to share my knowledge in a deeper way, I decided to participate like this. - Of course, I had participated indirectly or directly before, but I was more immersed and engaged in this course. Actually, I don't think simply covering MySQL content alone would have that great of a learning effect for you all. Currently, with AI advancement, AI actually writes queries better than we do. What you need to know here is "what aspects you can consider" and "what methods are available." I think the ability lies in knowing these aspects and knowing how to instruct AI accordingly. I hope this course will be very helpful to you all from that perspective. Please show lots of interest. Thank you!!

    • jhong
      Instructor

      Thank you for creating another great course that can have a positive impact!! I hope the parts we worried about and thought through will reach the students. Please take good care of us next time too!!

  • goryp017165님의 프로필 이미지
    goryp017165

    Reviews 13

    Average Rating 4.8

    5

    100% enrolled

    It's too abstract and broad. I'd appreciate it if you could focus specifically on databases, but you're discussing too many different things.

    • jhong
      Instructor

      Hello young pyo lee, thank you for your evaluation and feedback!! I think that in modern times, it's not just about simple database usage that's important. I believe what matters is whether you can do something derived through that database. From this perspective, I filmed the lecture and wanted to share a very broad range of perspectives with you all. As a result, it seems like there ended up being quite a lot of abstract concepts. Next time, I will work even harder to provide you with a more satisfying lecture. Thank you for taking the time to leave this review!!

  • ghwlsrnt1230881님의 프로필 이미지
    ghwlsrnt1230881

    Reviews 1

    Average Rating 4.0

    4

    88% enrolled

    Hmm... I got excited on my own because of the title and thought there would be practical examples, and I wanted to see some real-world work on handling large volumes with MySQL. But there's no such content. In the latter part, it seemed like they were going to cover large-scale data handling, but it ended with explaining one syntax and saying things like "there's actually no need to introduce it to this extent" and "MySQL is sufficient in many cases," which was disappointing. I wanted to know what cases MySQL is sufficient for, when you feel MySQL's limitations in real work, etc. It's disappointing. Since there's a lot of content within the time limit, the depth is somewhat shallow, so it seems like content that beginners or those who want to study MySQL can listen to comfortably and without burden, rather than for working professionals.

    • yonghyng님의 프로필 이미지
      yonghyng

      Reviews 16

      Average Rating 4.9

      3

      100% enrolled

      I thought it would cover query statements in depth, but it didn't, which was disappointing. Still, thank you for the good lecture.

      • jhong
        Instructor

        Hello Mr. Hwang Yong-hak, thank you so much for taking the time to leave a review. Actually, I had many concerns while preparing this course. I thought about what parts I should teach you, what concepts would be more effective in practice, and selected these topics after much consideration!! I think that the process of writing general queries doesn't really provide much help. Using UNION well, applying WHERE conditions really well - I thought these topics don't fit well with current trends. Because now AI uses them better than me and other senior developers, analyzes better, and teaches better. So while I do cover general queries, rather than focusing on that part, I thought it would be right to show you what you can utilize and apply while using this MySQL database. Based on this content, I thought I could help improve your work performance by asking questions to AI later. So because this course contains a lot of this perspective, unfortunately it seems like it wasn't the course you wanted, Mr. Hwang Yong-hak. Still, I will work hard to provide better courses in the future and show you a better version of myself. Thank you so much for taking the course!!!

    • digitcomgisul님의 프로필 이미지
      digitcomgisul

      Reviews 27

      Average Rating 4.0

      2

      100% enrolled

      Superficial knowledge

      • jhong
        Instructor

        Hello digitcom, thank you for your feedback!! Since I need to cover various topics and there are many ways to write MySQL queries but I thought the competitiveness was lacking, I wanted to inform you about the overall architecture. Also, I wanted to provide some direction and perspective for studying, so I offered this topic. It seems like I wasn't able to give you better satisfaction, digitcom 😭😭 I will work harder to receive better reviews in the future. Thank you.

    Hong's other courses

    Check out other courses by the instructor!

    Similar courses

    Explore other courses in the same field!

    25% off for new members

    $41.60

    25%

    $61.60