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.

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

  • 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

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 Java Database Connectivity (JDBC): Batch Executions & Transactions with JDBC
Course JDBC: Executing Statements
Course Java Database Connectivity (JDBC): Joining & Filtering Data with RowSets

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Java OOP: Multi-level Inheritance
Course Exceptions, Utilities, I/O, & JDBC
Course Advanced Features in Java: Working with Lists in Java