MySQL from a Kakao Interviewer Handling 1 Trillion++ Data Points

This course provides a step-by-step learning path, ranging from the fundamental usage of MySQL to advanced techniques required in real-world production environments. It covers a wide range of topics, including data modeling techniques based on various case studies and practical data, evaluating the effectiveness of Foreign Key designs, analyzing Google Calendar schema DDL, and modern DDL design principles. Through this course, you will gain an in-depth understanding of how to utilize MySQL as a core system component rather than just a simple database.

(4.7) 20 reviews

395 learners

Level Beginner

Course period Unlimited

MySQL
MySQL
DBMS/RDBMS
DBMS/RDBMS
Data Engineering
Data Engineering
backend
backend
MySQL
MySQL
DBMS/RDBMS
DBMS/RDBMS
Data Engineering
Data Engineering
backend
backend

Reviews from Early Learners

Reviews from Early Learners

4.7

5.0

warna

91% enrolled

The more I reflect on it, the more I feel it contains truly great content. I think it would be excellent for those who have a habit of self-directed learning. If you go through the detailed explanations of the major topics and take some time to contemplate them on your own... I believe it is structured with content that is better than any other lecture.

5.0

이병석

89% enrolled

I'm a developer in my fourth year of professional experience... and I had no idea this course would dive so deep into MySQL. I highly recommend this course to anyone who says, "I only know how to write basic queries" when it comes to MySQL. I believe that how well you understand the DB determines your ability to go beyond simple query tuning and implement various patterns in your services. I truly learned a lot. This course was like a long-awaited rain...!

5.0

황규민

33% enrolled

This is a lecture that truly elevates one's perspective. I once used the Strategy Pattern to adhere to OCP instead of using switch-case statements at the application level, and it feels similar to using dimension tables to avoid case-when at the database level. I didn't know there were patterns in SQL as well. I feel like I can grow even further.

What you will gain after the course

  • Data modeling processes and relational structure optimization techniques commonly used in the industry

  • Integrity and Performance Management Strategies Using Foreign Keys, Indexes, and Transactions

  • Service-Oriented DDL Design and Schema Structure Analysis: A Case Study of Google Calendar

  • MySQL Performance Tuning and Query Optimization Patterns in High-Traffic Environments

MySQL is back, and this time with a Kakao developer (interviewer).

  • The content below is an actual conversation.

😄 Hong : You know that MySQL lecture based on over 500 billion rows of data that we made with XX (Toss developer) last time. I think the content is great and very informative, but it seems like there are people who want to focus more on the basics... ㅠㅠ It bothers me a bit that those parts are currently lacking.

😁 Toss Developer : I've had similar thoughts as well. From my perspective, it's a very beneficial topic, and I prepared it because I wanted to show the big picture rather than fragmented thinking. However, looking at the reviews and feedback, it seems that more people than expected were looking for content that sticks to the basics and focuses on the modeling perspective.

😁 Toss Developer : So, from my perspective, I think I covered really beneficial content well, but I do think there are some parts that might be a bit disappointing from many other people's perspectives.

😁Kakao Developer (Interviewer) : I also thought the content itself was excellent, but I did have that thought. I wondered if this lecture was truly for complete beginners... So after seeing that, I actually wanted to cover it myself lol. Since I also act as an interviewer, I see many junior-level candidates as well.

😄 Hong : LOL, so that's why I actually reached out to find someone to join me in organizing the content—covering everything from basics to advanced patterns, as well as realistic DDL design principles and practical DDL design. LOL

😁Kakao Interviewer (Developer): As if we don't know you lol. Then I'll participate this time. I'm thinking of a style that covers the junior level as a base, while gradually introducing perspectives from a senior level.

Introducing the latest technologies based on MySQL Stable 8.x version, covering everything from actual data modeling to query anti-patterns

MySQL is the most representative RDBMS and is a database that almost every company adopts and uses. There is virtually no company that does not use MySQL. With the great advantage of being relational and providing a way to build services stably, you cannot properly proceed with service development if you do not have a solid understanding of MySQL.

Many of you have shown great interest and love for the MySQL course, so this time I have prepared a topic that covers everything from basic to advanced modeling. ⚡

In an environment where countless services are connected around data, we face situations where we must design and manage the data structure itself beyond simple CRUD. Every time, we find ourselves contemplating. Should I always use Foreign Keys? Is the schema created by an ORM truly the best? What criteria should be used for DDL design? You will find yourself asking questions about this series of processes.

In this course, we will find the answers to these questions step-by-step, covering everything from the basics of MySQL to advanced applications.
Going beyond simple SQL syntax, we present a perspective that views the database as a true "core component of a service"—from data modeling principles, the effectiveness of relationship settings, and analysis of practical schema designs like Google Calendar, to modern DDL structure design principles. Start your journey to growing into an engineer who can design data structures, rather than just a developer who writes good queries, with this course. 🚀

