JDBC: Working with ResultSets & Query Batches

Java JDBC    |    Beginner
  • 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
    FREE ACCESS
  • Locked
    4. 
    The TYPE_FORWARD_ONLY ResultSet
    6m 21s
    FREE ACCESS
  • Locked
    5. 
    Updating Data while Navigating a ResultSet
    8m 17s
    FREE ACCESS
  • Locked
    6. 
    Adding Rows while Navigating a ResultSet
    7m 24s
    FREE ACCESS
  • Locked
    7. 
    Updating a ResultSet
    8m 56s
    FREE ACCESS
  • Locked
    8. 
    Deleting from a ResultSet
    9m 9s
    FREE ACCESS
  • Locked
    9. 
    Modifying a Read-only ResultSet
    3m 39s
    FREE ACCESS
  • Locked
    10. 
    An Introduction to Batch Operations
    8m 17s
    FREE ACCESS
  • Locked
    11. 
    Prepared Statements and Batch Operations
    8m 6s
    FREE ACCESS
  • Locked
    12. 
    Partially Executed Operations
    7m 14s
    FREE ACCESS
  • Locked
    13. 
    Transactions Using JDBC
    9m 26s
    FREE ACCESS
  • Locked
    14. 
    Savepoints in Java
    7m 12s
    FREE ACCESS
  • Locked
    15. 
    Course Summary
    1m 46s
    FREE ACCESS

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

COURSE Database Integration: Modeling Data Using JPA & Hibernate
Likes 3 Likes 3  
COURSE Java Web Services: Enabling CRUD Operations with REST APIs
Likes 0 Likes 0  
COURSE Working with Spring Data JDBC: Configuring Derived Query Methods
Likes 1 Likes 1