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) 517 reviews

15,924 students

Spring
MVC
spring-jpa
JPA
querydsl

This course is prepared for Basic Learners.

00:00

/

-

  • Introduction video

    02:52

  • Introduction to the course

    02:52

  • Introduction to Data Access Technology Progress

    06:21

  • Project Settings and Memory Storage

    04:07

  • Project Structure Description 1 - Basics

    18:17

  • Project Structure Description 2 - Settings

    13:24

  • Introduction and configuration of JdbcTemplate

    03:50

  • Introduction to Spring Transactions

    09:45

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

506,760

Students

32,152

Reviews

8,819

Answers

5.0

Rating

22

Courses

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

 

저의 개발 인생 이야기

EO 인터뷰 영상

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

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

 

More

Curriculum

All

88 lectures ∙ (13hr 59min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

517 reviews

5.0

517 reviews

  • gusdn855542301

    Reviews 2

    ∙

    Average Rating 5.0

    5

    98% enrolled

    Hello, Younghan! I started studying in July of last year, and after 1 year and 4 months, I finally listened to all of Younghan's lectures (except for the boot lecture). While listening to each lecture, I decided to listen to DB Part 2 and write a proper course review, and I'm finally able to write one. When I was feeling lost studying development as a non-major, I think I was able to grow by listening to Younghan's lectures. I worked on several projects through the lectures, and studied the CS I lacked through study. I will tell you about the characteristics of Younghan's lectures, who listened to all of Spring and Jpa's lectures. Let me tell you about the characteristics of Younghan's lectures. In order to learn the 5 steps, he teaches you step by step from step 1. If you know step 5 without knowing steps 1-3, if you learn steps 1-3 through the lectures, you will know why step 5 came out like this. I always listened to it without knowing, so I was always amazed when I saw the code evolving, thinking, "Technology has developed this much." (The reason there can be new technologies is because there are technologies from the past.) And I think that it is more effective to watch Younghan's lectures multiple times. For example, if you listen to the Spring Basics lecture, then the Spring MVC lecture, and then listen to the Spring Basics lecture again, your perspective will be broader than when you first listened to it. That's why I think I listened to JPA Basics 2-3 times (because it's difficult). For those of you who are considering Younghan's lectures, I hope you read this article and think about it. Oh, and lastly, thank you so much for the supporters' QnA answers! Whenever I didn't know something, I always solved it by Googling or QnA. Good luck to you all. Thank you for reading the long article.

    • yh
      Instructor

      gusdn85554, you understand it step by step very well. And as you said, reviewing is also very important. I'm rooting for you!

  • ho2ast

    Reviews 13

    ∙

    Average Rating 5.0

    5

    100% enrolled

    Hello, Professor. I finished this lecture as well. I followed the roadmap for about a year, listening to lectures after work and on weekends, but now only the last chapter of the grand finale is left. I am so grateful that you always explain the background of the technology and why it is used so that anyone can understand it, and try to convey at least one more thing. Sometimes I see the professor's computer time while watching the lecture. Sometimes it is a number, and sometimes it is a clock shape, so I thought that he was hiding it on purpose. Hahaha. Anyway, watching you film lectures at various times from early evening to dawn, I often reflected on myself, thinking, "The professor is filming such great lectures so diligently, but am I working that hard?" You provided such great lectures and gave me generous advice as a senior developer, so it was a year of time where I was able to gain motivation not only for technical learning but also for life. I think I will be able to maintain this system well and develop happily in the future. Thank you.

    • yh
      Instructor

      Dear Seonhanyeonggwangryeok Developer, thank you for always listening to me diligently and leaving frequent course reviews. Since you said you've been together for a year, I feel like I've done something together, so it's more rewarding. I've been spending more time lately, so I can focus more on the lectures, thanks to the students who sometimes talk to me^^

  • impati0716

    Reviews 11

    ∙

    Average Rating 5.0

    5

    100% enrolled

    I'm learning a lot. Thank you always.

    • yh
      Instructor

      Mr. Choi Jun-young, thank you for listening so diligently. I also feel rewarded. Thank you.

  • ballgaveship1247

    Reviews 10

    ∙

    Average Rating 5.0

    5

    100% enrolled

    Honestly, those who don't know the contents of Spring DB 1 and 2 are building a tower on top of their thoughts. If you don't know even one thing about the table of contents, definitely listen to it! Listen twice

    • yh
      Instructor

      Thank you so much for listening so diligently, Mr. Uzza!!

  • chlxogns928264

    Reviews 17

    ∙

    Average Rating 5.0

    5

    100% enrolled

    It's awesome :) It's the best lecture. I learned a lot while listening to the lecture and I'm using it well in my work. I'm planning to listen to the practical lecture as well, and I'm looking forward to the Spring Boot lecture.

    • yh
      Instructor

      Thank you, Hoon, for listening so intently. Fighting until the end.

yh's other courses

Check out other courses by the instructor!

Spring Core Principles - BasicsCourse Thumbnail

Spring Core Principles - Basics

yh

$68.20

Basic / Spring, oop

5.0

(4,127)

38,600+
Update
Update

Beginners to Spring can understand the core principles of Spring and solidify their foundation in Spring by creating examples.

Basic

Basic

Spring, oop

Kim Young-han's Practical Java - FundamentalsCourse Thumbnail

Kim Young-han's Practical Java - Fundamentals

yh

$34.10

Basic / Java, oop

5.0

(1,475)

15,400+
Update
Update

Easily learn the core concepts of Java object-oriented programming needed in practice through example code.

Basic

Basic

Java, oop

Kim Young-han's Practical Java - Advanced, Part 1: Multithreading and ConcurrencyCourse Thumbnail

Kim Young-han's Practical Java - Advanced, Part 1: Multithreading and Concurrency

yh

$59.40

Basic / Java, oop, thread, multithread, concurrent

5.0

(268)

6,800+
Update
Update

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

Basic

Basic

Java, oop, thread

Real-World Java - Advanced Part 3, Lambda, Streams, and Functional Programming by Kim Young-hanCourse Thumbnail

Real-World Java - Advanced Part 3, Lambda, Streams, and Functional Programming by Kim Young-han

yh

$59.40

Basic / Java, Functional Programming, Lambda, optional

4.9

(78)

2,500+
Update
Update

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

Basic

Basic

Java, Functional Programming, Lambda

Kim Young-han's Practical Java - Intermediate Level 1Course Thumbnail

Kim Young-han's Practical Java - Intermediate Level 1

yh

$51.70

Basic / Java, oop

5.0

(680)

9,300+
Update
Update

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

Basic

Basic

Java, oop

HTTP Web Basics for Every DeveloperCourse Thumbnail

HTTP Web Basics for Every Developer

yh

$34.10

Basic / Network

5.0

(3,514)

34,300+
Update
Update

Learn the core HTTP features essential for practical use and how to design proper HTTP APIs.

Basic

Basic

Network

Java ORM Standard JPA Programming - BasicsCourse Thumbnail

Java ORM Standard JPA Programming - Basics

yh

$93.50

Basic / Java, JPA

5.0

(1,834)

23,500+
Update
Update

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.

Basic

Basic

Java, JPA

Spring MVC Part 1 - Core technologies for backend web developmentCourse Thumbnail

Spring MVC Part 1 - Core technologies for backend web development

yh

$77.00

Basic / MVC, Spring

5.0

(2,218)

28,700+
Update
Update

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.

Basic

Basic

MVC, Spring

Kim Young-han's Practical Java - Advanced Part 2, I/O, Network, ReflectionCourse Thumbnail

Kim Young-han's Practical Java - Advanced Part 2, I/O, Network, Reflection

yh

$59.40

Basic / Java, Network, oop

5.0

(156)

4,600+

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.

Basic

Basic

Java, Network, oop

Practical! Spring Data JPACourse Thumbnail

Practical! Spring Data JPA

yh

$68.20

Intermediate / Java, Spring, Spring Boot, JPA

5.0

(900)

16,100+

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.

Intermediate

Intermediate

Java, Spring, Spring Boot

Practice! QuerydslCourse Thumbnail

Practice! Querydsl

yh

$68.20

Intermediate / Java, JPA

5.0

(830)

15,500+

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

Intermediate

Intermediate

Java, JPA

Real-world! Spring Boot and JPA Utilization 2 - API Development and Performance OptimizationCourse Thumbnail

Real-world! Spring Boot and JPA Utilization 2 - API Development and Performance Optimization

yh

$68.20

Intermediate / Java, Spring, Spring Boot, JPA

5.0

(1,195)

20,000+

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

Intermediate

Intermediate

Java, Spring, Spring Boot

Kim Young-han's Practical Java - Intermediate Part 2Course Thumbnail

Kim Young-han's Practical Java - Intermediate Part 2

yh

$51.70

Basic / Java, oop, Algorithm, Coding Test

5.0

(465)

8,000+
Update
Update

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

Basic

Basic

Java, oop, Algorithm

Spring Boot - Core Principles and ApplicationsCourse Thumbnail

Spring Boot - Core Principles and Applications

yh

$77.00

Basic / Spring Boot, Spring, spring-boot-actuator, Prometheus, grafana

5.0

(361)

12,700+

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

Basic

Basic

Spring Boot, Spring, spring-boot-actuator

Real-world! Spring Boot and JPA Utilization 1 - Web Application DevelopmentCourse Thumbnail

Real-world! Spring Boot and JPA Utilization 1 - Web Application Development

yh

$68.20

Basic / Java, Spring, Web Application, Spring Boot, JPA

5.0

(2,220)

25,500+

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.

Basic

Basic

Java, Spring, Web Application

Spring Core Principles - AdvancedCourse Thumbnail

Spring Core Principles - Advanced

yh

$93.50

Intermediate / Spring, Design Pattern

5.0

(695)

19,100+
Update
Update

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

Intermediate

Intermediate

Spring, Design Pattern

Spring MVC Part 2 - Backend Web Development Utilization TechnologyCourse Thumbnail

Spring MVC Part 2 - Backend Web Development Utilization Technology

yh

$93.50

Basic / MVC, Spring

5.0

(1,072)

24,100+
Update
Update

You can understand and master all the web technologies required for web application development from the basics. In Part 2 of MVC, you can learn all the utilization technologies required for practical web development on top of the core principles and structure of Part 1 of MVC.

Basic

Basic

MVC, Spring

Spring DB Part 1 - Core Principles of Data AccessCourse Thumbnail

Spring DB Part 1 - Core Principles of Data Access

yh

$59.40

Basic / Spring, MVC, spring-jdbc

5.0

(822)

18,100+

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.

Basic

Basic

Spring, MVC, spring-jdbc

Spring for Beginners - Learn Spring Boot, Web MVC, and DB Access Technology with CodeCourse Thumbnail

Spring for Beginners - Learn Spring Boot, Web MVC, and DB Access Technology with Code

yh

Free

Basic / Java, Spring, MVC, Spring Boot

5.0

(6,720)

113,900+
Update
Update

Beginners to Spring can quickly learn the entire Spring web application development process by creating examples.

Basic

Basic

Java, Spring, MVC

Kim Young-han's Java Tutorial - Your First Step into Java with CodeCourse Thumbnail

Kim Young-han's Java Tutorial - Your First Step into Java with Code

yh

Free

Beginner / Java, oop

5.0

(1,862)

47,800+
Update
Update

This is a Java course for those who are new to programming. You can easily learn Java by following along with the code.

Beginner

Beginner

Java, oop

Similar courses

Explore other courses in the same field!

Spring DB Part 1 - Core Principles of Data AccessCourse Thumbnail

Spring DB Part 1 - Core Principles of Data Access

yh

$59.40

Basic / Spring, MVC, spring-jdbc

5.0

(822)

18,100+

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.

Basic

Basic

Spring, MVC, spring-jdbc

Code-Based React with Spring Boot API ServerCourse Thumbnail

Code-Based React with Spring Boot API Server

zk202308a5410

$59.40

24%

$45.10

Basic / React, Spring Boot, JWT, redux-toolkit, JPA

4.7

(68)

1,100+
Update
Update

Completing the integration project between Spring Boot (API server made with Spring Boot ver3.4) and React! Creating lectures for the entire portfolio creation bootcamp course

Basic

Basic

React, Spring Boot, JWT

Spring for Beginners - Learn Spring Boot, Web MVC, and DB Access Technology with CodeCourse Thumbnail

Spring for Beginners - Learn Spring Boot, Web MVC, and DB Access Technology with Code

yh

Free

Basic / Java, Spring, MVC, Spring Boot

5.0

(6,720)

113,900+
Update
Update

Beginners to Spring can quickly learn the entire Spring web application development process by creating examples.

Basic

Basic

Java, Spring, MVC

[MMORPG Game Development Series with C# and Unity] Extra: ASP.NET Core AdvancedCourse Thumbnail

[MMORPG Game Development Series with C# and Unity] Extra: ASP.NET Core Advanced

rookiss

Free

Intermediate / ASP.NET Core, MVC

5.0

(32)

4,100+

This lecture will delve deeper into the various features of ASP.NET Core. You will practice what you have learned through Facebook authentication practice.

Intermediate

Intermediate

ASP.NET Core, MVC

[React Part 1] Learning React by making and comparingCourse Thumbnail

[React Part 1] Learning React by making and comparing

jeonghwan

$42.90

Basic / React, MVC

4.8

(107)

1,900+

React is the most popular front-end technology used in practice. Use React technology to quickly develop applications and create maintainable code.

Basic

Basic

React, MVC

How to use Redis effectively, based on my experience working at a large company [Practice]Course Thumbnail

How to use Redis effectively, based on my experience working at a large company [Practice]

jhong

$29.70

Basic / Redis, redisinsights, cache, Spring

4.0

(8)

200+

In this course, rather than covering the theory directly, you will learn how to use Redis effectively in your code through hands-on practice.

Basic

Basic

Redis, redisinsights, cache

More Java, different ways to manipulate codeCourse Thumbnail

More Java, different ways to manipulate code

whiteship

$38.50

Basic / Java, Spring, JPA

4.9

(317)

4,700+

Have you ever wondered "how" the many Java libraries and frameworks you use provide this functionality? In this course, learn how to manipulate various codes or objects provided by Java and take your Java skills to the next level.

Basic

Basic

Java, Spring, JPA

$77.00