MySQL Performance Optimization

Master prompt engineering perfectly, an essential skill for developers in the AI era.

Practical Payment System Development Course, learn by code, and cover the knowledge needed to implement a real system.

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

This is a content about backend development using two databases, MySQL and Mongo, for job seekers preparing for backend employment.

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.

This is a process of creating your own backend API server, using Node-based Strapi v4, without any additional coding, with just a few clicks, and deploying it to AWS EC2. Almost the same can be applied to Strapi v5. Please refer to the lecture A/S as well~

This is an Oracle course, one of the top 3 databases. Even if you are learning databases for the first time, you can easily learn.

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 systematically teaches normalization and denormalization, which are core concepts in database design. Learners will understand the necessity and principles of normalization, and acquire step-by-step knowledge from First Normal Form to Third Normal Form and BCNF normalization techniques. Additionally, they will learn denormalization techniques that are essential considerations in practical database design, and discover actual application methods for performance optimization. Furthermore, learners can understand the essence of NULL values and their operational results, which are important concepts in databases, and examine the concept and characteristics of **Artificial Identifiers** to experience the importance of data integrity and management. Through this course, learners can establish a foundation for solving various problems that may arise during the data modeling process and develop database design capabilities applicable to both theory and practice.

Learn SAGA transaction management techniques for maintaining data consistency in distributed environments through hands-on practice. Build 3 microservices using Spring Boot and Docker, and implement both Orchestration and Choreography patterns with Kafka and MySQL. Through this course, you can master core concepts that are immediately applicable in real-world scenarios, including distributed transaction operation principles, compensating transaction design, and failure recovery handling.

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.

This course will solidify the basics of SQL through various problems that can be encountered in the actual IT industry. Solve the problem-solving quests, take the first step toward data analysis, and strengthen your SQL skills that can be applied in real life!

Inflearn's SQL intermediate course by Datarian, with over 30,000 cumulative students and extensive online/offline teaching experience. Learn intermediate SQL theory and solve 20 practice problems together.

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 🚀

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.

This is a course on creating practical Unity games with databases. It covers topics that are usually difficult to encounter, explained through lectures.

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.

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 common components of global-scale services through popular papers, books, and articles.

This is an introductory BigQuery (SQL) course for beginners. Recommended for those curious about data processing methods. We teach SQL from a data analysis and data engineering perspective rather than a backend development perspective.

From understanding SQL to using actual functions, Complete preparation for SQLD certification with the latest past exam questions!

This course teaches MS-SQL through baseball/company databases.