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.

We would like to provide an opportunity to learn SQL, a language used in relational databases, in general. In particular, we wrote the execution examples in the ORACLE environment. The learning content is largely divided into 2 parts and a total of 11 lectures. After learning the entire content, you can cultivate the ability to perform tasks in a database along with the general knowledge of SQL, and you can also prepare for the nationally certified SQL developer qualification.

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

Learn how to model data in a distributed database environment.

SQL data analysis! We will teach you how to solve practical problems that are applicable in the field, quickly and easily!

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.

You will be able to extract the data you want directly without the help of a developer. We will provide everything you need for analysis, from simple queries to joins. Start learning SQL with a direct lecture from the author of the book <Planner's SQL>.

This course is designed to help you learn the core functions of FastAPI, as well as the entire process of web service development. Through this course, we will help you become a FastAPI expert developer needed in the field.

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

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

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

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

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

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

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.

I have created a course called 'Introduction to Redis & Practical Application (Query Performance Optimization)' that is easy for non-majors to understand and can be applied immediately in practice!

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.

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.