JDBC: An Introduction to Java Database Connectivity


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level


Overview/Description

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.



Expected Duration (hours)
1.2

Lesson Objectives

JDBC: An Introduction to Java Database Connectivity

  • discover the key concepts covered in this course
  • describe the role of JDBC and JDBC drivers in enabling interactions between a Java app and a database
  • identify the different JDBC objects that enable a Java app to work with a database, and recall the roll played by each of them
  • recognize the role played by a ResultSet in navigating over and modifying the contents of tabular data
  • recall the specific types of RowSets available in JDBC and their specific features and use cases
  • describe the role of batch updates and transactions when working with JDBC
  • download and install MySQL and the MySQL Workbench tool
  • write a Java app that connects to a database using JDBC
  • configure a Java app to use a JDBC driver when connecting to a database
  • set up a Maven project to work with a JDBC driver
  • summarize the key concepts covered in this course

    • Course Number:
    it_jmjdbcdj_01_enus

    Expertise Level
    Beginner