JDBC: Executing Statements

Java JDBC
  • 14 Videos | 1h 30m 16s
  • Includes Assessment
  • Earns a Badge
Likes 4 Likes 4
Java Database Connectivity (JDBC) offers a number of ways in which SQL queries can be executed using a number of built-in objects. This demo-based course covers the use of the fundamental JDBC objects required to set up and manage database connections from a Java app and to execute queries. You will cover the use of Properties objects to load connection details, and then the use of the Statement and PreparedStatement instances to run SELECT, INSERT, DELETE and UPDATE queries against a database from a Java app.

WHAT YOU WILL LEARN

  • discover the key concepts covered in this course
    identify the different ways to specify connection details when connecting to a database using JDBC
    use database connection details in a properties file to set up a connection to a database using JDBC
    adopt a DataSource object to create a Connection with a database
    execute a SQL query to create a database table from a Java app
    run a SELECT query against a database and access the returned tabular data in a JDBC ResultSet object
    add rows to a database table by running an INSERT query from a Java app
  • modify the contents of a database table from a Java app by executing UPDATE and DELETE queries
    drop a table and database from a Java app
    recognize the limitations of the Statement object when several executions of similar queries are involved
    optimize the execution of similar queries by parametrizing them with PreparedStatements
    recall the types of exceptions that could occur when passing incorrect parameters to a PreparedStatement
    identify some of the exceptions that could be thrown when using JDBC to work with databases
    summarize the key concepts covered in this course

IN THIS COURSE

  • Playable
    1. 
    Course Overview
    2m 19s
    UP NEXT
  • Playable
    2. 
    Different Ways to Connect to a Database
    6m 16s
  • Locked
    3. 
    Loading Connection Details from a Properties File
    7m 52s
  • Locked
    4. 
    Connecting to a Database with a DataSource
    5m 57s
  • Locked
    5. 
    Running a Query from Java
    8m 42s
  • Locked
    6. 
    Retrieving Query Results in a ResultSet
    7m 19s
  • Locked
    7. 
    Running Insert Queries from Java
    4m 37s
  • Locked
    8. 
    Running Update and Delete Queries
    6m 37s
  • Locked
    9. 
    Running Drop Queries
    6m 36s
  • Locked
    10. 
    Potential Inefficiencies in Statement Executions
    6m 58s
  • Locked
    11. 
    Using Prepared Statements
    7m 51s
  • Locked
    12. 
    Setting Incorrect Parameters in Statements
    2m 37s
  • Locked
    13. 
    Handling SQL Exceptions
    9m 9s
  • Locked
    14. 
    Course Summary
    1m 28s

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.