Java Database Connectivity (JDBC): An Introduction to JDBC

Java JDK 8+    |    Beginner
  • 11 Videos | 1h 33m 52s
  • 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 14s
    UP NEXT
  • Playable
    2. 
    Installing MySQL Server and MySQL Workbench
    8m 43s
  • Locked
    3. 
    Creating a Maven Project
    10m 49s
    FREE ACCESS
  • Locked
    4. 
    Connecting to a Database Using JDBC
    8m 41s
    FREE ACCESS
  • Locked
    5. 
    Applying a DataSource Instance for Connections
    10m 39s
    FREE ACCESS
  • Locked
    6. 
    Running Queries with a Statement Object
    10m 36s
    FREE ACCESS
  • Locked
    7. 
    Processing Query Results with a ResultSet
    4m 42s
    FREE ACCESS
  • Locked
    8. 
    Parametrizing Queries with a PreparedStatement
    12m 4s
    FREE ACCESS
  • Locked
    9. 
    Executing Inserts with a PreparedStatement
    8m 31s
    FREE ACCESS
  • Locked
    10. 
    Updating and Deleting Queries Using JDBC
    10m 14s
    FREE ACCESS
  • Locked
    11. 
    Course Summary
    2m 8s
    FREE ACCESS

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

COURSE Working with Spring Data JDBC: Spring Data JDBC & the CrudRepository
Likes 3 Likes 3  
COURSE Java Web Services: Integrating Web Services with a Database
Likes 0 Likes 0  
COURSE Java Certified Foundations Associate: Looping Statements
Likes 0 Likes 0