인프런 영문 브랜드 로고
인프런 영문 브랜드 로고
BEST
Programming

/

Back-end

Spring DB Part 2 - Data Access Utilization Technology

You can utilize and complete the 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.

(5.0) 465 reviews

15,199 students

Spring
MVC
spring-jpa
JPA
querydsl
Thumbnail

This course is prepared for Basic Learners.

What you will learn!

  • Internal principles of using DB through Spring

  • Various ways to use DB through Spring

  • Spring DB Access Technology

Must-know for backend developers
Spring Data Access Technology Part.2

📣 Please check!
This lecture is the 7th lecture in the Java Spring Complete Conquest series . Please check the Spring Complete Conquest roadmap by Younghan Kim, the youngest technical director of Woowa Brothers, first.
• Roadmap link: https://www.inflearn.com/roadmaps/373 (click to go there)

Kim Young-han's Spring DB
Completing data access techniques

To properly develop a backend web application, you need to complete two major axes: MVC based on HTTP and data access technology based on DB. We completed HTTP and Spring MVC in the previous lecture, so now we need to complete the remaining axis, Spring DB data access technology.

✅ Please check the player's knowledge.

Please check whether you understood the principles and structure of Spring DB through the previous lecture, <Spring DB Part 1> .

1. Understand the basic principles of Spring data access technology
2. Develop directly with code used in practice


Through the Spring DB Part 1 lecture, we have understood the core principles and structure of DB access technology. In this Spring DB Part 2, we will learn various practical utilization technologies based on Part 1. Part 2 is largely divided into three parts.

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

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

3) Deep understanding of Spring transactions

In Spring DB Part 1, we learned why the transaction function provided by Spring is necessary and how it works, as well as the internal principles. In this lesson, we will learn about Spring transactions in great depth and learn how to use them in practice.

  • 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 master the vast database data access skills required to develop 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.
  • Focused on practical examples: Learn the data access technologies required for developing backend applications with Spring in a natural way through examples, and learn best practices from practical use.
  • Conciseness: We boldly excluded old features that are not used in practice. We mainly explain the contents that are mainly used in modern practice.

Lecture Contents

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.
* Understand the pros and cons of JdbcTemplate by applying it to a real-world web application.

Data Access Technology - MyBatis

MyBatis offers more features than the JdbcTemplate described above. The most attractive point of MyBatis compared to JdbcTemplate is that it allows you to conveniently write SQL in XML and also allows you to conveniently write dynamic queries. In this lecture, you will understand the advantages and disadvantages of the technology by directly applying MyBatis to a real-life web application.

Data Access Technology - JPA

Spring and JPA are the main technologies in the Java enterprise market. While Spring provides various functions for the entire application, including the DI container, JPA provides ORM data access technology. JPA is as vast as Spring and has a lot to learn, but once you learn it, you can greatly improve your productivity in data access technology. Here, we will look at 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 dramatically reduce the amount of development code that developers have to write. In this lecture, you can understand the advantages and disadvantages of the technology by directly applying Spring Data JPA to an actual 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 the lecture, you can understand the advantages and disadvantages of the technology by directly applying Querydsl to actual 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 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 test in a situation where a database is connected. For example, we will explain how to configure a test that connects to a database, and learn how @Transactional and embedded mode DB work through code.

Understanding Spring Transactions

In DB Part 1, we looked at the internal principles of why the transaction function provided by Spring is necessary and how it works. In this lesson, we will look deeply into the various functions provided by Spring Transaction, such as practical precautions when using Spring Transaction AOP, various options for Spring Transaction, and the internal principles of how Spring Transaction is 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.


Knowledge sharer
A word from Kim Young-han

Backend developers must complete two major axes: MVC and DB access technology. We will help you complete these two axes and grow into a solid backend developer. Thank you.


Lecture order


Associated Roadmap

Spring Complete Conquest Series
Spring Smart Start, from Core Principles to Practical Applications
Complete mastery of Spring Boot + JPA practices
In-depth learning through creating web apps using the latest practical technologies

Recommended for
these people!

Who is this course right for?

  • Developers who want to access DB and manage data through Spring

  • Developer job seeker

  • Working developers who want to deeply understand Spring DB access technology

  • Developers who want to create web applications with Spring

Need to know before starting?

  • Java language

  • Spring Basics

  • DB Basic Knowledge

Hello
This is yh

Students

474,959

Reviews

29,661

Rating

5.0

Courses

21

진짜 실무에 필요한 제대로 된 개발자가 될 수 있도록, 교육하는 것이 저의 목표입니다.

 

저의 개발 인생 이야기

EO 인터뷰 영상

개발바닥 - 시골 청년 개발왕 되다

취업과 이직에 대한 고민 해결

 

Curriculum

All

88 lectures ∙ (13hr 59min)

Lecture resources

are provided.

Published: 
Last updated: 

Reviews

Not enough reviews.
Become the author of a review that helps everyone!