Java Database Connectivity (JDBC): An Introduction to JDBC
Java JDK 8+
| 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 courseset up your machine with a MySQL server and a client application to interact with itcreate a Maven project which uses the MySQL connectorconfigure JDBC objects in order to connect to a databaseuse a DataSource instance rather than a DriverManager in order to connect to a database from a Java appexecute SELECT queries against a database using a JDBC Statement
-
use a ResultSet in order to access and parse the results of a SELECT querycreate, load, and run parameterized SQL queries using the JDBC PreparedStatementset multiple parameters in a PreparedStatement in order to run INSERT queriesexecute UPDATE and DELETE queries and explore the data returned for each executionsummarize the key concepts covered in this course
IN THIS COURSE
-
1.Course Overview2m 14sUP NEXT
-
2.Installing MySQL Server and MySQL Workbench8m 43s
-
3.Creating a Maven Project10m 49s
-
4.Connecting to a Database Using JDBC8m 41s
-
5.Applying a DataSource Instance for Connections10m 39s
-
6.Running Queries with a Statement Object10m 36s
-
7.Processing Query Results with a ResultSet4m 42s
-
8.Parametrizing Queries with a PreparedStatement12m 4s
-
9.Executing Inserts with a PreparedStatement8m 31s
-
10.Updating and Deleting Queries Using JDBC10m 14s
-
11.Course Summary2m 8s
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

BOOK
Beginning jOOQ