Java SE 11 Programmer II: Database Applications

Java SE 11    |    Intermediate
  • 12 Videos | 58m 59s
  • Includes Assessment
  • Earns a Badge
Likes 20 Likes 20
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.

WHAT YOU WILL LEARN

  • 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

IN THIS COURSE

  • Playable
    1. 
    Course Overview
    1m 7s
    UP NEXT
  • Playable
    2. 
    Java.sql Package
    5m 14s
  • Locked
    3. 
    Connecting to Databases
    5m 29s
  • Locked
    4. 
    CRUD Operations with PreparedStatement
    7m 41s
  • Locked
    5. 
    Database Operations and Callable APIs
    5m 26s
  • Locked
    6. 
    SQL Types and Java Mapping
    3m 3s
  • Locked
    7. 
    Enhancements in Javax.sql
    5m 39s
  • Locked
    8. 
    DatabaseMetaData and ParameterMetaData
    5m 22s
  • Locked
    9. 
    Enum Classes in JDBC
    4m 41s
  • Locked
    10. 
    RowSet Objects for Managing Data
    4m 6s
  • Locked
    11. 
    RowSet Object Implementation
    4m 49s
  • Locked
    12. 
    Course Summary
    1m 22s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE