SQL tuning for immediate use in business

This course teaches you how to write performance-conscious queries during the SQL development phase, guided by a SQL Server expert. You can learn the basics for meeting query performance requirements along with practical case studies.

By solving Leetcode SQL problems, you can understand problem types and improve your SQL implementation skills in a short period of time.

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

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.

Make the most of relational database systems!

Let's edit and process the countless data generated through public services to build our own database, and discover another hidden world through a series of tasks that occur in the process and by utilizing SQL.

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.

[Newbies to Web Development Only] Let's Build a Spring Boot REST API Step-by-Step, the Easy Way

This is a practical backend course designed to cultivate the service planning and design thinking skills that developers need in the AI era.

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 on creating a practical Unity game with a database. You can learn through lectures about aspects that are difficult to encounter.

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

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.

If you can master DB and programming, you should be more than halfway prepared for the information processing engineer exam. Let's take a look at the DB and programming parts, which are worth 45 to 55 points in the practical exam, and pass the written exam steadily.

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.

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 🚀

I've created a 'Redis Beginner/Practical (Query Performance Optimization)' course that's easy to understand even for non-majors and can be applied immediately in real-world situations!

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

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.