Young-han Kim's Practical Database - Design Part 2, 9 Design Patterns You Must Encounter in Practice

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

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

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

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

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

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

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

"A query that ran perfectly during development suddenly slows down as data accumulates." At such times, the mark of a truly skilled developer is identifying the root cause based on solid evidence rather than guesswork, and optimizing a 30-second query down to 0.1 seconds. Master the core principles of database performance—from execution plans, indexes, and optimizers to joins and sorting—using millions of rows of real-world data. Elevate your skills and become a top-tier developer capable of independently analyzing and resolving slow queries in production environments.

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

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 Java generics and collection frameworks in depth with a focus on practical applications. Also learn the basics of data structures.

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.

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.

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.

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

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

You will learn the core principles and advanced technologies of Spring in depth and be able to use Spring confidently.

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.

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.

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

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

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

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.

A guide to the exam for nationally recognized SQL qualifications! Establish a comprehensive knowledge system related to SQL.

Through the implementation of a first-come, first-served coupon system, you will solve key real-world backend challenges such as concurrency issues, data consistency, and handling peak traffic. By writing the code yourself, you will identify problems and master essential practical skills, including synchronous/asynchronous processing and queue management. This project-based course is designed to help junior developers and job seekers gain hands-on experience.

Train your SQL querying skills through 50 diverse problems and prepare for real-world analysis environments and coding tests. * If you are new to SQL, it is recommended to take the SQL [Concepts Class] first to follow along smoothly.

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

"SQLD is an exam where past questions are not released." In preparation for the upcoming 62nd exam (2026.08.22)- Practical materials featuring 50 questions per subject and chapter, vividly reconstructed by directly recalling the latest 61st exam!

Train your SQL querying skills through 50 diverse problems and prepare for real-world analysis environments and coding tests. * If you are new to SQL, it is recommended to take the SQL [Concepts Class] first to follow along smoothly.

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!

For those feeling overwhelmed by SQLD exam preparation, this is a standard course that analyzes the entire scope of the "Yellow Book," organizes the necessary theories through practice-oriented lessons, and solves every single problem. With short, concise clips and a topic-based structure, you can build the practical skills needed to succeed on the actual exam.

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.

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

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!

This course aims to obtain the state-certified SQLD (SQL Developer) certification. An SQLD refers to a developer who can write accurate SQL to manipulate and extract data while developing application software based on knowledge of databases and data modeling.

Beyond the basics of API design, CRUD implementation, and JWT authentication, all the way to backend architecture design! This is an introductory system design course to help you create 'your own backend architecture' so you can confidently discuss design experience in interviews.

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.