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
-
2m 14s
-
8m 43s
-
10m 49s
-
8m 41s
-
10m 39s
-
10m 36s
-
4m 42s
-
12m 4s
-
8m 31s
-
10m 14s
-
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.