강의

챌린지

멘토링

로드맵

커뮤니티

MySQL by a Kakao interviewer handling 10,000++ hundred million units of data

From the fundamentals of MySQL usage to the advanced techniques required in real-world service environments, you will learn progressively. The course also covers a wide range of topics, including data modeling techniques based on various cases and practical data, evaluating the effectiveness of Foreign Key design, analyzing the Google Calendar schema DDL, and modern DDL design principles. It provides an in-depth understanding of how to use MySQL as a core component of a system, rather than merely as a database.

(4.8) 29 reviews

481 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 commonly used in industry and relational structure optimization techniques

  • Integrity and Performance Management Strategies Using Foreign Key, Index, and Transaction

  • Service-Oriented DDL Design and Schema Structure Analysis Using Google Calendar as a Case Study

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

Recommended for
these people

Who is this course right for?

  • A backend developer who wants to move beyond simply writing queries and design data structures.

  • An engineer who wants to deeply understand the SQL mechanics behind an ORM

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

  • Entry-level and junior developers who want to build practical schema design standards and modeling experience

  • A technical leader interested in building scalable data infrastructure centered around MySQL

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

45 lectures ∙ (11hr 36min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

29 reviews

4.8

29 reviews

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

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

    • byeongseogi492130님의 프로필 이미지
      byeongseogi492130

      Reviews 10

      ∙

      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!