Java Database Connectivity

This course takes the student through a variety of labs exploring the interaction between Java Object Domain Models and Relational Database Tables, this is becoming the standard approach for database access in Java Applications. The course will illustrate how using meta data annotations, you can map domain objects to database tables, and class properties to columns in those tables for CRUD operations. The student will use numerous Query strategies to retrieve data from a database and consume the data in their applications with minimal effort. The course will talk about the how these meta data annotations can also map compositional and inheritance relationships between classes and a database schemas.

This course will introduce the student to the basic concepts of SQL for interaction with Relational Databases. It will illustrate basic SQL statements to create and query tables, leverage table relationships through joins and subqueries, insert and update table rows. It is, however, only intended to cover the basics needed in order for the student to progress onto the Java Database Connectivity (JDBC) and Jakarta Persistence (JPA) courses in the Data Access Specialization.

The intent of Java Database Connectivity (JDBC) Introduction is to get some hands-on experience with foundational JDBC concepts. On our journey we’ll learn about why and how the API makes working with databases easy for Java Developers. After this course you should not only be able to demonstrate the mechanics of JDBC but furthermore, you should be able to explain the design and intent.