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.YOU MIGHT ALSO LIKE
Rating 4.0 of 7 users
(7)
