강의

챌린지

멘토링

로드맵

커뮤니티

MySQL Lessons from a Toss Developer Who Processes More Than 500 Billion Financial Data Records

Learn how to design and process large-scale data architectures capable of handling hundreds of billions of records, using only pure SQL and MySQL’s core features, alongside a Toss developer who handles hundreds of billions of financial transactions and a developer who started without a computer science background and now works on platform development in Pangyo.

(4.7) 52 reviews

839 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

bht9011

63% enrolled

It feels like this course compactly covers a wide range of MySQL topics in a single lecture. There were parts I didn't fully grasp while reading the "Real MySQL" book, but watching this course later helped me finally understand them. It's rare to find introductory courses that explain how to manage large-scale data, but this one provides a guide on how to handle database scaling, helping me gain a broader perspective. I highly recommend it!

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!!

What you will gain after the course

  • Horizontal Scaling Techniques for MySQL Using Sharding and Partitioning

  • Is Sharding Really Always the Right Approach?? Insights into This Fundamental Question

  • Traffic distribution strategy using replication and load balancing, and the corresponding method for ensuring HA

  • MVCC for Concurrency Control and Performance Using Transcation & Lock

  • A MySQL API covering and familiarizing you with only the CRUD operations actually used in practice

  • Advanced Techniques for SELECT Statements Handling 90% of the Traffic

  • Index Analysis and Query Analysis Through Query Preplanning

  • Database Schema Design Principles for Scalable System Architecture

How do Toss developers handle MySQL when working with over 500 billion financial records? 🤔

❗This is an actual conversation.❗

😄 Hong: By the way, I’ve been wondering about something lately. When Toss uses MySQL, they must have hundreds of billions or even trillions of records—how do you handle all of that?

😁Toss: Who are you?

😄 Hong: No, seriously, that's something I've been wondering about lately. There must be limits to simply optimizing SELECT queries, and there must also be limits to physical storage... I'm wondering how to address these issues as the service grows;;

😁 Toss: Rather than trying to solve it simply through queries such as SELECT, you should use other methods if you know how to make use of the database. After all, the physical limitations are clear.

😁 Toss: But who are you??

😄 Hong: ㅡㅡ Stop joking around... This time, tell me about this topic so we can combine it with what I know and build it together.

Rather than simply trying to solve it using queries such as SELECT, you need to know how to leverage the database and solve it in a different way, since the physical limitations are clear

What does this mean?? 🤷 And how should we solve it?? The answer lies in understanding and appropriately using mysql-query beyond the SELECT and JOIN we already know, as well as designing architectures that handle MySQL in extreme situations. In this course, we go beyond simple tuning to reveal the core principles of replication, partitioning, and sharding for handling large-scale traffic, along with all the know-how from a TOSS developer and me.


Rather than a boring lecture that merely lists theory, I have prepared this as a hands-on guide to mastering MySQL’s core features by examining the process of writing and executing actual queries together. 🚀

Features of this course ⚡

📌 A course implemented purely with SQL

* No additional languages are used. This course exclusively uses SQL syntax and covers MySQL.

📌 Practical SQL queries and content consisting of over 1,500 lines

* This course consists of approximately 1624 lines, including various queries, SQL queries for generating mock data, and theoretical content related to the lecture!

📌 Various MySQL techniques you may not easily encounter in real-world environments

* Are queries in the form of procedures bad?? It would be incorrect to simply say that they are bad. This course covers procedures that can be used based on actual table structures.

📌 SQL query syntax for generating mock data

* Simply sending queries with small amounts of data is not effective. To help you continue learning on your own in the future, we provide some queries for generating various mock data.

📌 The shortcut from junior to senior..! System Design

* Simply tuning queries is clearly limited. You can learn how to design systems according to the purpose of the traffic.

* By familiarizing yourself with the various architectures that can be built using databases, you can develop your skills as a systems architect.

Recommended for people like these ⚡

Backend Developer

I want to work with large volumes of data.

Job seekers preparing for employment

Getting a job is so difficult.

Junior DB Engineer

I only know CRUD, actually...

The course covers the following topics. ⚡

* Various MySQL configuration variables

* MySQL connection management techniques for practical security

* Database design patterns for server developers

* Techniques for data distribution [ Partitioning & index optimization ]

* Data modeling techniques

* Optimization patterns for CRUD

* MySQL Internal Architecture and Storage

* Memory management, transactions, and lock mechanisms

* MySQL Extension Systems [Replication and Distribution, Partitioning and Sharding]

* Data compression and archiving

* Practical! Data Modeling for Building Services

Why should I learn MySQL?? 🤔

Our goal is mostly to get jobs or change jobs. Under these circumstances, it’s actually very simple. Because MySQL is a database widely used by companies.

The person who created this course 🤭

  • A developer who started without a computer science background and currently works as a platform backend developer in Pangyo

  • My goal is to teach realistic development practices and methodologies, and to be a knowledge sharer who creates courses together with talented people around me rather than alone.

  • A knowledge sharer who, thanks to his active contributions, was featured in an interview on Inflearn

People who participated in this course 🤭

  • A server developer who majored in computer science outside the capital, worked as a developer at Naver, and is currently working as a backend developer at Toss

  • A developer who is always short on time and often gets scolded by Hong...

  • A developer who wants to achieve financial freedom and dreams of becoming a solo developer

A course that boosts your learning effectiveness tenfold when watched together

The easiest and most in-depth guide to Kafka [By a non-major and Kakao developer]

  • I’ll show you everything about what kind of architecture can be implemented using the most representative MSQ commonly used with databases to loosely couple services!!

Things to Know Before Enrolling

  • IDE:

    JetBrains IntelliJ

  • MySQL:

    9.2.0 for macOS 15.2 on arm64 (Homebrew)

We run an open chat room to help you prepare for your careers. We look forward to your interest!

Recommended for
these people

Who is this course right for?

  • Backend developers with 1–3 years of experience who feel limited by CRUD alone

  • A developer who experienced degraded service performance due to slow queries

  • Those who want to take on the challenge of designing scalable systems capable of handling high-volume traffic

  • A server developer who wants in-depth communication with DBAs and data engineers

  • Those who want to develop real-world problem-solving skills—not just learn SQL theory.

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

Hello
This is Hong

Inflearn Verified

Career Verified

10,235

Learners

609

Reviews

175

Answers

4.8

Rating

30

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

52 reviews

4.7

52 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!!

  • 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!!!

  • 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.

    • digitcomgisul님의 프로필 이미지
      digitcomgisul

      Reviews 28

      ∙

      Average Rating 3.9

      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!