Real MySQL Season 1 - Part 2

You can learn about the core functions of MySQL and how to effectively use them in your work. You can also gain a new understanding of important parts that you have been using for a long time and have overlooked, and gain in-depth database knowledge.

We covered the concepts considered while migrating 20 billion data items managed through the existing MongoDB to MySQL.

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.

Make the most of relational database systems!

Not only developers, but also planners and data analysts learn databases step-by-step, starting from SQL basics.

In this lecture, we aim to create a Web Scraping API server using the Naver Shopping site. We will show you how to configure a managed API server by connecting MySQL and configuring a 3-tier architecture!!

By implementing various practical data analysis cases using SQL, you can simultaneously improve your data analysis and SQL utilization skills.

You may have felt frustrated using Redis without being able to explain why it should be designed that way or why certain patterns emerged. Through my experience in both practical development and as an interviewer, I have treated Redis not just as a simple cache, but as a core component that determines service stability and scalability. This course is not about memorizing commands; instead, I will share my experiences on which structures to choose in real traffic environments and their trade-offs, helping you establish the criteria to explain these concepts confidently in both interviews and practical work.

I have summarized the essential SQL SELECT statements and basic usage of Google Sheets that I learned while working as an analyst at a service company.

Introduction to SQL Data Analysis! Quick and easy to understand with practical problem solving!

Learn how to analyze 5 million Korean apartment transaction data using PostgreSQL. Covers the process of data cleaning, transformation, and deriving meaningful insights through various SQL queries.

We enable you to fundamentally understand and resolve issues where Hangeul appears broken on web pages or in databases, or files contain unknown characters.

This is a course for learning MS-SQL through baseball and corporate databases.

An AI system that grades and reviews your code in 5 seconds - imagination becomes reality. This course is an all-in-one project that builds a **'GitHub PR Automatic Analysis and Grading Bot'** using Spring AI. When a student submits an assignment (Pull Request), the server detects it and AI analyzes the code changes (Diff). The grading results are then stored in the database, feedback is automatically posted as GitHub comments, and students can check their results on a dedicated dashboard. From backend to AI integration and frontend (Vaadin) - all with Java! This is the ultimate introductory guide for all developers who want to complete their own AI service from A to Z.

Learn common components of global-scale services through popular papers, books, and articles.

This course proceeds in stages, similar to the actual work, by learning and applying the necessary knowledge while configuring the infrastructure.

A practical course on easily building a super simple bulletin board with Spring Boot and React.js! This course focuses less on theory and more on hands-on practice, covering the web application development process for quick completion.

I have created a course titled 'Introduction to Redis/Practical Application (Query Performance Optimization Edition)' that is easy for non-majors to understand and can be applied immediately in practice!

This lecture covers how to easily implement game backend systems using UGS (Unity Gaming Service). You will practice essential features such as Guest and Username/Password authentication, game data storage, leaderboards, and Remote Config. UGS has built a perfect ecosystem with Unity, preparing a practical course for easy learning without entry barriers, allowing immediate application to your projects.

Immutable truths for developers/engineers that will never change even in the AI era! We provide essential computer science knowledge for free to prepare for developer/engineer job applications and technical interviews.