Learn how to manage data from relational databases such as Postgres, Oracle Database, MySQL, and SQL Server using Java Database Connectivity (JDBC) in Java programmed applications.
Overview
Syllabus
Introduction
- Get going with data access in Java
- What you need to know
- Welcome to RDBMS
- Welcome to JDBC
- Terminology of JDBC
- Introduction to PostgreSQL
- Using containerized PostgreSQL
- Creating the project
- CRUD
- Using a driver
- The DAO pattern
- Creating data
- Understanding result sets
- Reading data
- Updating data
- Deleting data
- The repository pattern
- Challenge: Implement a DAO
- Solution: Implement a DAO
- Using stored procedures
- Ordering and limiting results
- Paging
- Connection pooling and management
- Understanding transactions
- Commits and rollbacks
- Exception handling in JDBC
- JPA and ORM
- Next steps
Taught by
Frank P Moley III
