Learning 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