Learning JDBC (2019)

Course details

Whether developers want to build mobile device apps for Android or web-based or desktop-based applications with the core Java SDK from Oracle, they must contend with the fact that many dynamic applications need to integrate data from a relational database. In this course, Frank Moley helps you get up to speed with the Java Database Connectivity (JDBC) API, showing how to use it to read and manage data from relational databases such as Postgres, Oracle Database, MySQL, and SQL Server in applications programmed with Java. Frank begins by going over key JDBC terminology, the basics of configuring a PostgreSQL database, and how to create the course project. He then provides detailed instructions on how to select and update data, work with transactions, handle exceptions, and more.

Learning objectives
Deciphering JDBC terminology
Using containerized PostgreSQL
Creating, reading, updating, and deleting data
The Repository pattern
Using stored procedures
Ordering and limiting results
Transactions in JDBC
Handling exceptions

Concepts

0. Introduction

01 - Get going with data access in Java
02 - What you need to know

1. Introducing Java Data Access

03 - Welcome to RDBMS
04 - Welcome to JDBC
05 - Terminology of JDBC
06 - Introduction to PostgreSQL
07 - Using containerized PostgreSQL
08 - Creating the project
09 - CRUD

2. Data Access Basics

10 - Using a driver
11 - The DAO pattern
12 - Creating data
13 - Understanding result sets
14 - Reading data
15 - Updating data
16 - Deleting data
17 - The repository pattern
18 - Challenge - Implement a DAO
19 - Solution - Implement a DAO

3. Advanced Data Access

20 - Using stored procedures
21 - Ordering and limiting results
22 - Paging
23 - Connection pooling and management

4. Transactions

24 - Understanding transactions
25 - Commits and rollbacks
26 - Exception handling in JDBC

Conclusion

27 - JPA and ORM
28 - Next steps

Learning JDBC (2019)

Authors

Frank P Moley III