Java Database Connectivity (JDBC): Joining & Filtering Data with RowSets
Java JDK 8+ | Intermediate
- 9 videos | 1h 9m 51s
- Includes Assessment
- Earns a Badge
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.
WHAT YOU WILL LEARN
discover the key concepts covered in this coursecreate a number of related database tables, which can be joined based on common fieldsimplement a join operation in a Java program using a JDBC JoinRowSetrecognize the types of join operations that are supported by a JoinRowSet implementationjoin multiple tables involving different join fields using a JoinRowSet
define the filtering conditions to be applied to a FilteredRowSet when implementing the Predicate classapply a predicate instance with a FilteredRowSet to apply a filter to a RowSetconfigure a predicate implementation to use multiple conditions when defining a filtersummarize the key concepts covered in this course
IN THIS COURSE
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
Course JDBC: Executing Statements