Hello everyone^^!
Finally, the Spring DB Part 2 lecture is ready to open. Thank you for waiting and supporting us for a long time.

The release date is scheduled for next week, between Monday, May 30th and Friday, June 3rd, DB Part 2 will be released^^!

- Course name: Spring DB Part 2 - Data access utilization technology
- Number of lectures: 85 lectures
- Lecture materials PDF: 250 pages
- Lecture material PPT: 173 pages

Please refer to the following for detailed lecture introduction.

Introduction to the course

Completion of backend DB data access technology

To properly develop a backend web application, you need to complete two major axes: HTTP-based MVC and DB-based data access technology. We completed HTTP and Spring MVC in the previous lecture, and now we need to complete the remaining axis, Spring DB data access technology.
Through the Spring DB1 lecture, we have learned the core principles and structure of DB access technology. In this Spring DB2 lecture, we will learn various practical application technologies based on the first part. Part 2 is largely divided into three parts.

Understand various data access technologies
You will learn about various data access technologies that are mainly used in practice, such as JdbcTemplate, MyBatis, JPA, Spring Data JPA, and Querydsl, by gradually developing them through practical examples. Through this process, you will naturally understand why each technology is necessary and the pros and cons of each technology while developing code.

Data access techniques and testing
Data access technology is ultimately used for the purpose of managing data in a database. Therefore, it is necessary to check whether the data access technology can properly store and retrieve data in an actual database. In this lecture, we will explain step-by-step how to conduct tests in a situation where a database is linked.

Deep understanding of Spring transactions
In Spring DB Part 1, we learned about the internal principles of why the transaction function provided by Spring is necessary and how it works.
In this session, we will learn about Spring transactions in great depth and explore practical applications.

* Practical precautions when using transaction AOP
* Various options for Spring transactions
* Exception handling and the internal principles of how Spring transactions are committed and rolled back
* Transaction propagation options and internal workings

Course Objectives

- Objective : The goal of this course is to complete the vast DB data access technology required when developing practical backend applications.
- From basics to practice: There is a lot of content for practical development, but it is organized in stages so that even developers without web application development experience can adapt. Please note that you should listen to Spring DB Part 1 first and then learn Spring DB Part 2.
- From concept to application : Rather than simply explaining how to use the technology, it explains the core principles and application methods of why this technology is necessary and how it came to be.
- Focused on practical examples : You will learn the data access technology required for developing applications with Spring in a natural way through examples, and we will teach you practical best practices.
- Conciseness : We boldly excluded old features that are not used in practice. We explain mainly the contents that are mainly used in modern practice.

Coverage

Data Access Technology - JdbcTemplate
When using SQL directly, the JdbcTemplate provided by Spring is a good choice. This technology makes using JDBC very convenient. And it handles most of the repetitive tasks that occur when using JDBC directly.
* Developers only need to write SQL, define parameters to pass, and map response values.
* It handles most of the repetitive tasks we can think of.
In this course, you will learn the pros and cons of the technology by implementing JdbcTemplate directly in your code in a real-world, working web application.

Data Access Technology - MyBatis
MyBatis provides more features than the JdbcTemplate described above.
The most attractive thing about MyBatis compared to JdbcTemplate is that it allows you to conveniently write SQL in XML and also allows you to write dynamic queries very conveniently.
In this course, you will learn the pros and cons of the technology by directly applying MyBatis code to a real, working web application.

Data Access Technology - JPA
Spring and JPA are the leading technologies in the Java enterprise market.
While Spring provides various application-wide features including a DI container, JPA provides ORM data access technology.
JPA is as vast as Spring, and there is a lot to learn. However, once you learn it, you can greatly improve your productivity in data access technology. For example, SQL mapper technologies such as JdbcTemplate or MyBatis require developers to write SQL themselves, but with JPA, JPA writes and processes a lot of SQL on your behalf.
In practice, Spring Data JPA and a technology called Querydsl are used together to make JPA more convenient to use.
JPA, Spring Data JPA, and Querydsl are so vast that they should be covered in separate lectures. Here, we will learn about the basic functions of these technologies, the pros and cons of each technology, and the overall big picture of why you should use them.

Data Access Technology - Spring Data JPA
Spring Data JPA is a technology that helps you use JPA more conveniently.
Simply put, it provides all the basic CRUD functions, so it can drastically reduce the amount of development code that developers need to write.
In this course, you will learn the pros and cons of Spring Data JPA by directly applying it to a real-world web application.

Data Access Technology - Querydsl
JPA has difficulty handling complex or dynamic queries. Querydsl can solve these problems very conveniently. If you use JPA in practice, this is a recommended technology that you must use.
In this course, you will learn the pros and cons of Querydsl by directly applying it to real-world web applications.

Data Access Technology - Testing
Data access technology is ultimately used for the purpose of managing data in a database. Therefore, it is necessary to ensure that the data access technology can properly store and retrieve data in the actual database.
The lecture explains step-by-step how to do tests in situations where you are connecting to a database. For example, it explains how to configure tests that connect to a database, and it shows through code how @Transactional and embedded mode DB used in tests work.

Understanding Spring Transactions
In DB1, we learned why the transaction function provided by Spring is necessary and the internal principles of how it works. In this lesson, we will learn in depth about the various functions provided by Spring transactions, such as practical precautions when using Spring transaction AOP, various options for Spring transactions, and the internal principles of how Spring transactions are committed and rolled back when an exception occurs.

Spring Transaction Propagation
We cover Spring's transaction propagation in great depth. We understand why transaction propagation is necessary, cover various transaction propagation options, exception handling according to propagation options, and cautions when using transaction propagation options in practice.