SQL tuning for immediate use in business

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!

Learn how to model data in a distributed database environment.

Learn Oracle Database SQL syntax.

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

If you ask an AI to "get the top 10 sales," it will whip up a plausible-looking query in no time. However, to determine if that query is actually correct, if the results of joining three tables are accurate, or if it's performing a full scan on 500,000 records without an index—you ultimately need a foundation in DB basics. This course doesn't cover anything overly difficult. In just 2 hours, you will learn the entire flow of SQL by coding along, covering exactly what you need to know before giving instructions to an AI. By the end of this lecture, you will no longer feel uneasy when faced with a query generated by AI.

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.

In this lecture, we aim to create a Web Scraping API server using the Naver Shopping site. We will show you how to configure a managed API server by connecting MySQL and configuring a 3-tier architecture!!

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.

A must-have subject for aspiring developers and those looking to get a job in big data!!

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

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.

Perfect preparation for the SQLD certification, from understanding SQL to practical function application, finishing with the latest 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.

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

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

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.