When building Java apps which interact with a database, you may need to work with stored procedures and also large binary objects. The goal of this course is to give you hands-on experience with the handling of binary and text data and working with stored procedures. You will load image and text files from your file system to a database using JDBC, and will then do the reverse operations. You will also create and execute a variety of stored procedures from a Java app.

Before getting your hands dirty with Java Database Connectivity (JDBC), it is important to recognize its purporse and the options it has to offer - and this is exactly what this course provides. It first lays a theoretical foundation in terms of the need for JDBC, the various pieces which come together to let your app connect to a database, as well as their features and use cases. You will cover topics such as JDBC drivers, JDBC objects such as Statement , ResultSet, and RowSet, and then connect a Java app to a database.

Java Database Connectivity (JDBC) offers a number of ways in which SQL queries can be executed using a number of built-in objects. This demo-based course covers the use of the fundamental JDBC objects required to set up and manage database connections from a Java app and to execute queries. You will cover the use of Properties objects to load connection details, and then the use of the Statement and PreparedStatement instances to run SELECT, INSERT, DELETE and UPDATE queries against a database from a Java app.

The JDBC RowSet offers the same functionality as a ResultSet with several useful additional features. This course involves a number of demos covering different RowSet types. You will explore the features of the JdbcRowSet which is a type of connected RowSet and is similar to a ResultSet. You will then cover different flavors of disconnected RowSets - from the CachedRowSet and the WebRowSet to performing offline joins using the JoinRowSet and filtering rows using the FilteredRowSet.

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.