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.

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

'Complete Mastery of Practical SQL in 49 Sessions II - Advanced Course' follows the basic course. By using a practical database for learning, you can apply it right away in the field, and it is structured so that you can fully learn the learning content through theoretical explanations, practice, and solving a total of 200 application problems.

Make the most of relational database systems!

This course focuses on building the real skills needed in actual development work. The goal is not simply to learn how to write code well, but to experience how to work well as a developer. The examples are based on the commerce domain, covering cases frequently encountered in real-world work environments, and are provided in SpringBoot & Kotlin. However, it's a course where anyone can contemplate and experience real-world development through thought-provoking content, without being dependent on any specific language or framework. Based on the practical perspective of a senior developer and former director at Toss Payments who led a large-scale payment service organization, the course is designed to help you learn the thought processes and design decisions used in actual work environments.

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.

You will be able to extract the data you want directly without the help of a developer. We will comfortably cover everything needed for analysis, from simple queries to joins. Start learning SQL with a lecture directly from the author of the book <SQL for Product Managers>.

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.

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

" · Understand the definition of SQLD and its exam subjects and scoring. · Install Oracle XE version directly. · Install SqlDeveloper directly."

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 how to save, modify, delete, and query data in a database. Anyone, regardless of major, can easily follow along in just 30 minutes.

Immutable truths for developers/engineers that will never change even in the AI era! We provide essential computer science knowledge for free to prepare for developer/engineer job applications and technical interviews.

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

Channel Talk interviewers will directly analyze the difference between failing and passing answers to the same questions, and help you prepare for actual follow-up questions.

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

This is a course for learning MS-SQL through baseball and corporate databases.

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 🚀

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

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.