Java Database Connectivity (JDBC): Joining & Filtering Data with RowSets

Skillsoft issued completion badges are earned based on viewing the percentage required or receiving a passing score when assessment is required. A CachedRowSet is a Java Database Connectivity (JDBC) RowSet where the rows are cached, and the RowSet is disconnected (i.e., doesn't maintain an active connection to the database). CachedRowSets allow you to work on data without keeping your database connection open all the time. This course will help you get acquainted with specialized implementations of the CachedRowSet - the JoinRowSet and FilteredRowSet - which enable offline joins and data filtering. Discover how to implement join operations using a JoinRowSet and examine the use of a FilteredRowSet in implementing the equivalent of the WHERE clause in a SQL query. You will also explore the use of predicate class in order to achieve this. Upon completion of this course, you'll be able to carry out join and filter operations within a Java program using JDBC JoinRowSets and FilteredRowSets.