Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

LinkedIn Learning

Java: Database Integration with JDBC

via LinkedIn Learning

Overview

Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
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.

Syllabus

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

Taught by

David Gassner

Reviews

4.4 rating at LinkedIn Learning based on 328 ratings

Start your review of Java: Database Integration with JDBC

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.