Kim Young-han’s Practical Database – Fundamentals Edition

Learn database design systematically across three levels—conceptual, logical, and physical—and strengthen your skills through a practical, project-based e-commerce store. Gain hands-on expertise through modern design techniques and the latest trends.

Solve the common codes, category hierarchies, history tracking, soft deletes, statistics, dynamic design, JSON utilization, and more that you inevitably encounter in real-world design through nine core patterns. This goes beyond simple theory, incorporating practical know-how proven across numerous projects and criteria for making the right choices in different situations. Become a true design expert who can confidently design for any requirement.

For learners struggling with large-scale data analysis and slow queries, I provide practical, hands-on guidance from design through tuning.

A beginner's guide to SQL coding! We'll teach you the secrets of writing, interpreting, and validating SQL.

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

This course covers how to set up multi-module projects from scratch using Kotlin and Spring Boot. It proceeds with a hands-on approach, covering everything from the basic concepts of modularization to Gradle configuration, managing dependencies between modules, and actual application development. If you are a beginner or intermediate developer looking to learn the fundamentals and practical application of multi-modules, please refer to this course.

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.

Starting from installing MariaDB and understanding its structure, you will learn step-by-step from writing SQL queries and utilizing functions to joins and subqueries. You will master core practical features such as table design, performance management, backup, and recovery through hands-on practice, completing the practical skills necessary for database development and operation.

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

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.

This course goes beyond basic CRUD-level database usage, helping you develop the PostgreSQL skills needed in the AI era from a practical, real-world perspective. Drawing on AI development experience in Silicon Valley, you’ll gradually learn how to design and use JSON, indexes, transactions, and pgvector in actual services, while gaining the skills to solve complex data structure and performance problems.

SQLD, where should I start? For those of you feeling completely overwhelmed, this is the lecture for you. You will meet a transformed version of yourself after completing the course. SQLD All-in-One Pass!

Perfect preparation for the SQLD certification, from understanding SQL to practical function application, finishing with the latest exam questions!

Does game backend development feel daunting and vague? With know-how gained from firsthand experience with numerous projects, I will show you how to perfectly integrate complex Firebase features into actual games. We will connect Firebase to a Unity 6 Watermelon Game to implement online features such as login, cloud database (Firestore) save/load, rankings, bulletin boards, and mailboxes. This is a practical course that also covers security rules, Remote Config operations, and code design based on a layered architecture (UI, logic, and data access).

From the fundamentals of MySQL usage to the advanced techniques required in real-world service environments, you will learn progressively. The course also covers a wide range of topics, including data modeling techniques based on various cases and practical data, evaluating the effectiveness of Foreign Key design, analyzing the Google Calendar schema DDL, and modern DDL design principles. It provides an in-depth understanding of how to use MySQL as a core component of a system, rather than merely as a database.

This course teaches you how to build a practical Unity game with a database. It covers difficult-to-access topics in an easy-to-follow lecture format.

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 🚀

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.

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

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