JDBC Tutorial - Crash Course

Ever looked for a comprehensive intro to JDBC that is fun and entertaining at the same time? Then have a look at this brand-new episode of "Marco Codes": JDBC Tutorial [Crash Course].

In this video, you'll learn how to use JDBC, i.e. the basic API that every Java program uses to access databases. Understand what JDBC drivers are and where to get them. How to use an embedded H2 database, in addition to the usual suspects like MySQL or Postgres. Fire off SQL select, insert, update and delete statements from Java. And finally learn about connection pools and the overall Java database framework/library landscape. By the end of the tutorial, there won't be many questions left when it comes to accessing databases with Java.

► References

► Table Of Contents
00:00 Intro
00:16 Project Overview
01:05 H2 Database Setup
02:01 JDBC Driver List
02:41 DriverManager
03:37 JDBC Urls - Overview
04:16 H2 JDBC Url - Options
07:02 H2 - Schema/Data Initialization
10:10 SQL - SELECT FROM
10:52 SQL Injection
13:52 SQL - INSERT INTO
15:16 SQL - UPDATE
16:11 SQL - DELETE
17:32 DataSource
18:37 Connection Pools
19:22 HikariCP
22:56 Library Landscape

► FOLLOW ME

[marcobehler]

► Timestamps
00:00 Intro
00:16 Project Overview
01:05 H2 Database Setup
02:01 JDBC Driver List
02:41 DriverManager
03:37 JDBC Urls - Overview
04:16 H2 JDBC Url - Options
07:02 H2 - Schema/Data Initialization
10:10 SQL - SELECT FROM
10:52 SQL Injection
13:52 SQL - INSERT INTO
15:16 SQL - UPDATE
16:11 SQL - DELETE
17:32 DataSource
18:37 Connection Pools
19:22 HikariCP
22:56 Library Landscape

[milanstojkovic]

Every tutorial is soooo good. Please, continue with such a good and educative content

[MirekKrenc]

I really appreciate your effort to make the tutorials so easy to follow and to understand. I like your style of teaching a lot here in yt and also from your paid tutorials. Keep it up!

[thomaswaljor]

I like your clear explanations and the structure and order of the available topics in each video. It was a joy to watch your videos :)

[nicudomenti]

Thank you very much ! You saved a lot of time not only for me but for anyone who would like to learn about JDBC in future !

[nfdgrnv]

Every tutorial is very good. Please, continue with such a good and educative content.
You explain everything so simple.
Thanks Marco

[vs]

I like how you explain these things Marco. Brilliant! Keep up the good work!

[sebon]

Dude, your exaplanations are AMAZING & very cool & great, you deserve waaay more views. Thanks for the video!

[mistguides]

Thank you for all the effort! Subscribed as a gratitude.

[mkhadka]

clear and to the point, great video thanks marco :)

[iamsnglrty]

I just watched this video just now and it was both informative and entertaining. Thank you for making learning enjoyable! 👏👏👏

[xSferQx]

I fought so long with H2 becuase maven dependency by default had test scope and I didn't notice it. I was so lucky i watched your maven tutorial before :D

[viniciusbarbosa]

It's so cool to understand how it works under the hood

[MaximPerepelitsyn]

Thanks a lot Marco for your work, and for sharing your knowledge with peasant devs such as myself (:

[A]

Lol, you said "Sayonara" at the end

[goldgold]

Hi,
Pls make a video on
1)shortcuts used for pro devs,
2) productivity tools used in linux terminal
3) cool linux tools that pros use,
4) best tools to view logs in linux terminal
5) debugging tricks in linux...
6) without remote debug any way to change java code in jar...
7) maven build speedup tricks
8)any way to monitor live java program internals??
9) best ways to quickly understand new code base
10)tool to add logs automatically to record all variables in java program.
11) must have eclipse plugins
12)most commonly seen java program errors.
13) u r fav debuggin tips


You blogs changed my life man.. I was searching for such kind of simple straight forward explanation for a long time... Please do seo on it.. Every new java developer must read it... You are like a God to me for teaching java... Thanks man.. God bless you...

[ciprianmunteanu]

At 21:08, is the problem that, due to Hikari opening multiple connections to the database, the SQL script is also run multiple times ? Also, great video!

[mauritianallstar]

Great tutorial, what live templates are you using in intellij? Useful one I saw was to create variable without using alt+enter

[SineQuaNon]

At 15.25, how did you do the replace insert to update? That was too fast, I couldn't catch it.

[ikbo]

Is there an asynchronous version of jdbc?