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.

sherlockpeter6230153

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.

jhong

얼리버드 할인

MySQL for Hundreds of Millions of Platform Data: Insights from a Kakao Interviewer

Hello Gyumin Hwang, thank you for leaving a review. I personally put a lot of thought into which perspectives to share and how to deliver them... and because of those concerns, I feel like the lecture itself might be a bit disorganized ㅠㅠ 

However, I can truly guarantee that it will be very helpful if you take it step by step, so thank you so much for giving me strength with such a thoughtful review!!

Have a great day!

실습 중심

backend basics

백엔드이해하기

데이터베이스

MySql

mysql

데이터베이스 관리 시스템

DBMS/RDBMS

Hong

입문

초급

중급이상

MySQL

Data Engineering

backend

Course Introduction

MySQL Basics for Everyone

Why you should use MySQL: JOIN

Various SQL anti-patterns to avoid

Data modeling techniques learned through numerous examples

Data Modeling Explained with Google Calendar Examples

Foreign Keys and the Strategy Pattern

MySQL Advanced Topics