JDBC: Working with ResultSets & Query Batches
Java
| 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 course
Identify the types of resultsets available in jdbc
Scroll through a resultset to access data in various locations
Recognize the limitations of a type_forward_only resultset
Refresh the contents of a resultset while iterating over its contents
Recognize the types of modifications that a resultset may not pick up
Modify the contents of a sql table by updating a resultset
Remove data from a sql table by performing deletes from a resultset -
Identify potential issues when trying to modify a read-only resultset
Group similar insert queries together into a bath to optimize their executions
Combine the optimizations of batch executions and batch updates
Describe how the auto-commit feature may prevent queries from running as a transaction
Use the rollback feature of jdbc to undo modifications after an exception is thrown
Perform a partial rollback by implementing savepoints in a java app
Summarize 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
-
3. Navigating over a ResultSet9m 1sIn this video, learn how to scroll through a ResultSet to access data in various locations. FREE ACCESS
-
4. The TYPE_FORWARD_ONLY ResultSet6m 21sUpon completion of this video, you will be able to recognize the limitations of a ResultSet that is TYPE_FORWARD_ONLY. FREE ACCESS
-
5. Updating Data while Navigating a ResultSet8m 17sIn this video, find out how to refresh the contents of a ResultSet while iterating over its contents. FREE ACCESS
-
6. Adding Rows while Navigating a ResultSet7m 24sUpon completion of this video, you will be able to recognize the types of modifications that a ResultSet may not detect. FREE ACCESS
-
7. Updating a ResultSet8m 56sIn this video, find out how to modify the contents of a SQL table by updating a ResultSet. FREE ACCESS
-
8. Deleting from a ResultSet9m 9sIn this video, find out how to remove data from a SQL table by performing deletes from a ResultSet. FREE ACCESS
-
9. Modifying a Read-only ResultSet3m 39sIn this video, learn how to identify potential issues when trying to modify a ResultSet that is set to read-only. FREE ACCESS
-
10. An Introduction to Batch Operations8m 17sFind out how to group similar INSERT queries together into a batch to optimize their executions. FREE ACCESS
-
11. Prepared Statements and Batch Operations8m 6sDuring this video, you will learn how to combine the optimizations of batch executions and batch updates. FREE ACCESS
-
12. Partially Executed Operations7m 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
-
13. Transactions Using JDBC9m 26sFind out how to use the rollback feature of JDBC to undo modifications after an exception is thrown. FREE ACCESS
-
14. Savepoints in Java7m 12sLearn how to perform a partial rollback by implementing savepoints in a Java app. FREE ACCESS
-
15. Course Summary1m 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.
