Kim Young-han’s Practical Database – Part 1: Design, Mastering Modern Data Modeling in Full

Learn the essential fundamentals of SQL and databases needed for practical work. Not only developers, but also planners and data analysts will learn SQL in depth.

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.

Learn how to model data in a distributed database environment.

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

Systematically learn the distributed NoSQL database Cassandra, from basic concepts to practical application. Develop high-volume data processing capabilities through practice-oriented theory and hands-on exercises, including data modeling, query optimization, and cluster configuration. Even without prior database experience, you can grow into a Cassandra expert based on the know-how of a current Silicon Valley developer.

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 🚀

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

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

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

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.

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

This course proceeds in stages where you learn and apply necessary knowledge while building infrastructure, similar to real-world practice.

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

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.

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 special lecture that can lay the theoretical foundation to simultaneously prepare for the Microsoft AZ-900 certification, and as the latest content reflecting the scope of questions as of May 2025, by providing content related to core data concepts, Azure's relational data, Azure's non-relational data, and Azure's analytical workloads in a form combining theory and practice, it can be utilized as a meaningful educational opportunity to not only obtain the certification but also take the first step towards becoming a data professional.

Knowledge Graph-based RAG System Implemented with Neo4J: Next-Generation Search Technology Utilizing Data Relationships Beyond Simple Vector Search Maximizing RAG Performance with the Power of Graph Databases!

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.

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.

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!