Learning JDBC

Learning JDBC

English | MP4 | AVC 1280×720 | AAC 48KHz 2ch | 2h 14m | 351 MB

Whether developers want to build mobile device apps for Android or 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.

Topics include:

  • Deciphering JDBC terminology
  • Using containerized PostgreSQL
  • Creating, reading, updating, and deleting data
  • The Repository pattern
  • Using stored procedures
  • Ordering and limiting results
  • Transactions in JDBC
  • Handling exceptions
Table of Contents

Introduction
1 Get going with data access in Java
2 What you need to know

Introducing Java Data Access
3 Welcome to relational database management systems RDBMS
4 Welcome to Java Database Connectivity JDBC
5 Terminology of JDBC
6 Introduction to PostgreSQL
7 Using containerized PostgreSQL
8 Creating the project
9 Create read update and delete CRUD

Data Access Basics
10 Using a driver
11 The Data Access Object DAO pattern
12 Creating data
13 Understanding result sets
14 Reading data
15 Updating data
16 Deleting data
17 The Repository pattern
18 Challenge – Implement a DAO
19 Solution – Implement a DAO

Advanced Data Access
20 Using stored procedures
21 Ordering and limiting results
22 Paging
23 Connection pooling and management

Transactions
24 Understanding transactions
25 Commits and rollbacks
26 Exception handling in JDBC

Conclusion
27 Java Persistence API JPA and object- relational mapping ORM
28 Next steps