Why MySQL Database

From its past to the present, MySQL has established itself as the most widely used and fundamental database in the industry.

Due to its characteristics of being Open Source & Cost-Effective, you can get started without the burden of licensing costs. This is a significant advantage, especially for startups or small-scale projects where initial capital is crucial, and it also supports transitioning to an enterprise version that can receive Oracle's commercial technical support if needed. This is possible because the ecosystem is very large. There is also the High Performance & Flexibility perspective. It boasts very fast speeds for read-heavy workloads. Additionally, it supports various storage engines (e.g., InnoDB, MyISAM), providing the flexibility to optimize performance according to the characteristics of the application. Finally, one of the biggest advantages is its Vast Ecosystem. As it is used by millions of developers worldwide, documentation and community answers for problem-solving are extremely abundant. Furthermore, since it is provided as a managed service by all major cloud services such as AWS, Azure, and Google Cloud, it also has the advantage of being very easy to build and operate.. Với hàng triệu nhà phát triển trên toàn thế giới đang sử dụng, các tài liệu và câu trả lời từ cộng đồng để giải quyết vấn đề là vô cùng phong phú. Ngoài ra, vì nó được cung cấp dưới dạng dịch vụ quản lý (Managed Service) trên tất cả các dịch vụ đám mây lớn như AWS, Azure và Google Cloud, nên nó còn có ưu điểm là cực kỳ dễ dàng trong việc thiết lập và vận hành.

MySQL introduces itself in its official documentation as follows:

Many of the world's largest and fastest-growing organizations including Facebook, Twitter, Booking.com, and Verizon rely on MySQL to save time and money powering their high-volume Web sites, business-critical systems and packaged software.

