MySQL Performance Optimization Intro/Practice for Non-Majors (SQL Tuning Edition)

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!

I have created a 'DB Design Introduction/Practice' course that is easy for non-majors to understand and can be applied immediately in the real world!

Make the most of relational database systems!

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

I have created a 'Redis Intermediate/Practical' course that is easy for non-majors to understand and can be applied immediately in real-world scenarios!

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.

Secrets of people who are good at their jobs! How should I start with SQL? It covers everything from SQL installation and basic environment configuration to simple practical exercises that can be used in real life! You can also learn basic commands step by step through practical exercises.

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.

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.

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.

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

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

Perfect preparation for the SQLD certification, from understanding SQL to practical function application, finishing with the latest exam questions!

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.

Does game backend development feel daunting and vague? With know-how gained from firsthand experience with numerous projects, I will show you how to perfectly integrate complex Firebase features into actual games. We will connect Firebase to a Unity 6 Watermelon Game to implement online features such as login, cloud database (Firestore) save/load, rankings, bulletin boards, and mailboxes. This is a practical course that also covers security rules, Remote Config operations, and code design based on a layered architecture (UI, logic, and data access).

This is an introductory BigQuery (SQL) course for beginners. I recommend it to those who are curious about how to process data. I will teach SQL from the perspective of data analysis and data engineering, rather than from a backend development perspective.

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.

Learn how modern data teams leverage dbt. Build maintainable analytics models and validated data pipelines hands-on. Master core concepts of analytics engineering with a practical focus. This course is for those who want to take their data career to the next level 🚀