Learning JDBC
2h 1mBeginner2024-10-25
Authors
Frank P Moley III
Senior Principal Engineer at Catch&Release
Course details
Whether developers want to build mobile device apps for Android, 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
Implement the Java Database Connectivity (JDBC) API to integrate data from relational databases such as Postgres, Oracle Database, MySQL, and SQL Server into Java applications.
Analyze and apply techniques for selecting, updating, and managing data using JDBC in Java programs.
Evaluate and handle exceptions and transactions when working with databases through JDBC in Java.
Learning objectives
Implement the Java Database Connectivity (JDBC) API to integrate data from relational databases such as Postgres, Oracle Database, MySQL, and SQL Server into Java applications.
Analyze and apply techniques for selecting, updating, and managing data using JDBC in Java programs.
Evaluate and handle exceptions and transactions when working with databases through JDBC in Java.
Skills covered
APIsSoftware DevelopmentOne-Off
Concepts
0. Introduction
- 01 - Get going with data access in Java
- 02 - What you need to know
1. Introducing Java Data Access
- 03 - Relational database management systems
- 04 - Java Database Connectivity
- 05 - Terminology of JDBC
- 06 - Introduction to PostgreSQL
- 07 - Setting up Postgresql
- 08 - Creating the project
- 09 - Create, read, update, and delete (CRUD)
2. Data Access Basics
- 10 - Using a driver
- 11 - The Data Access Object (DAO) pattern
- 12 - Understanding result sets
- 13 - Reading all data
- 14 - Reading instance data
- 15 - Creating data
- 16 - Updating data
- 17 - Deleting data
- 18 - The Repository pattern
- 19 - Challenge - Implement a DAO
- 20 - Solution - Implement a DAO
3. Advanced Data Access
- 21 - Using stored procedures
- 22 - Ordering and limiting results
- 23 - Paging
- 24 - Connection pooling and management
- 25 - Understanding transactions
- 26 - Exception handling in JDBC
Conclusion
- 27 - JPA and ORM
- 28 - Next steps