Learning Java Database Connectivity (JDBC). After the course, you will be able to explain the mechanics of JDBC and in depth the design and intent behind it.
Suggested by: Coursera (What is Coursera?)
No prior knowledge required
No unnecessary risks
The goal of Introduction to Java Database Connectivity (JDBC) is to gain hands-on experience with basic JDBC concepts. During the course, we will learn why and how the API makes it easier for Java developers to work with databases. After completing the course, you will not only be able to demonstrate the mechanics of JDBC, but also explain its design and purpose.
This is the second course in Java Database Connectivity (JDBC) and builds on the fundamental principles and techniques learned in Course 1. The course uses prepared statements, highlighting their advantages over regular JDBC statements. It also goes into the details of using stored procedures on the database server to tie together complex SQL and PLSQL logic. The course also introduces the concept of querying database metadata, such as table structures, and how to deal with different SQL syntax for different databases using the JDBC escape syntax.
This course will introduce the student to the basic concepts of SQL for interactions with relational databases. It will demonstrate basic SQL statements for creating tables and queries, using relationships between tables through joins and subqueries, inserting new rows, and updating existing rows. However, it is intended only for the foundational framework required for the student to progress to the Java Database Connectivity (JDBC) and Jakarta Persistence (JPA) courses in the Data Access specialization.
This course takes the student through a series of labs that simulate the interaction between Java object domain models and relational database tables, an approach that is becoming the standard for accessing databases in Java applications. The course will demonstrate how, using metadata annotations, domain objects can be mapped to database tables and class properties to columns in those tables for CRUD purposes. The student will use a variety of query strategies to pull data from a database and consume the data in their applications with minimal effort. The course will discuss how these metadata annotations can also map hierarchy and composition relationships between classes and database schemas.
