Java Spring Boot with MySQL using Spring Data JPA Full Tutorial

Let us learn how to save data and query data from MySQL database using Java Spring Boot with MySQL and Spring Data JPA. In this course, Spring Boot Application will be developed from beginning, application will be connected with MySQL using Spring Data JPA, a new table will be created in the database and following operation will be performed using Spring Data JPA, Spring Boot and MySQL connectivity -
Create / Persist / save()
Read / Fetch / find() / findById()
Delete / delete() / deleteById()
Count of total number of records / count()
We will see how to provide all the required dependencies using Spring Initializer, how to configure Spring Boot Application for getting connected to MySQL database, and will create a complete Online Store Information Entity / Table for storing the data. We will also test the data using MySQL Workbench. A full application will be developed.
Key point of Spring Boot Application -
Easily create stand-alone, production-grade Spring based Applications
Tomcat, Jetty are embedded
Provides starter dependencies
Automatically configure Spring and third party libraries
Provides production ready features such as health checks, metrics, etc.
No code generation, No XML configuration
Important points related to Spring Data JPA -
Spring Data JPA, part of the larger Spring Data family, makes it easy to easily implement JPA based repositories.
Spring Data JPA aims to significantly improve the implementation of data access layers by reducing the effort to the amount that’s actually needed.
Developer needs to write repository interfaces, including custom finder methods, and Spring will provide the implementation automatically
Some key annotations used in this tutorial -
@SpringBootApplication = @EnableAutoConfiguration + @ComponentScan + @Configuration
@Entity
@Autowired
@Override
@Id
@GeneratedValue
Key point of MySQL -
Open source - RDBMS - Relational Database Management System
Easy to use
Reliable and scalable
Good for small and large enterprise level applications
Used by Facebook, Twitter, YouTube etc.

There is playlist for Java sessions below, please consider watching this -

There are more technical sessions also available at this channel. Kindly consider watching them.
Kindly subscribe to the channel for getting regular updates of the new sessions/ courses on Software / Computer Application topics by clicking below link -

About Me 😊
I am Esha Puri, founder of Think Constructive. I have almost 20 years of software industry experience. My main aim is to make software learning extremely simple for everyone. I will provide authentic software learning material here.
Follow me -

Support the channel with your Amazon purchase -
Good Books to spend your time with -
Disclosure, I use affiliate Amazon links above. Purchasing through these links gives me a small commission to support videos on this channel -- the price to you is the same.

Chapters
00:00 Welcome Note
00:45 Spring Boot Overview
01:32 Spring Data JPA Overview
02:32 Spring Boot and Spring Data JPA Annotations
03:44 MySQL Overview
04:50 Online Store Information
05:52 Spring Boot Application using Spring Initializer with JPA and MySQL Dependencies
12:13 Schema Review using MySQL Workbench
12:49 Spring Boot - Entity Creation
16:26 Spring Boot - Repository Creation
19:11 CommandLineRunner Implementation and Override run method
20:39 Autowired Repository and save() and find the record (findById()), Test using MySQL Workbench
25:32 Override toString() method for Store Information Entity
27:06 Create more Records (save()) and Use of Custom find/ fetch & Test using MySQL Workbench
34:27 Counting total number of records - count()
36:56 Delete record from MySQL and test using MySQL Workbench
39:16 Summary
39:43 Thank You

#springboot #springdatajpa #mysql #java #database #thinkconstructive
Queries
how to develop spring boot application
how to develop spring boot application with spring data jpa
how to develop spring boot application with spring data jpa and mysql
how to develop spring boot application with mysql
how to develop spring boot application with mysql database
how to develop spring boot application with database
how to develop spring boot application with mysql and test
how to use mysql workbench
how to implement crudrepository
how to implement commandlinerunner
How to save, find and delete data from mysql
How to persist data in mysql

[ThinkConstructive]

In this tutorial, data is saved, fetched, custom fetched and deleted from MySQL database using Spring Boot application with the help of Spring Data JPA. Here Spring Boot application is implemented from the scratch, Spring Data JPA and MySQL dependencies are added, required MySQL configurations are done and then application is build. Finally, application is tested using MySQL Workbench. Kindly watch complete session to fully understand implementation. Additionally, I will suggest you to implement the example with the tutorial to get the full advantage from this course.
Also, please comment here to let me know which next session you want me to upload here.
Enjoy learning Spring Boot, Spring Data JPA and MySQL,
Cheers,
Esha

[chendrashekhar]

I am recommending this channel for all of my friends who are preparing for Java Full Stack

[techlover]

Brilliant content! Learned a lot from this

[chendrashekhar]

the content is really ultimate, thank you so much !!

[ParthPuri]

Excellent tutorial. Please give more sessions on Spring Boot

[AppleMenace]

Thank you very much this video has been very helpful.

[brwqhen]

Thank u for sharing your knowledge with us !!

[thrivespaze]

hey, I am having a problem with annotation. Can you help me out?

[talhaanwer]

Just a heads up! In newer Java versions, 'javax' is now 'jakarta' for enterprise stuff.

[charlesappiahmends]

great can you do another video with vaadin (form) and mysql

[priyal]

Hello ma'am, I am new to Springboot, have been learning from your sessions. I have a doubt. Why didn't we use any sort of request mapping in this project n still how did it work properly. Also, we did not create any service layer interface or class here. Can you please help me understand. Thankyou.

[amitjajoo]

create video on how to use dto in spring boot with foreign key constraint and please use postman

[glxchir]

Mam, can you make a video or have one on creating entity mappings?

[lwjngpe]

Madam Ji, kindly use all API documentation annotations to current REST APIs

[lwjngpe]

kindly make a video oauth2 with an okta demonstration using Rest API, madam ji