JDBC: Working with ResultSets & Query Batches
Java JDBC
| Beginner
- 15 videos | 1h 45m 27s
- Includes Assessment
- Earns a Badge
ResultSets allow SELECT query results to be processed systematically in a Java app while executing INSERT and UPDATE queries can be handled efficiently with query batches. This is very much a hands-on course and gets into the nitty-gritty of processing large volumes of data using JDBC. You will cover a lot of features of the ResultSet object - from its navigability to its ability to update data. You will also optimize updates by running them in a batch, and cover the implementations of atomic transactions when using JDBC.
WHAT YOU WILL LEARN
-
discover the key concepts covered in this courseidentify the types of ResultSets available in JDBCscroll through a ResultSet to access data in various locationsrecognize the limitations of a TYPE_FORWARD_ONLY ResultSetrefresh the contents of a ResultSet while iterating over its contentsrecognize the types of modifications that a ResultSet may not pick upmodify the contents of a SQL table by updating a ResultSetremove data from a SQL table by performing deletes from a ResultSet
-
identify potential issues when trying to modify a read-only ResultSetgroup similar INSERT queries together into a bath to optimize their executionscombine the optimizations of batch executions and batch updatesdescribe how the auto-commit feature may prevent queries from running as a transactionuse the rollback feature of JDBC to undo modifications after an Exception is thrownperform a partial rollback by implementing Savepoints in a Java appsummarize the key concepts covered in this course
IN THIS COURSE
-
2m 46s
-
7m 55sIn this video, find out how to identify the types of ResultSets available in JDBC. FREE ACCESS
-
9m 1sIn this video, learn how to scroll through a ResultSet to access data in various locations. FREE ACCESS
-
6m 21sUpon completion of this video, you will be able to recognize the limitations of a ResultSet that is TYPE_FORWARD_ONLY. FREE ACCESS
-
8m 17sIn this video, find out how to refresh the contents of a ResultSet while iterating over its contents. FREE ACCESS
-
7m 24sUpon completion of this video, you will be able to recognize the types of modifications that a ResultSet may not detect. FREE ACCESS
-
8m 56sIn this video, find out how to modify the contents of a SQL table by updating a ResultSet. FREE ACCESS
-
9m 9sIn this video, find out how to remove data from a SQL table by performing deletes from a ResultSet. FREE ACCESS
-
3m 39sIn this video, learn how to identify potential issues when trying to modify a ResultSet that is set to read-only. FREE ACCESS
-
8m 17sFind out how to group similar INSERT queries together into a batch to optimize their executions. FREE ACCESS
-
8m 6sDuring this video, you will learn how to combine the optimizations of batch executions and batch updates. FREE ACCESS
-
7m 14sUpon completion of this video, you will be able to describe how the auto-commit feature may prevent queries from running as a transaction. FREE ACCESS
-
9m 26sFind out how to use the rollback feature of JDBC to undo modifications after an exception is thrown. FREE ACCESS
-
7m 12sLearn how to perform a partial rollback by implementing savepoints in a Java app. FREE ACCESS
-
1m 46s
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.
Digital badges are yours to keep, forever.YOU MIGHT ALSO LIKE

Book
Beginning jOOQ