JDBC: Working with ResultSets & Query Batches

Java JDBC
  • 15 Videos | 1h 51m 57s
  • Includes Assessment
  • Earns a Badge
Likes 1 Likes 1
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

  • Playable
    1. 
    Course Overview
    2m 46s
    UP NEXT
  • Playable
    2. 
    Types of ResultSets
    7m 55s
  • Locked
    3. 
    Navigating over a ResultSet
    9m 1s
  • Locked
    4. 
    The TYPE_FORWARD_ONLY ResultSet
    6m 21s
  • Locked
    5. 
    Updating Data while Navigating a ResultSet
    8m 17s
  • Locked
    6. 
    Adding Rows while Navigating a ResultSet
    7m 24s
  • Locked
    7. 
    Updating a ResultSet
    8m 56s
  • Locked
    8. 
    Deleting from a ResultSet
    9m 9s
  • Locked
    9. 
    Modifying a Read-only ResultSet
    3m 39s
  • Locked
    10. 
    An Introduction to Batch Operations
    8m 17s
  • Locked
    11. 
    Prepared Statements and Batch Operations
    8m 6s
  • Locked
    12. 
    Partially Executed Operations
    7m 14s
  • Locked
    13. 
    Transactions Using JDBC
    9m 26s
  • Locked
    14. 
    Savepoints in Java
    7m 12s
  • Locked
    15. 
    Course Summary
    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 of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE