Overview

Class Central Tips

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.

Syllabus

Course 1: Java Database Connectivity (JDBC) Introduction
- Offered by LearnQuest. The intent of Java Database Connectivity (JDBC) Introduction is to get some hands-on experience with foundational ... Enroll for free.

Course 2: Prepared Statements and Stored Procedures
- Offered by LearnQuest. This is the second course in Java Database Connectivity (JDBC) and builds upon the core principals and techniques in ... Enroll for free.

Course 3: Java Data Access - SQL Primer
- Offered by LearnQuest. This course will introduce the student to the basic concepts of SQL for interaction with Relational Databases. It ... Enroll for free.

Course 4: Jakarta Persistence (JPA)
- Offered by LearnQuest. This course takes the student through a variety of labs exploring the interaction between Java Object Domain Models ... Enroll for free.

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.