Young-han Kim's Introduction to Practical Databases - SQL First Steps for All IT Professionals (Step-by-Step from SQL)

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.

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.

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

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.

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.

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

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

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.

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.

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.

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 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 learn the core principles and advanced technologies of Spring in depth and be able to use Spring confidently.

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

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

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.

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.

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.

How will you handle exploding traffic? Learn how to build resilient and flexibly scalable architectures through practical EDA (Event-Driven Architecture) design patterns using Kafka, Spring, CDC, and Temporal. A Kakao developer shares real-world experience with clear, easy-to-follow explanations that even non-majors can understand. A practice-oriented course covering everything from real-time data flow and event processing to microservice integration!

Make the most of relational database systems!

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.

You can learn about JWT and ws communication using Spring Boot, and how to handle high TPS.

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!

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

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

A current database expert from a major global company generously shares 20 years of corporate practice and teaching experience!

This is an introductory BigQuery (SQL) course for beginners. I recommend it to those who are curious about how to process data. I will teach SQL from the perspective of data analysis and data engineering, rather than from a backend development perspective.

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.

A practical course on easily building a super simple bulletin board with Spring Boot and React.js! This course focuses less on theory and more on hands-on practice, covering the web application development process for quick completion.

This course proceeds in stages, similar to the actual work, by learning and applying the necessary knowledge while configuring the infrastructure.

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

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

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

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.

What do you learn in the 'Management Information Visualization Professional' certification course? This certification course focuses on developing the ability to analyze data effectively, visualize it for easy understanding, and communicate necessary information clearly and efficiently for important decision-making within companies or organizations. In simple terms, it is a process of learning the skills to not just look at data, but to uncover hidden meanings within it and express them through charts, tables, and graphs so they can be easily explained to others. Through this course, you will: Develop the power of strategic thinking through data, build practical skills that can be applied immediately to real-world tasks, and enhance your professional expertise and competitiveness. Through this lecture, cultivate the ability to connect management with data and take a step forward as an expert who understands and explains data.