JDBC: Working with ResultSets & Query Batches

Java JDBC    |    Beginner
  • 15 videos | 1h 45m 27s
  • Includes Assessment
  • Earns a Badge
Likes 4 Likes 4
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
  • Playable
    2.  Types of ResultSets
    7m 55s
    In this video, find out how to identify the types of ResultSets available in JDBC. FREE ACCESS
  • Locked
    3.  Navigating over a ResultSet
    9m 1s
    In this video, learn how to scroll through a ResultSet to access data in various locations. FREE ACCESS
  • Locked
    4.  The TYPE_FORWARD_ONLY ResultSet
    6m 21s
    Upon completion of this video, you will be able to recognize the limitations of a ResultSet that is TYPE_FORWARD_ONLY. FREE ACCESS
  • Locked
    5.  Updating Data while Navigating a ResultSet
    8m 17s
    In this video, find out how to refresh the contents of a ResultSet while iterating over its contents. FREE ACCESS
  • Locked
    6.  Adding Rows while Navigating a ResultSet
    7m 24s
    Upon completion of this video, you will be able to recognize the types of modifications that a ResultSet may not detect. FREE ACCESS
  • Locked
    7.  Updating a ResultSet
    8m 56s
    In this video, find out how to modify the contents of a SQL table by updating a ResultSet. FREE ACCESS
  • Locked
    8.  Deleting from a ResultSet
    9m 9s
    In this video, find out how to remove data from a SQL table by performing deletes from a ResultSet. FREE ACCESS
  • Locked
    9.  Modifying a Read-only ResultSet
    3m 39s
    In this video, learn how to identify potential issues when trying to modify a ResultSet that is set to read-only. FREE ACCESS
  • Locked
    10.  An Introduction to Batch Operations
    8m 17s
    Find out how to group similar INSERT queries together into a batch to optimize their executions. FREE ACCESS
  • Locked
    11.  Prepared Statements and Batch Operations
    8m 6s
    During this video, you will learn how to combine the optimizations of batch executions and batch updates. FREE ACCESS
  • Locked
    12.  Partially Executed Operations
    7m 14s
    Upon 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
  • Locked
    13.  Transactions Using JDBC
    9m 26s
    Find out how to use the rollback feature of JDBC to undo modifications after an exception is thrown. FREE ACCESS
  • Locked
    14.  Savepoints in Java
    7m 12s
    Learn how to perform a partial rollback by implementing savepoints in a Java app. FREE ACCESS
  • 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 on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 2074 Likes 2074  
Likes 10 Likes 10