SQL DBA 60%: Hands-On Operations of Three Database Engines

Through the implementation of a first-come, first-served coupon system, you will solve key real-world backend challenges such as concurrency issues, data consistency, and handling peak traffic. By writing the code yourself, you will identify problems and master essential practical skills, including synchronous/asynchronous processing and queue management. This project-based course is designed to help junior developers and job seekers gain hands-on experience.

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

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.

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.

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

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.

How can you withstand skyrocketing traffic? Learn how to build a resilient and flexibly scalable architecture through practical design patterns based on EDA (Event-Driven Architecture) using Kafka, Spring, CDC, and Temporal. Explained clearly and simply—even for non-majors—alongside the real-world experience of a Kakao developer. A hands-on course covering everything from real-time data flows and event processing to microservice integration!

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.

I'll show you everything about how to build servers for stateful services and how zero-downtime deployment works.

It contains a comprehensive introduction to databases, the heart of information technology. We study the essence of databases and learn about MYSQL, the most representative relational database.

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

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

★.NET 8.0★ This is a basic Windows Desktop development course using WinForms. Learn how to easily perform DB CRUD operations using EntityFrameworkCore. I will teach you class design methods based on loose coupling and the "basics" of Form UI Design. The source code used in the lecture is also provided :)

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.

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.

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.