Java Database Connectivity (JDBC): An Introduction to JDBC

Java    |    Beginner
  • 11 videos | 1h 29m 22s
  • Includes Assessment
  • Earns a Badge
Java Database Connectivity (JDBC) is the Java application programming interface (API) that manages the connection and execution of queries with a database. The focus of this course is to provide you hands-on experience with a variety of JDBC objects that are required to set up a connection to a relational database and run queries against it. Learn how to set up a MySQL database and use DataSource and Data Manager instances to connect to it from your Java application. Delve into objects such as Statements and PreparedStatements that enable you to execute a variety of queries against the database and familiarize yourself with the ResultSet that allows you to parse the results of the execution of a select query. You'll have the foundational knowledge to connect to and query against databases using JDBC objects after completing this course.


  • Discover the key concepts covered in this course
    Set up your machine with a mysql server and a client application to interact with it
    Create a maven project which uses the mysql connector
    Configure jdbc objects in order to connect to a database
    Use a datasource instance rather than a drivermanager in order to connect to a database from a java app
    Execute select queries against a database using a jdbc statement
  • Use a resultset in order to access and parse the results of a select query
    Create, load, and run parameterized sql queries using the jdbc preparedstatement
    Set multiple parameters in a preparedstatement in order to run insert queries
    Execute update and delete queries and explore the data returned for each execution
    Summarize the key concepts covered in this course


  • 2m 14s
  • 8m 43s
  • Locked
    3.  Creating a Maven Project
    10m 49s
  • Locked
    4.  Connecting to a Database Using JDBC
    8m 41s
  • Locked
    5.  Applying a DataSource Instance for Connections
    10m 39s
  • Locked
    6.  Running Queries with a Statement Object
    10m 36s
  • Locked
    7.  Processing Query Results with a ResultSet
    4m 42s
  • Locked
    8.  Parametrizing Queries with a PreparedStatement
    12m 4s
  • Locked
    9.  Executing Inserts with a PreparedStatement
    8m 31s
  • Locked
    10.  Updating and Deleting Queries Using JDBC
    10m 14s
  • Locked
    11.  Course Summary
    2m 8s


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.