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
-
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 on some of our courses, which can be shared on any social network or business platform.
Digital badges are yours to keep, forever.
