Java Database Connectivity Specialization

This is the second course in Java Database Connectivity (JDBC) and builds upon the core principals and techniques in the JDBC 1 course. It utilizes PreparedStatements, highlighting their advantages over JDBC Statements. It will also introduce utilizing Stored Procedures on the database server itself to encapsulate complex SQL and PLSQL logic. The Course also introduces the idea of querying the database meta data such as table structures and how to cope with different SQL syntax for different Jdbc complaint databases via the JDBC escape syntax.

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.

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.