Course details

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

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


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description

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.



Expected Duration (hours)
0.9

Lesson Objectives

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

  • discover the key concepts covered in this course
  • list the contents of the java.sql package
  • connect to databases using JDBC URL and DriverManager
  • use PreparedStatement to perform CRUD operations
  • use the PreparedStatement and CallableStatement APIs to perform database operations
  • recall how the various SQL types are mapped to classes and interfaces in Java
  • recognize enhancements to the features of the javax.sql package
  • use the DatabaseMetaData and ParameterMetaData interfaces
  • describe the Enum classes and how they are used in JDBC
  • list the RowSet objects that can be used to hold tabular data
  • use RowSet objects to manage data
  • summarize the key concepts covered in this course
  • Course Number:
    it_sdjsep_16_enus

    Expertise Level
    Intermediate