Java Database Connectivity (JDBC): An Introduction to JDBC

Java JDK 8+
  • 11 Videos | 1h 29m 55s
  • 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.

WHAT YOU WILL LEARN

  • 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

IN THIS COURSE

  • Playable
    1. 
    Course Overview
    2m 17s
    UP NEXT
  • Playable
    2. 
    Installing MySQL Server and MySQL Workbench
    8m 46s
  • Locked
    3. 
    Creating a Maven Project
    10m 52s
  • Locked
    4. 
    Connecting to a Database Using JDBC
    8m 44s
  • Locked
    5. 
    Applying a DataSource Instance for Connections
    10m 42s
  • Locked
    6. 
    Running Queries with a Statement Object
    10m 39s
  • Locked
    7. 
    Processing Query Results with a ResultSet
    4m 45s
  • Locked
    8. 
    Parametrizing Queries with a PreparedStatement
    12m 7s
  • Locked
    9. 
    Executing Inserts with a PreparedStatement
    8m 34s
  • Locked
    10. 
    Updating and Deleting Queries Using JDBC
    10m 17s
  • Locked
    11. 
    Course Summary
    2m 11s

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.