Real MySQL Season 1 - Part 1

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.

Learn database design systematically through three stages: conceptual, logical, and physical, and strengthen your capabilities with a practical shopping mall project. Acquire real-world expertise through modern design techniques and the latest trends.

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

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

I am covering the know-how on how I studied and got a job, starting as a non-major.

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.

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

This course implements a bulletin board CRUD using Spine, following the entire process from start to finish to see exactly which rules and sequences Spine uses to execute requests and complete responses. Based on Spine's core Execution Pipeline, we will examine the entire request lifecycle without omission: Routing (Handler selection) → Argument Resolution (Argument Resolver) → Controller Invocation (Invoker) → Return Value Processing (ReturnValue Handler). The focus is not on building features quickly. Instead, by directly tracing questions like "When is this logic executed?" and "Who is responsible for this step?" within Spine's architecture, you will develop the intuition to explain and control the execution flow. We also cover how cross-cutting concerns, such as logging, are separated from the controller and integrated into the execution flow (Interceptor). By the end of the bulletin board example, you will have gained something more important than just building CRUD with Spine: the criteria to determine where to attach specific features based on Spine's execution model. This is not just a simple CRUD course; it is the essential first course to truly getting started with Spine.

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.

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.

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.

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.

A smooth-flowing guide to Express.js, from basics to real-world application! A backend journey to truly master everything from basic server concepts to completing a CRUD project through hands-on implementation.

Spring AI + JPA + MySQL Premium Reservation Agent Backend Development with 'Autonomous Behavior' Beyond Chatbots to Agents: The Definitive Guide to Tool Calling and Prompt Engineering

This lecture comprehensively organizes the content that would be good for those who want to get a job as a new Spring Java backend developer, especially those who are about to have an interview.

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.

Beyond the basics of API design, CRUD implementation, and JWT authentication, all the way to backend architecture design! This is an introductory system design course to help you create 'your own backend architecture' so you can confidently discuss design experience in interviews.

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.

This course teaches you how to implement modern web applications that combine the accessibility of the web with the excellent information management capabilities of a database by linking PHP and MySQL.