1Z0-816 – Java SE 11 Programmer II: Database Applications

In this 12-video course, you can explore the contents of the java.sql package, how various SQL types are mapped to classes and interfaces, and enhancements in the features of the javax.sql package. First, examine the Enum classes and their uses in Java Database Connectivity (JDBC) and RowSet objects that can be used to hold tabular data in Java SE 11, as well as other topics. Take a look at contents of the java.sql package, then observe how to connect to databases by using JDBC URL and DriverManager. You will use PreparedStatement to perform CRUD operations, and the PreparedStatement and CallableStatement application programming interfaces (APIs) to perform database operations. You will recall how various SQL types are mapped to classes and interfaces in Java; learn to recognize enhancements to features of the javax.sql package; and begin to use DatabaseMetaData and ParameterMetaData interfaces. Examine the Enum classes and how they are used in JDBC; list the RowSet objects used to hold tabular data; and finally, observe how to use RowSet objects for managing data. This is one course is a series to prepare for the 1Z0-816: Java SE 11 Programmer II certification exam.