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

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.

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

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

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

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

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

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

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.

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.

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.

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

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

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.

Spring Data JPA goes beyond the limitations of the past and allows you to complete development with just an interface, without implementing classes in the repository, as if by magic. It also provides all the basic CRUD functions that have been developed repeatedly. We will share practical know-how on Spring Data JPA.

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.

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

Solve everything from the basics of querydsl to practical use all at once!

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

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.

You can solve design problems by writing code in a formatted way. You can understand code or patterns written by other programmers.

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

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.

Let's build a project using Ktor, the most popular project in Kotlin, and master Kotlin! 😆

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.

This course aims to overcome the technical limitations practitioners face in vast big data environments and to build systematic data management capabilities through the Hadoop ecosystem. Through this course, students will gain the following core values: Practical Problem Solving: Understand the limitations of existing systems as data scales and learn efficient distributed processing methods using Hadoop. Ensuring Data Stability: Learn practical optimization techniques to safely protect original data through Hive's external table design, even if a table is accidentally deleted. Maximizing Analysis Efficiency: Acquire expert-level skills to freely control and analyze large-scale data using HiveQL without complex programming. Expert Guidance: A knowledge sharer with years of IT education experience and know-how will directly pass on practical skills that can be applied immediately in the field. Join this 30-lecture journey that will transform you into a distinguished data engineer in the massive wave of big data.

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

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

Just listen. The lecturing skill, captivating power, and lecture quality are different.

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.

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

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.

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

Learn the SAGA transaction management technique for maintaining data consistency in distributed environments through a hands-on approach. You will configure three microservices using Spring Boot and Docker, and implement both Orchestration and Choreography patterns using Kafka and MySQL. Through this course, you will master core concepts applicable to real-world scenarios, including the operational principles of distributed transactions, designing compensating transactions, and handling fault recovery.

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.

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