IT Skills     Software Design and Development     Java     Connecting to and Querying Databases With JDBC

---

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.

---

---

Objectives

Java Database Connectivity (JDBC): An Introduction to JDBC 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