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.8) 29 reviews

463 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

4.8

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

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

Inflearn Verified

Career Verified

10,017

Learners

635

Reviews

165

Answers

4.7

Rating

32

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

45 lectures ∙ (11hr 36min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

29 reviews

4.8

29 reviews

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

    • kslj82586229님의 프로필 이미지
      kslj82586229

      Reviews 8

      Average Rating 5.0

      5

      98% enrolled

      This was very informative and helpful!! Honestly, for this level of content, the price seems quite affordable, and I was able to get a glimpse into the insights of a true expert. Thank you.

      • jhong
        Instructor

        Hello, "Crazy for Development"! Thank you for leaving such a great review!! I will continue to provide even more helpful content in the future. Thank you!!

    • sdl1355126님의 프로필 이미지
      sdl1355126

      Reviews 19

      Average Rating 5.0

      5

      96% enrolled

      I think this is a great lecture that covers MySQL in quite a bit of depth. I enjoyed it.

      • jhong
        Instructor

        Hello keny, thank you for leaving such a great review!

    • byeongseogi492130님의 프로필 이미지
      byeongseogi492130

      Reviews 9

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

    • warna97725274님의 프로필 이미지
      warna97725274

      Reviews 13

      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!

    Hong's other courses

    Check out other courses by the instructor!

    Similar courses

    Explore other courses in the same field!