Young-han Kim's Practical Database - Basic Course

Solve the challenges you inevitably face in real-world design—such as common codes, category hierarchies, history tracking, soft deletes, statistics, dynamic design, and JSON utilization—with 9 core patterns. This is not just simple theory; it contains practical know-how and selection criteria for various scenarios, proven across numerous projects. Now, become a true design expert who can confidently handle any requirement that comes your way.

Not only developers, but also planners and data analysts learn databases step-by-step, starting from the basics of SQL.

Spring beginners can grasp core principles and solidify basics via examples.

You will systematically learn database design through three stages—conceptual, logical, and physical—and strengthen your skills through a practical shopping mall project. Gain real-world know-how through modern design techniques and the latest trends.

Learn practical core Java object-oriented concepts easily via example code.

With a practical example, we will design and develop a web application using Spring Boot and JPA. Through this process, you will understand how to use Spring Boot and JPA in practice.

Beginners to Spring can quickly learn the entire Spring web application development process by creating examples.

This book provides an in-depth study of various intermediate-level Java features necessary for practical work, using example code.

This is a Java course for those who are new to programming. You can easily learn Java by following along with the code.

This course provides an in-depth study of multithreading and concurrency, from basic principles to practical applications.

Learn Java generics and collection frameworks in depth with a focus on practical applications. Also learn the basics of data structures.

You can understand and master all the web technologies required to develop web applications from the basics. You can understand the core principles and structure of Spring MVC and grow into a more in-depth backend developer.

Learn the core HTTP features essential for practical use and how to design proper HTTP APIs.

Learn I/O, networking, reflection, and annotations in depth, from the basics to the practical level. Build a web application server (WAS) directly in Java.

Learn the essential modern Java technologies of Lambda, Stream, and functional programming with Java, from the basics to the practical level, in depth.

You can utilize and implement the database data access technologies required for backend development. You will understand the principles and structure of Spring DB access technologies and grow into a more in-depth backend developer.

This course will cover everything you need to know about Spring Boot for practical use.

You can understand all the web technologies required for web application development from the basics and complete your learning. In MVC Part 2, you can learn all the practical application techniques needed for real-world web development, building upon the core principles and structures from MVC Part 1.

Develop APIs using Spring Boot and JPA. And learn how to optimize JPA's extreme performance.

You can understand and perfect the basics of DB data access technology required for backend development. You can understand the principles and structure of Spring DB access technology and grow into a more in-depth backend developer.

You will systematically learn database design through three stages—conceptual, logical, and physical—and strengthen your skills through a practical shopping mall project. Gain real-world know-how through modern design techniques and the latest trends.

Solve the challenges you inevitably face in real-world design—such as common codes, category hierarchies, history tracking, soft deletes, statistics, dynamic design, and JSON utilization—with 9 core patterns. This is not just simple theory; it contains practical know-how and selection criteria for various scenarios, proven across numerous projects. Now, become a true design expert who can confidently handle any requirement that comes your way.

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

Extract and utilize data through Oracle 18c and become a database expert!

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

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.

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

This lecture comprehensively organizes the content that would be good for those who want to get a job as a new Spring Java backend developer, especially those who are about to have an interview.

This course focuses on building the real skills needed in actual development work. The goal is not simply to learn how to write code well, but to experience how to work well as a developer. The examples are based on the commerce domain, covering cases frequently encountered in real-world work environments, and are provided in SpringBoot & Kotlin. However, it's a course where anyone can contemplate and experience real-world development through thought-provoking content, without being dependent on any specific language or framework. Based on the practical perspective of a senior developer and former director at Toss Payments who led a large-scale payment service organization, the course is designed to help you learn the thought processes and design decisions used in actual work environments.

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

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!

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 🚀

"SQLD is an exam where past questions are not officially released." Preparing for the upcoming 60th exam (2026.3.7)— Practical study material featuring 50 vividly reconstructed questions by subject and chapter, based on the latest 59th exam!

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

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

This is a course aimed at obtaining the nationally recognized SQLD certification, and SQLD refers to developers who can write accurate SQL for manipulating and extracting data while developing application software based on database and data modeling knowledge.

This course teaches you how to implement modern web applications that combine the accessibility of the web with the excellent information management capabilities of a database by linking PHP and MySQL.

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.

"SQLD is an exam where past questions are not officially released." In preparation for the upcoming 61st exam (May 31, 2026)— Practical materials featuring 50 questions per subject and chapter, vividly reconstructed by directly recalling the latest 60th exam!