The Complete Guide to Production Databases for Large-Scale E-Commerce DBAs — Learn Zero-Downtime Operations by Reproducing MySQL Failures

We will inform you about all the security aspects of migration using MySQL and direct operation of DB Server.

After learning SQL tuning, automate recurring tuning tasks. This hands-on project connects everything from collecting MySQL queries to AI diagnosis, empirical validation, handoff to the person in charge, and tracking recurrence.

Why do requests wait when queries are fast? Locks. In a hands-on project using MySQL 8.0, Spring Boot, and JPA, reproduce record and gap locks, four types of deadlocks, long transactions and connection pool exhaustion, metadata locks during deployment, and lost updates with tests. Then fix them in code and verify the fixes with the same tests.

This course covers how to set up multi-module projects from scratch using Kotlin and Spring Boot. It proceeds with a hands-on approach, covering everything from the basic concepts of modularization to Gradle configuration, managing dependencies between modules, and actual application development. If you are a beginner or intermediate developer looking to learn the fundamentals and practical application of multi-modules, please refer to this course.

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

Complete an entire cycle of backend service development using Spring Boot, MySQL, Docker, AWS EC2, and RDS. Gain a sense of achievement by deploying an application, and explore the problems server developers face in the field when developing APIs, along with their solutions.

Just listen. The lecturing skill, captivating power, and lecture quality are different.

This course focuses more on data modeling through entity design than on JPA technical explanations. Based on the principle that solid DB design is the foundation of application development, we analyze various design patterns—such as one-to-many, many-to-many, inheritance, and collections—alongside business scenarios. You will learn by directly observing the process of code being transformed into actual tables on screen. To ensure immediate practical application, we provide business use cases, source code, and test codes for each design pattern.

This course is designed to help students learn and practice PHP programming concepts. It is designed for students who want to learn PHP programming concepts.

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.

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 course goes beyond basic CRUD-level database usage, helping you develop the PostgreSQL skills needed in the AI era from a practical, real-world perspective. Drawing on AI development experience in Silicon Valley, you’ll gradually learn how to design and use JSON, indexes, transactions, and pgvector in actual services, while gaining the skills to solve complex data structure and performance problems.

Let's learn together about Columnar Storage, which allows you to conveniently handle both structured and unstructured data provided by GCP and allows for a free table format, and BigQuery, a universal database.

From Docker fundamentals to service deployment and operations, Yalco explains everything using easy analogies and illustrations. Build an image with the provided bulletin board app, then use Compose to connect the app, MySQL, and Nginx. Practice firsthand how to preserve data even when replacing containers, as well as backup and restoration, updates, and rollbacks. You’ll also learn how to automate image builds and checks with GitHub Actions.

Inflearn cumulative students over 30,000, Datarian's SQL basics course with rich online/offline teaching experience. Learn SQL basic theory and solve 10 SQL problems together.

This course is designed for those who are new to Debezium-based CDC and unsure where to begin. You will gain hands-on experience with the entire process of collecting MySQL change data in real time via Kafka and delivering it to PostgreSQL. By learning everything from the basic principles of CDC to configuration and operational best practices, you will be able to build real-time data pipelines on your own.

Drawing from my own experience of feeling despondent when trying to implement practical code during my first MSA transition—despite knowing the theory—I will help you grow into a developer who guarantees perfect data consistency amidst any system failure by directly rolling back daunting compensation logic through 9-step practical patterns and AI Agent coding.

This is a full-stack restaurant map tutorial that allows you to learn everything from front-end, back-end, Kakao Map API usage, and deployment all at once while creating a restaurant map of your favorite YouTuber.

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.

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.