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
https://jb.gg/4xdxq5

► 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
https://www.marcobehler.com
https://twitter.com/MarcoBehler

Marco Codes

A beginner-friendly crash course on JDBC fundamentals in Java. Covers connecting to a database using DriverManager with an H2 in-memory database, executing CRUD SQL statements using PreparedStatements (with emphasis on SQL injection prevention via placeholders), iterating ResultSets, and introducing connection pooling via HikariCP DataSource. Also briefly touches on how frameworks like Spring Boot build on top of these JDBC primitives.

JDBC Tutorial - Crash Course