Java SE 11 Programmer II: Database Applications

Java    |    Intermediate
  • 12 videos | 53m 59s
  • Includes Assessment
  • Earns a Badge
Rating 4.6 of 30 users Rating 4.6 of 30 users (30)
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

  • 1m 7s
  • 5m 14s
    After completing this video, you will be able to list the contents of the java.sql package. FREE ACCESS
  • Locked
    3.  Connecting to Databases
    5m 29s
    During this video, you will learn how to connect to databases using a JDBC URL and DriverManager. FREE ACCESS
  • Locked
    4.  CRUD Operations with PreparedStatement
    7m 41s
    In this video, you will learn how to use PreparedStatement to perform Create, Read, Update, and Delete operations. FREE ACCESS
  • Locked
    5.  Database Operations and Callable APIs
    5m 26s
    In this video, you will learn how to use the PreparedStatement and CallableStatement APIs to perform database operations. FREE ACCESS
  • Locked
    6.  SQL Types and Java Mapping
    3m 3s
    After completing this video, you will be able to recall how the various SQL types are mapped to classes and interfaces in Java. FREE ACCESS
  • Locked
    7.  Enhancements in Javax.sql
    5m 39s
    Upon completion of this video, you will be able to recognize enhancements to the features of the javax.sql package. FREE ACCESS
  • Locked
    8.  DatabaseMetaData and ParameterMetaData
    5m 22s
    In this video, you will use the DatabaseMetaData and ParameterMetaData interfaces. FREE ACCESS
  • Locked
    9.  Enum Classes in JDBC
    4m 41s
    Upon completion of this video, you will be able to describe Enum classes and how they are used in JDBC. FREE ACCESS
  • Locked
    10.  RowSet Objects for Managing Data
    4m 6s
    After completing this video, you will be able to list the RowSet objects that can be used to hold tabular data. FREE ACCESS
  • Locked
    11.  RowSet Object Implementation
    4m 49s
    In this video, you will use RowSet objects to manage data. FREE ACCESS
  • 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 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 Getting Started with Java: The Fundamentals of Java Programming
Rating 4.5 of 526 users Rating 4.5 of 526 users (526)
Book Java: A Beginner's Guide, Tenth Edition
Book 100+ Solutions in Java: Everything You Need to Know to Develop Java Applications, 2nd Edition

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course MySQL: Views, Indices, & Normal Forms
Rating 4.8 of 85 users Rating 4.8 of 85 users (85)
Course Java SE 11 Programmer II: Streams & Pipelines
Rating 4.5 of 77 users Rating 4.5 of 77 users (77)
Course MySQL: Creating & Updating Tables
Rating 4.7 of 171 users Rating 4.7 of 171 users (171)