Java Database Connectivity

Overview

Syllabus

Courses

• 0 reviews

  12 hours 53 minutes

  View details

  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.
• 0 reviews

  9 hours 2 minutes

  View details

  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.
• 0 reviews

  9 hours 14 minutes

  View details

  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.
• 0 reviews

  8 hours 47 minutes

  View details

  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.

Taught by

Derek Parsons, Ed Lance and Marnie Knue