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.

You can master Database development, which is essential for mobile/web development, through MySQL.

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

[Web Dev Beginners Only] Build a Spring Boot REST API easily, step-by-step, fully understanding JPA.

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.

You will learn about what a node is, the latest JavaScript grammar, the node API, npm, the module system, databases, testing, and more. You will create a project using five practical examples. You will also deploy a service to the cloud and convert a node project to TypeScript.

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.

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.

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

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

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

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.

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.

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 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.

Technology should also start with interest. I have prepared a story about a person who analyzes MBTI of his coworkers. I hope that those who have been daunted by SQL will start studying it with enjoyment.

The SQLD Latest Past Exam Problem Solving Course is a practical preparation lecture that reflects the 2024 revised exam standards and is based on actual past exam questions. Going beyond simply checking answers, it meticulously covers the question's intent, key testing points, and common pitfalls, developing practical problem-solving skills for SQLD certification success.

This is a course on creating a practical Unity game with a database. You can learn through lectures about aspects that are difficult to encounter.

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 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.

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