Java: Database Integration with JDBC

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.

Introduction

• Get going with data access in Java
• What you need to know

1. Introducing Java Data Access

• Welcome to RDBMS
• Welcome to JDBC
• Terminology of JDBC
• Introduction to PostgreSQL
• Using containerized PostgreSQL
• Creating the project
• CRUD

2. Data Access Basics

• 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

3. Advanced Data Access

• Using stored procedures
• Ordering and limiting results
• Paging
• Connection pooling and management

4. Transactions

• Understanding transactions
• Commits and rollbacks
• Exception handling in JDBC

Conclusion

• JPA and ORM
• Next steps