Kim Young-han's Practical Database - Performance Optimization, Complete Mastery of Execution Plans and Indexes

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.

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

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

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

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.

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

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

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

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

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 core HTTP features essential for practical use and how to design proper HTTP APIs.

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.

For those who are new to JPA or who use JPA in practice but lack basic theory, By learning the basic theory of JPA solidly, even beginners can confidently use JPA in practice.

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.

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

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.

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

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.

Let's edit and process the countless data generated through public services to build our own database, and discover another hidden world through a series of tasks that occur in the process and by utilizing SQL.

This course will solidify the basics of SQL through various problems that can be encountered in the actual IT industry. Solve the problem-solving quests, take the first step toward data analysis, and strengthen your SQL skills that can be applied in real life!

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 the fundamentals of SQL and databases essential for practical work. Not only developers, but also planners and data analysts can learn SQL in depth.

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

"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!

"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!

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!

We will learn how to create a system to support large amounts of data and traffic by creating it directly with Spring Boot.

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

With the arrival of the AI era, the skills required of developers are becoming increasingly complex. You might have thought, "I just need to be good at frontend," but when you try to create your own service or integrate AI features, you eventually hit a massive wall called the backend. However, as you try to start backend development, are you overwhelmed by how much there is to learn—from database design and authentication (Auth) to storage management and complex infrastructure setup? Now, you can lay down that heavy burden. In this course, we use Supabase, which solves all these backend functions at once. We will guide you through the fastest shortcut to becoming a full-stack developer who can "instantly" complete a backend without complex server knowledge and bring ideas to life immediately.

This is a process of creating your own backend API server, using Node-based Strapi v4, without any additional coding, with just a few clicks, and deploying it to AWS EC2. Almost the same can be applied to Strapi v5. Please refer to the lecture A/S as well~

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.

In this course, we will practice step-by-step how to use React and FastAPI to implement social features such as real-time voting, comments, and likes, as well as how to monetize by integrating payment systems (Kakao Pay, Toss Pay, etc.).

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!

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 🚀

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

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.