Aspire     Java Novice to Javanista     Java Novice to Javanista Track 3: Javanista

---

In scenarios where an application has to issue several updates, performing them in batches greatly benefits performance. A set of updates can then be wrapped in an interaction that either succeeds or fails altogether with the help of transactions in relational databases. Use this course to explore the implementation of advanced database operations using Java Database Connectivity (JDBC), specifically batch executions and transactions.
Discover how executions of multiple similar queries can be optimized by aggregating them together in a batch and then executing them together and learn to set up queries to execute as transactions. You will also examine concepts, such as rollbacks, commits, and savepoints, and how these can be implemented using JDBC.
You will be able to implement batch executions and transactions in a Java program using JDBC.

---

---

Objectives

Java Database Connectivity (JDBC): Batch Executions & Transactions with JDBC discover the key concepts covered in this course use a Statement object to run a series of INSERT queries as a batch perform a batch execution of parameterized queries using a PreparedStatement describe the behavior of a batch execution, where some queries are invalid recognize the limitations of running related SQL queries independently identify the steps involved in running a set of related queries as a transaction divide a large chunk of queries into units that can be committed to a database using Savepoints use Savepoints in batch executions and recognize the behavior of a program when this is done summarize the key concepts covered in this course