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

  • @33v4.
    @33v4.2 жыл бұрын

    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.

  • @raadkasem
    @raadkasem2 жыл бұрын

    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.

  • @topalov_maxim
    @topalov_maxim2 жыл бұрын

    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 ❤️

  • @BabaykaMoscow
    @BabaykaMoscow2 жыл бұрын

    +1 for Flyway tutorial including undo & repeatable migrations. Thank you so much for such a great tutorials and your efforts!

  • @databaseadmin
    @databaseadmin2 жыл бұрын

    By far he is the best teacher I have ever seen. Thank you for sharing your knowledge with us.

  • @krisorsmso5094
    @krisorsmso50942 жыл бұрын

    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.

  • @jeevanthalluri2200
    @jeevanthalluri22002 жыл бұрын

    Thank you Nelson. I have requested ( one year ago) for springboot-jdbc. Now i am very happy. God bless you

  • @sathishselvaraj1792
    @sathishselvaraj17922 жыл бұрын

    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!!!

  • @adrianbarriento7851
    @adrianbarriento78512 жыл бұрын

    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!

  • @aayush5474
    @aayush54742 жыл бұрын

    Smashed the like button but it broke my screen

  • @shashishekhar----
    @shashishekhar----2 жыл бұрын

    very needed video and quality content as usual , Nelson ! I am looking forward to completing it.

  • @nontraditionaltech2073
    @nontraditionaltech20732 жыл бұрын

    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

    @leeoiou7295

    Жыл бұрын

    How is your job at aerospace/defence ? I will wish to work in such area.

  • @manikyamithun
    @manikyamithun2 жыл бұрын

    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.

  • @vuchinh9989
    @vuchinh99892 жыл бұрын

    really appreciate your work on spring boot with high quality in every aspect, nice tutorial! :D

  • @vuchinh9989

    @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 🥰

  • @boomantv8271
    @boomantv82712 ай бұрын

    Whole time, I liked the video before it actually started because I knew it was gonna be quality lol.

  • @MrAIProgrammer
    @MrAIProgrammer2 жыл бұрын

    Another amazing course. Thanks for all your efforts !

  • @akshaybhoendie
    @akshaybhoendie2 жыл бұрын

    You are inspiring me every time i watch your videos!

  • @leonardoamorimramos5656
    @leonardoamorimramos56562 жыл бұрын

    Thank you Nelson for share another valuable content with us!

  • @manasram
    @manasram Жыл бұрын

    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.

  • @codertravel99
    @codertravel992 жыл бұрын

    Thankyou Nelson for making such type of content. ❤️❤️

  • @mehdivand2977
    @mehdivand29772 жыл бұрын

    Very nice tutorial , thanks Nelson m It gave me the new perspective for jdbc , great work keep going

  • @ronsreacts
    @ronsreacts3 ай бұрын

    You motivate other people to learn java for their job

  • @ciscoramonsanchez5192
    @ciscoramonsanchez51922 жыл бұрын

    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 !

  • @placidenduwayezu9610
    @placidenduwayezu96102 жыл бұрын

    Thanks alot for this amazing course.

  • @Apopjak
    @Apopjak Жыл бұрын

    1 hour video took me 5 hours to go thru :D but it was worth it I got lot of knowledge !

  • @christianogbonda7740
    @christianogbonda77402 жыл бұрын

    More tutorial on FLYWAY FLYWAY! Pleaseee.... Awesome video as always

  • @zakirazakira6951
    @zakirazakira69512 жыл бұрын

    ONE OF THE BEST VIDEOS EVER. THANKS SIR.APPRECIATE YOU

  • @shaquespiare
    @shaquespiare2 жыл бұрын

    thanks a lot for teach us, cheers from Chile

  • @ramazanualdinuly928
    @ramazanualdinuly9282 жыл бұрын

    Mashallah! Great content, my brother! Keep going and thanks for your videos and your effort!

  • @fiberii5696
    @fiberii56962 жыл бұрын

    Amazing course! Thank U

  • @MahmoudElasry_Genuis
    @MahmoudElasry_Genuis Жыл бұрын

    Great Content as always

  • @saidlaarab7852
    @saidlaarab78522 жыл бұрын

    Great content as always :) Thanks, bro ... I'm looking forward for a new tutorials on #flyway from you

  • @klementbinaj9673
    @klementbinaj96732 жыл бұрын

    Keep going man nice staff!

  • @suharbramar4127
    @suharbramar4127 Жыл бұрын

    Thank you so much for a great tutorial

  • @marcinzale
    @marcinzale2 жыл бұрын

    Great content as usual 👏

  • @koempf
    @koempf2 жыл бұрын

    Amazing course ! Really 🙃🙃👍🏻 flyway extra course would be great 🤩🤩🤩

  • @ugandandev
    @ugandandev2 жыл бұрын

    On Point Amigos............Great work

  • @ahmedhosny4910
    @ahmedhosny49102 жыл бұрын

    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

    @newtanagmukhopadhyay4716

    2 жыл бұрын

    same here brother. springboot seems interesting . will surely start learning it this december

  • @sanskarkaazi3830
    @sanskarkaazi38302 жыл бұрын

    +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.

  • @teklegebreyohannes7085
    @teklegebreyohannes7085 Жыл бұрын

    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

  • @mosyright4799
    @mosyright479911 ай бұрын

    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

  • @mishdev4699
    @mishdev46992 жыл бұрын

    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 🙏🙏🙏

  • @arghyamitra3281
    @arghyamitra32812 жыл бұрын

    Wow wow absolutely correct 👍 jdbcTemplate maybe u need to write more code but u have total control unlike jpa hibernate.. thanks sir ❤️

  • @Ibrahimabdalaziz-xo8mx
    @Ibrahimabdalaziz-xo8mx2 ай бұрын

    جزاك الله خيراا!

  • @egorvafin1978
    @egorvafin19782 жыл бұрын

    Thank you for this video)

  • @Dzikrullah_999
    @Dzikrullah_999 Жыл бұрын

    Jazakallah khairan brother

  • @UTUBDZ
    @UTUBDZ2 жыл бұрын

    Thank you a lot for the video, would you please do a tutorial on Transaction Management with Spring ?

  • @mohamedoueslati462
    @mohamedoueslati46210 ай бұрын

    Thanks for the great content

  • @xtonetware5493
    @xtonetware54932 жыл бұрын

    I wish I can thumbs up thrice or even ten times. Thanks you teach well

  • @dimogeorgiev6889
    @dimogeorgiev68892 жыл бұрын

    Comment for the follow-up #flyway tutorial. Great content!

  • @codehelmet5173
    @codehelmet51732 жыл бұрын

    thank you brother for this great job

  • @alexotoous
    @alexotoous Жыл бұрын

    we getting this quality content for free, why should people have issues with just clicking the like button. 👍

  • @Olavo_Carvalho
    @Olavo_Carvalho2 жыл бұрын

    Adorei os videos legendados em Português S2

  • @talbiabdelali5914
    @talbiabdelali59142 жыл бұрын

    it is so helpful bro. Thanks

  • @raulgreva5586
    @raulgreva55862 жыл бұрын

    Nelson , keep up the good work bro . Many thanks for the videos May Allah protect you .

  • @oumaimabenjouida6724
    @oumaimabenjouida67242 жыл бұрын

    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

  • @ikennashonowo9250
    @ikennashonowo92502 жыл бұрын

    Jesus bless you for the work you do. Thanks this and other videos you have made are of tremendous help. Thanks

  • @user-vt6fz4wq9b
    @user-vt6fz4wq9b2 жыл бұрын

    Mashallah. Good job.

  • @yunmyeonghun
    @yunmyeonghun2 жыл бұрын

    Yes we need Flyway tutorial ! Please

  • @gasparcalix2095
    @gasparcalix2095 Жыл бұрын

    Grate content!

  • @asl1dd1nChor1ev
    @asl1dd1nChor1ev2 жыл бұрын

    you are my hero, bro

  • @hichamloukili3910
    @hichamloukili3910 Жыл бұрын

    Good job Man

  • @adeleyeadedolapo1145
    @adeleyeadedolapo11452 жыл бұрын

    Great content, I love your videos. Please do a video on "FLYWAY"

  • @jibinjames5128
    @jibinjames51282 жыл бұрын

    Great man keep going

  • @azizbekibnhamid642
    @azizbekibnhamid64210 ай бұрын

    Thanks you very much

  • @labibali1009
    @labibali10092 жыл бұрын

    Great content my brother

  • @Krazness
    @Krazness Жыл бұрын

    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

  • @sovrinfo
    @sovrinfo2 жыл бұрын

    Thank you a lot

  • @majidabdolhosseini4449
    @majidabdolhosseini4449 Жыл бұрын

    Good job 👏

  • @GG-ic7wc
    @GG-ic7wc2 жыл бұрын

    Great tutorial

  • @walterwhite7167
    @walterwhite7167 Жыл бұрын

    thank you so much

  • @Lokoislive
    @Lokoislive2 жыл бұрын

    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?

  • @VeereshPatel15
    @VeereshPatel152 жыл бұрын

    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

  • @JSneider05
    @JSneider052 жыл бұрын

    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

    @BlessingRajasingh

    2 жыл бұрын

    Always rock jdbc

  • @AllenIve3

    @AllenIve3

    2 жыл бұрын

    Why ?

  • @omnipoten8
    @omnipoten82 жыл бұрын

    Nice tutorial. Thanks. One question, Is it possible to establish relationships between entities(records) like OneToMany, ManyToMany etc?

  • @reflection648
    @reflection6482 жыл бұрын

    Asalam O Aalikum ! thankyou so much for your tutorials.please also create content for flyway

  • @user-ji6nk8fo8r
    @user-ji6nk8fo8r Жыл бұрын

    Great!

  • @ahmetfatihcenesiz4569
    @ahmetfatihcenesiz45692 жыл бұрын

    best Amigo!

  • @valmirknasel
    @valmirknasel Жыл бұрын

    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?

  • @ahmadalalloush9962
    @ahmadalalloush99622 жыл бұрын

    Thanks :)

  • @ibrahimqassem2254
    @ibrahimqassem22542 жыл бұрын

    This subject is desired 👍

  • @orefalomo335
    @orefalomo3352 жыл бұрын

    Awesome video.

  • @dharmendrakumarknowledgewala
    @dharmendrakumarknowledgewala2 жыл бұрын

    Good Work

  • @vietronaldo23w
    @vietronaldo23w2 жыл бұрын

    thanks bro.

  • @Ibrahimabdalaziz-xo8mx
    @Ibrahimabdalaziz-xo8mx2 ай бұрын

    Niiiice!!

  • @soundrarajanv9136
    @soundrarajanv91362 жыл бұрын

    Thalaivar is back

  • @sylleryum
    @sylleryum2 жыл бұрын

    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

    @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

  • @mobiletraderkpk
    @mobiletraderkpk2 жыл бұрын

    Keep on!

  • @abdallahalhaddad3463
    @abdallahalhaddad34632 жыл бұрын

    Thanks For Sharing

  • @djoleezcool
    @djoleezcool2 жыл бұрын

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

  • @rizwanfirdous
    @rizwanfirdous2 жыл бұрын

    السلام عليكم ورحمة الله وبركاته Please make video on flyway and liquibase , and also cover the comparison between those . Thanks

  • @mahmoudal-rawy7761
    @mahmoudal-rawy7761 Жыл бұрын

    ❣❣❣❣❣❣❣ thanks brother

  • @BlvkIsMyVibe
    @BlvkIsMyVibe2 жыл бұрын

    You're an excellent teacher. Do you have a mentorship program?

  • @malicious8909
    @malicious89092 жыл бұрын

    The legend🤩

  • @thenightfestival1506
    @thenightfestival15062 жыл бұрын

    amazing 🤩

  • @user-yr2pu3to1t
    @user-yr2pu3to1t2 жыл бұрын

    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?

  • @aminechatate8487
    @aminechatate84872 жыл бұрын

    Salamo Alikom, Thank you for this tutorial. I want to know why we have to choose jdbc instead of jparepository for exemple?

  • @katekomlevaJD
    @katekomlevaJD Жыл бұрын

    Pls make video about Flyway!!

  • @sandeepsaini260
    @sandeepsaini2602 жыл бұрын

    amazing

  • @samuelkagichu3487
    @samuelkagichu348710 ай бұрын

    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

Келесі