( Many of the world's largest and fastest-growing companies, including Facebook, Twitter, Booking.com, and Verizon, are choosing MySQL. They rely on MySQL to save time and money in powering their high-traffic websites, business-critical systems, and packaged software. )

MySQL is an absolute necessity in modern architecture, and there is a reason why all giant corporations use it. It is treated as an essential technology to learn by understanding its structural advantages, such as Open Source & Cost-Effective, High Performance & Flexibility, and Vast Ecosystem.

Through this time, I highly recommend that you learn everything about MySQL and grow into a developer with a technical stack that sets you apart from others. 🚀

Features of this course

📌 A course structured based on the know-how and interview questions of actual Kakao interviewers (developers)

  • This course was developed in collaboration with an active developer currently serving as an interviewer at Kakao. You can learn a wide range of practical skills, from interview response strategies to actual DDL design methods.

📌 Lecture Summary and Structure via Source Code

  • Actual MySQL queries are provided for every lecture, and the course content is naturally integrated with hands-on practice. This will further enhance your understanding and learning effectiveness.

📌 A shortcut from junior to senior..! Design pattern architecture

  • You can learn not only anti-patterns but also specific DDL design methods based on real-world practical experience. Beyond simple conceptual explanations, you can solidly strengthen your design capabilities through realistic examples.

Recommended for these people 👨‍🏫

🎯 Beginner and intermediate developers who want to build a solid foundation in MySQL basics muốn củng cố vững chắc kiến thức MySQL từ cơ bản

  • Those who want to structurally learn various patterns of INSERT/UPDATE/DELETE, SELECT tuning, and index utilization beyond simple CRUD.

🎯 Developers who want to learn data modeling concepts systematically các khái niệm mô hình hóa dữ liệu một cách có hệ thống

  • Those who find it difficult to design entities, attributes, and relationships

  • Those who want to clearly understand when, why, and how to use Foreign Keys

  • Those who want to experience practical design patterns such as normalization/denormalization, side tables, EAV, and slot structures.

🎯 Backend developers who are curious about how to design MySQL for large-scale services

  • Those who need a lecture covering the actual service schema design process, such as Google Calendar.

  • Those who want to get a sense of how to consider performance in a high-traffic environment

🎯 Backend job seekers and junior developers who need interview preparation

  • Those who want to know from what perspective a Kakao interviewer views DB questions

  • Those who want to organize typical interview topics such as DB transactions, integrity, indexes, and FKs based on practical standards.

🎯 Senior-oriented developers who want to view MySQL as the 'core structure of the system'

  • Those who want to understand MySQL not just as a simple storage, but as a core component of service design

  • Those interested in schema refactoring and evolving database structures (DDL Evolution)

The career background of the Kakao developer (interviewer) who prepared this lecture 🤭

I am Choi (abbreviated name), a 12th-year backend server developer who works on server development at Kakao and also serves as an interviewer.

I first connected with Hong at a Conference, and since the mid-point of our lecturing activities, we have continued to actively participate together, building a history of creating lectures on various topics. I believe that talking and communicating with many different people while creating these lectures has been a great help in my life as a developer and a time where I can learn from diverse perspectives, so I am striving to cover an even wider range of topics.

I don't believe that a single credential from a so-called "major corporation" proves that someone is a good developer. However, I do believe it allows for exposure to significantly higher traffic and experiences compared to typical platforms. I will always strive to incorporate these insights into my lectures. Thank you.

[Current] Kakao Headquarters Server Developer

[Former] Majored in Computer Science at a 4-year university in Seoul

Notes

Practice Environment

  • IDE

    • GoLand

  • OS

    • Apple M3 Air


I am running an open chat room to help you prepare for your career. We look forward to your interest!

MySQL, DBMS/RDBMS, Data Engineering, backend

Recommended for
these people

Who is this course right for?

  • Backend developers who want to move beyond simple query writing and start designing data structures

  • Engineers who want to deeply understand the SQL principles hidden behind ORM.

  • A system architect seeking to optimize databases at the service architecture level

  • Entry-level and junior developers who want to gain experience in modeling and production-level schema design standards.

  • Tech leaders interested in building scalable data infrastructure centered around MySQL

Hello
This is Hong

7,493

Learners

461

Reviews

142

Answers

4.7

Rating

25

Courses

Introduction

I started studying development after finding an interest in it while idling at home, and I am currently in charge of 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. Every lecture is made together with others.

 

Instructor Experience

[Former] Blockchain developer related to Sandbox IP

[Former] Metaverse Backend Developer

[Current] A veteran server developer in Pangyo

 

Interview History

Other Inquiries

  • unduck2022@gmail.com

More

Curriculum

All

45 lectures ∙ (11hr 36min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

20 reviews

4.7

20 reviews

  • byeongseogi492130님의 프로필 이미지
    byeongseogi492130

    Reviews 7

    Average Rating 5.0

    5

    89% enrolled

    I'm a developer in my fourth year of professional experience... and I had no idea this course would dive so deep into MySQL. I highly recommend this course to anyone who says, "I only know how to write basic queries" when it comes to MySQL. I believe that how well you understand the DB determines your ability to go beyond simple query tuning and implement various patterns in your services. I truly learned a lot. This course was like a long-awaited rain...!

    • jhong
      Instructor

      Hello, Mr. Lee Byeong-seok. It is an honor to meet a developer currently working in the field. I feel a bit shy as well, haha. I will continue to provide many more lectures that are like a refreshing rain, offering even more useful information. Have a great day!!

  • cchoii님의 프로필 이미지
    cchoii

    Reviews 12

    Average Rating 5.0

    5

    98% enrolled

    Hi, I'm Choi (pseudonym), a developer and interviewer at Kakao! After seeing a friend at Toss create a course recently, I felt motivated to put together this course on MySQL. I’ve worked hard to pack in as many concepts as possible. I honestly believe that if you go through each lesson one by one, this course will leave you 90% prepared for anything involving MySQL—including practical, real-world applications! MySQL is quite approachable, but it’s one of those things that’s easy to forget when you actually sit down to use it. I hope this course helps you review what you know and learn plenty of new concepts along the way. Thank you.

    • gsu002845933님의 프로필 이미지
      gsu002845933

      Reviews 7

      Average Rating 5.0

      5

      93% enrolled

      This course is like a MySQL guidebook. It covers everything from basic commands to advanced patterns and concepts, and even design perspectives, all in one go. I really enjoyed it.

      • warna97725274님의 프로필 이미지
        warna97725274

        Reviews 5

        Average Rating 5.0

        5

        91% enrolled

        The more I reflect on it, the more I feel it contains truly great content. I think it would be excellent for those who have a habit of self-directed learning. If you go through the detailed explanations of the major topics and take some time to contemplate them on your own... I believe it is structured with content that is better than any other lecture.

        • jhong
          Instructor

          Hello warna, thank you for leaving such a great review!! It seems like your perspective aligns perfectly with the direction I'm aiming for!! Given the nature of lectures, it's essential to have time to study on your own, reflect on the concepts, and truly make them your own...!! Development is something you do yourself, and realistically, in a professional offline environment, it's very rare for someone to spoon-feed you information. I feel very proud because it seems like we share similar values. haha Have a great day!

      • bosterbucheon2980님의 프로필 이미지
        bosterbucheon2980

        Reviews 5

        Average Rating 5.0

        5

        89% enrolled

        I really enjoyed it. I think explaining the pros and cons first will be helpful to others. Pros 1. The content is truly informative. It doesn't just teach simple commands but also provides a design perspective. 2. There are plenty of materials for hands-on practice. 3. It provides an environment where you can enter actual queries and study on your own. Cons 1. Since there is a lot to learn... I think the difficulty level is somewhat high. You need to take some time to reflect and study on your own. - I think quite a few people might find this part unsatisfying. Personally, I don't mind because I'm the type who likes to study independently, but... Still, it was great content that I'd want to give 10 out of 5 stars. Thank you.

        Hong's other courses

        Check out other courses by the instructor!

        Similar courses

        Explore other courses in the same field!

        $110.00