JDBC: Executing Statements

Java JDBC    |    Beginner
  • 14 videos | 1h 24m 16s
  • Includes Assessment
  • Earns a Badge
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

  • 2m 19s
  • 6m 16s
    In this video, find out how to identify the different ways to specify connection details when connecting to a database using JDBC. FREE ACCESS
  • Locked
    3.  Loading Connection Details from a Properties File
    7m 52s
    In this video, you will use database connection details from a properties file to set up a connection to a database using JDBC. FREE ACCESS
  • Locked
    4.  Connecting to a Database with a DataSource
    5m 57s
    In this video, you will learn how to create a connection to a database using a DataSource object. FREE ACCESS
  • Locked
    5.  Running a Query from Java
    8m 42s
    In this video, you will learn how to execute a SQL query to create a database table from a Java application. FREE ACCESS
  • Locked
    6.  Retrieving Query Results in a ResultSet
    7m 19s
    During this video, you will learn how to run a SELECT query against a database and access the tabular data returned in a JDBC ResultSet object. FREE ACCESS
  • Locked
    7.  Running Insert Queries from Java
    4m 37s
    Learn how to add rows to a database table by running an INSERT query from a Java application. FREE ACCESS
  • Locked
    8.  Running Update and Delete Queries
    6m 37s
    In this video, you will learn how to modify the contents of a database table from a Java app by executing UPDATE and DELETE queries. FREE ACCESS
  • Locked
    9.  Running Drop Queries
    6m 36s
    In this video, you will learn how to drop a table and database from a Java app. FREE ACCESS
  • Locked
    10.  Potential Inefficiencies in Statement Executions
    6m 58s
    Upon completion of this video, you will be able to recognize the limitations of the Statement object when several executions of similar queries are involved. FREE ACCESS
  • Locked
    11.  Using Prepared Statements
    7m 51s
    In this video, you will learn how to optimize the execution of similar queries by parametrizing them with PreparedStatements. FREE ACCESS
  • Locked
    12.  Setting Incorrect Parameters in Statements
    2m 37s
    After completing this video, you will be able to recall the types of exceptions that could occur when passing incorrect parameters to a PreparedStatement. FREE ACCESS
  • Locked
    13.  Handling SQL Exceptions
    9m 9s
    During this video, you will learn how to identify some of the exceptions that could be thrown when using JDBC to work with databases. FREE ACCESS
  • 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 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 Certified Foundations Associate: Data Types
Journey Javanista to Java Master
Course JDBC: Advanced Topics

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Java Database Connectivity (JDBC): Interacting with Databases using RowSets
Course Collections in Java: Arrays & Non-parameterized ArrayLists
Course JDBC: Advanced Topics