Java Database Connectivity

The Java Database Connectivity (JDBC) Introduction module provides hands-on experience with foundational JDBC concepts. Participants will learn about the JDBC API and why it makes working with databases easy for Java Developers. By the end of this module, participants will be able to demonstrate the mechanics of JDBC and explain its design and intent.

The Prepared Statements and Stored Procedures module builds upon the core principles and techniques of JDBC. It focuses on utilizing PreparedStatements and highlights their advantages over JDBC Statements. Additionally, it introduces the utilization of Stored Procedures on the database server itself to encapsulate complex SQL and PLSQL logic, and how to query the database meta data such as table structures.

The Java Data Access - SQL Primer module introduces participants to the basic concepts of SQL for interaction with Relational Databases. It covers basic SQL statements, leveraging table relationships through joins and subqueries, and inserting and updating table rows. This module provides the necessary foundation for progressing to the Java Database Connectivity (JDBC) and Jakarta Persistence (JPA) courses in the Data Access Specialization.

The Jakarta Persistence (JPA) module takes participants through a variety of labs exploring the interaction between Java Object Domain Models and Relational Database Tables. It illustrates how to map domain objects to database tables and class properties to columns for CRUD operations using meta data annotations. Participants will also learn various query strategies to retrieve data from a database and consume the data in their applications with minimal effort.