Spring Boot Tutorial using JDBC + Connection Pool + Flyway + JDBC Template + SQL and Docker 😲
Ғылым және технология
In this video you learn how to work with databases using JDBC, Creating Datasources, Database Connection pool, Flyway for Database Migrations and JDBC Template for executing sql queries against any relational database of choice.
#jdbc #jdbctemplate #amigoscode
Github Repo: github.com/amigoscode/jdbc
Don't Forget to 😲
===========================================
💯 Subscribe to Amigoscode - bit.ly/2HpF5V8
💯 Courses Available for free here - amigoscode.com/courses
💯 Join Private Facebook Group and Discord - amigoscode.com/p/join-community
⭐ Table Of Contents ⭐
===========================================
00:00 - Intro
01:54 - Requirements
02:32 - Architecture Overview
07:02 - Github Repo
08:28 - Backend Overview
14:28 - Docker and PostgreSQL
20:28 - Hikari Datasource
25:01 - Database Migration with Flyway
30:04 - Running app
35:51 - JDBC Template
39:46 - Other JDBC Wrappers
40:26 - JDBC Template and Insert
46:52 - JDBC Template Select and RowMappers
55:07 - JDBC Template Select by id and RowMappers
01:00:17 - JDBC Template Delete
01:04:31 - Exercise
01:06:09 - Outro
🙊 Here are the goods for all my videos video 🙊
===========================================
► Recommended Books
===========================================
- Clean Code - amzn.to/2UGDPlX
- HTTP: The Definitive Guide - amzn.to/2JDVi8s
- Clean Architecture - amzn.to/2xOBNXW
► Computer and Monitor
===========================================
- New Apple MacBook Pro - amzn.to/3464Mmn
- Dell 27 INCH Ultrasharp U2719D Monitor - amzn.to/2xM3nW1
- Double Arm Stand Desk Mount - amzn.to/3aYKKfs
- USB C Hub Multiport Adapter - amzn.to/2Jz7NlL
► Camera Gear
=============================================
- Sony ILCE7M3B Full Frame Mirrorless Camera - amzn.to/346QIJn
- Sigma 16 mm F1.4 DC DN - amzn.to/2wbic3Q
- Sigma 33B965 30 mm F1.4 DC DC - amzn.to/39G37Fd
► IDE & Tools I use for coding 💻 🎒
===========================================
- ITerm
- VsCode
- GoLand
- IntelliJ Ultimate
- Sublime
P.S
===========================================
💯 Don't forget to subscribe | bit.ly/2HpF5V8
💯 Join Private Facebook Group and Discord - amigoscode.com/p/join-community
💯 Follow me on Instagram | bit.ly/2TSkA9w
❤️ Thanks for watching
Пікірлер: 184
I'm interning at a big cloud infrastructure provider and your tutorials have helped me so much so far! I'm glad I'll soon have $ to finally enroll in your courses :) and I recommend your courses to everyone too! thank you so much.
MY first direction when I need any thing is your channel, your videos like a treasure for me like a big warehouse which has all the materials you need. I'm learning every day to get a good job so one day I can at least enroll in your paid courses and help you to continue this great effort. Please, forgive me for my bad English.
Thank you a lot man! Thank you for all your work, each time it’s good quality lessons, video and informative graphics. It’s usually highest quality video on platform ❤️
+1 for Flyway tutorial including undo & repeatable migrations. Thank you so much for such a great tutorials and your efforts!
By far he is the best teacher I have ever seen. Thank you for sharing your knowledge with us.
So good stuff. Been using all of that stack for a few years and still like to watch it, some concepts do become even more clean.
Thank you Nelson. I have requested ( one year ago) for springboot-jdbc. Now i am very happy. God bless you
Life saver. Plan was to use flyway fr DB migration fr few of my micro services… Saved tons of time after this tutorial… Thank you!!!
Hello, Im from spain and I have finished my degree recently, and I must say that Im learning a lot whit your videos, and they are helping me on my new job as developer. You are awesome and keep going on, Thanks!
Smashed the like button but it broke my screen
very needed video and quality content as usual , Nelson ! I am looking forward to completing it.
Thanks brother for everything you’ve done, subbed and hit the bell 🔔 I’m a sw engineer (C/C++) that works for an Aerospace/defense company here in the States. I was approached by a recruiter about switching over to do web development for a Fortune 500 bank, I’m gonna interview and go for it! They need ppl badly!! I’m so glad I found your channel and can use it to help me learn Java/Spring/Boot. God Bless!
@leeoiou7295
Жыл бұрын
How is your job at aerospace/defence ? I will wish to work in such area.
Many thanks for your really insightful tutorial videos on Spring Boot, JPA, JDBCTemplate. I will definitely recommend this channel to my colleagues willing to learn Spring boot.
really appreciate your work on spring boot with high quality in every aspect, nice tutorial! :D
@vuchinh9989
2 жыл бұрын
Bro, I've completed your tutorial and added the ability to edit movies. However, about Actor association, I don't know how to do it (as things get complicated to do 2 tables ). If you have the next update, I hope you can do an update on this course or may upload the final version on Github. Otherwise, it is an amazing course, I learned so many things. Good day to you and keep up the great work 🥰
Whole time, I liked the video before it actually started because I knew it was gonna be quality lol.
Another amazing course. Thanks for all your efforts !
You are inspiring me every time i watch your videos!
Thank you Nelson for share another valuable content with us!
This was amazing, I am a professional and still found so many great things from this video. Liked and subscribed. More power to you, keep sharing.
Thankyou Nelson for making such type of content. ❤️❤️
Very nice tutorial , thanks Nelson m It gave me the new perspective for jdbc , great work keep going
You motivate other people to learn java for their job
Waaaw, This video explain things in a better way. My college teacher got 1h+ (slide) to just introduce everything Talk talk talk. And with that I began to leave Java and turn to nodejs thing. I just discovered this Channel and I think things are just interesting in the first minute. Cool video !
Thanks alot for this amazing course.
1 hour video took me 5 hours to go thru :D but it was worth it I got lot of knowledge !
More tutorial on FLYWAY FLYWAY! Pleaseee.... Awesome video as always
ONE OF THE BEST VIDEOS EVER. THANKS SIR.APPRECIATE YOU
thanks a lot for teach us, cheers from Chile
Mashallah! Great content, my brother! Keep going and thanks for your videos and your effort!
Amazing course! Thank U
Great Content as always
Great content as always :) Thanks, bro ... I'm looking forward for a new tutorials on #flyway from you
Keep going man nice staff!
Thank you so much for a great tutorial
Great content as usual 👏
Amazing course ! Really 🙃🙃👍🏻 flyway extra course would be great 🤩🤩🤩
On Point Amigos............Great work
iam currently working on the mern stack development but i highly appreciate your spring boot courses and i will start taking springboot course in septemper insha allah thanks for the good work nelson
@newtanagmukhopadhyay4716
2 жыл бұрын
same here brother. springboot seems interesting . will surely start learning it this december
+2 for Flyway tutorial with repeatbale migrations and which discusses about what would happen if we didnt use any CICD or database version control like Flyway for example.. Understanding the 'why' would make the bigger picture clear I guess. Thankyou AmigosCode.
Thank you Nelson for this great video! Can you create a second part that covers others methods in the JdbcTemplate such as the execute() method? And what approach do you recommend to set the search_path for every query? Thanks again
Great thanks for the tutorial. Two things: 1. named query parameters and 2. db migrations should be run from cmd line with admin privileges but code should run under writer
Great content Nelson, and thank you for your efforts and energy you spread through contents you teach. Please can you introduce us on how to build RESTfull API following OpenAPI standard with "yml" file and classes generation?? PLS 🙏🙏🙏
Wow wow absolutely correct 👍 jdbcTemplate maybe u need to write more code but u have total control unlike jpa hibernate.. thanks sir ❤️
جزاك الله خيراا!
Thank you for this video)
Jazakallah khairan brother
Thank you a lot for the video, would you please do a tutorial on Transaction Management with Spring ?
Thanks for the great content
I wish I can thumbs up thrice or even ten times. Thanks you teach well
Comment for the follow-up #flyway tutorial. Great content!
thank you brother for this great job
we getting this quality content for free, why should people have issues with just clicking the like button. 👍
Adorei os videos legendados em Português S2
it is so helpful bro. Thanks
Nelson , keep up the good work bro . Many thanks for the videos May Allah protect you .
assalamo alaykom, Thank you so much for your videos that helps a lot I've been watching so long I'm hoping u can add a tutorial about Spring DTO cause i really need it and thank you so much Mashae lah
Jesus bless you for the work you do. Thanks this and other videos you have made are of tremendous help. Thanks
Mashallah. Good job.
Yes we need Flyway tutorial ! Please
Grate content!
you are my hero, bro
Good job Man
Great content, I love your videos. Please do a video on "FLYWAY"
Great man keep going
Thanks you very much
Great content my brother
Great video. Do you have any suggestions on the best practice for handling multiple optional query parameters in the repository layer? E.g. how would we handle GET /movies?length=100&rating=R in the DAO layer method when both length and rating are optional params
Thank you a lot
Good job 👏
Great tutorial
thank you so much
Another great tutorial, question amigoscode have u done dynamodb before and if so have u ever done a one to many or many to many relationship table with it?
Bro please do latest (2021) crash course on 1.Angular 12 2- reactjs 3- nodejs- 4-- meanstack 5.mern stack 6-Real time project (product) development 7.Frontend development interview questions and answers
Awesome 👌🏿, thanks bro. The best content and courses from Internet 😀. I think for bigger projects it's better to use JDBC instead of Spring Data Jpa; either with Flyway or without it.
@BlessingRajasingh
2 жыл бұрын
Always rock jdbc
@AllenIve3
2 жыл бұрын
Why ?
Nice tutorial. Thanks. One question, Is it possible to establish relationships between entities(records) like OneToMany, ManyToMany etc?
Asalam O Aalikum ! thankyou so much for your tutorials.please also create content for flyway
Great!
best Amigo!
Excellent video! I'm learning a lot with it! I have one question: Why not to use Spring Data JPA instead JDBC Template? Has any specific reason for it or its just a programmers choice and both do the same thing?
Thanks :)
This subject is desired 👍
Awesome video.
Good Work
thanks bro.
Niiiice!!
Thalaivar is back
Huge thanks Nelson! Could you please explain why one would choose JDBC instead of JPA? JPA seems better is almost any way I can think of.
@bluex217
2 жыл бұрын
I believe one of the biggest advantages is to implement multiple datasources (see around 38:30). You may have a local H2 database for testing and/or production within your team, while a MYSQL or PostgresQL database is used for the live application
Keep on!
Thanks For Sharing
Hey Nelson, what you think about JPA Criteria Queries? I have used it but it's seems overkill to me because I need bunch of code for simple queries. Currently I prefer SQL or even Hibernate Query language (HQL).
السلام عليكم ورحمة الله وبركاته Please make video on flyway and liquibase , and also cover the comparison between those . Thanks
❣❣❣❣❣❣❣ thanks brother
You're an excellent teacher. Do you have a mentorship program?
The legend🤩
amazing 🤩
Hi! After all, how is it more beautiful and safer to work? With using Namedparameters instead of placeholder ? or does it not particularly affect how to write a query?
Salamo Alikom, Thank you for this tutorial. I want to know why we have to choose jdbc instead of jparepository for exemple?
Pls make video about Flyway!!
amazing
i love you content watching from kenya africa i would suggest if you can do a full project like youtube clone using spring and react