Practice! Querydsl

hello everyone

Finally, the two lectures on database introduction and basics are ready to open.

Thank you for waiting and supporting us for a long time!

The release date is expected to be between July 30th and August 1st.

Kim Young-han's Practical Database Roadmap

1. Kim Young-han's Practical Database Introduction - Step by Step from SQL (Open)

2. Kim Young-han's Practical Database - Basics (Open)

3. Kim Young-han's Practical Database - Design (Scheduled for the second half of 2025)

4. Kim Young-han's Practical Database - Performance Optimization and Advanced Features (Scheduled for the second half of 2025)

Lecture target

Please note that this lecture has been designed to be easy to understand for not only developers but also planners and data analysts.

• Developer : Juniors, non-majors, job seekers who want to build a solid foundation in database fundamentals

• Planners/Marketers : Those who need data-driven decision making

• Data Analyst : Beginners who want to build their SQL skills

[Introduction to the roadmap from a developer's perspective]

If you are a developer, I recommend following the entire roadmap.

As many developers will agree, great applications are born on top of well-designed databases. This is because there are problems in the database area that can never be solved with application code alone. This roadmap will fill in the remaining half of the core competencies and make you a higher-level developer.

Introduction : First, we will cover the basics of databases and SQL through the 'Introduction'.

Basics : The Basics covers the basic database skills that are essential for junior developers.

• You will gain the ability to solve any complex business requirement in SQL using joins, subqueries, unions, and case statements.

• By properly understanding the operating principles of indexes, you will learn the fundamentals of SQL performance optimization essential for practical use.

• A deep understanding of transactions and data integrity enables you to build robust applications that don't corrupt data.

Design : The design section will help you become a developer at the next level. You will learn how good database design determines the maintainability and scalability of applications, and develop the ability to systematically model complex requirements that you will encounter in practice.

Performance Optimization and Advanced Features: Performance Optimization and Advanced Features is the final gateway to becoming an advanced developer handling high-volume traffic. You will master advanced techniques to find database performance bottlenecks that no one else can solve and push the limits of your services.

By mastering this roadmap, you will grow beyond being a “simple developer who implements features” to a truly capable developer who deeply understands and optimizes both the application and the database, and can find a solution to any problem.

[Introducing the roadmap from a planning and data analyst perspective]

If you are a planner or data analyst, I recommend listening to the introductory and basic versions.

Getting Started: Once you master the fundamentals of SQL with Getting Started, you'll have the speed and independence to get the answers you need immediately, without having to request data and wait.

Basics : In the Basics, we go one step further.

By using advanced SQL such as joins, subqueries, unions, and case statements, you can combine data scattered in various places, reprocess it according to your own criteria, and add depth to your analysis.

These two courses alone will transform you into a key player who can improve services based on data, persuade organizations, and communicate smoothly with development teams.

If you want to lead a data-based product yourself, it may be a good idea to take the 'Design' course as an advanced course to broaden your understanding of data structures.

For planners and analysts, this introductory and fundamentals roadmap will completely change the way you work with data.

Introduction - Section Table of Contents

1. Lecture introduction and teaching materials

2. Introduction to the database

3. Start the database

4. SQL - Data Management

5. SQL - Query and Sorting

6. SQL - Data Processing

7. SQL - Aggregation and Grouping

Basics - Section Table of Contents

1. Lecture introduction and teaching materials

2. Join 1 - Inner Join

3. Join 2 - Outer Join and Other Joins

4. Subquery

5. UNION

6. CASE statement

7. View

8. Index 1

9. Index 2

10. Data Integrity

11. Transaction

12. Stored Procedures, Functions, and Triggers

We've compiled and answered questions about the roadmap's progress.

1. Basic order of database roadmap progress

- The basic order is Java -> Database -> Spring -> Spring Boot and JPA utilization.

2. Recommended order of database roadmap progress

The most effective progression is to study the Introduction to Databases and the Fundamentals right before Spring DB1 on the Spring roadmap.

So, the learning process is as follows:

- ...

- Spring MVC2

- Introduction to Databases

- Database Basics

- Spring DB Part 1

- Spring DB Part 2

- ...

When proceeding with the roadmap for utilizing Spring Boot and JPA, it is recommended that you listen to at least the database basics and proceed.

We will provide a more comprehensive overview of database design, performance optimization, and advanced features once they are released.

3. Are you going to learn based on MySQL? Or on Oracle?

Although the practical training focuses on MySQL, the lecture content focuses on imparting general knowledge that covers not only MySQL but also the entire RDBMS. Therefore, the goal is to gain a broad understanding that is not tied to a specific database.

To use an analogy, in this lecture we will learn how to drive a car called MySQL. However, we will not simply learn how to operate a specific model of car, but will focus on learning the basic driving principles (core concepts of RDBMS) that you need to know no matter what car (RDBMS) you drive, such as the accelerator, brake, and steering wheel. So it will be of great help when dealing with other RDBMS.

thank you