JDBC (EN/NL/FR)

ABIS Training & Consulting - Couse Description

JDBC

During this training, we will connect Java with a RDBMS using the JDBC library. This one-day ABIS course will let you understand how to create a standard database connection from a Java application, and to translate SQL calls to Java objects.

Java applications often need to access existing or new relational databases. Although most application developers make their programs in an IDE (Integrated Development Environment), having a basic knowledge on how databases are accessed from Java code is a must. This course provides the foundations on how data can be stored into and retrieved from relational databases using JDBC (Java Data Base Connectivity).

In this course, we will

• explain how to connect to a relational database using JDBC
• execute queries, DML, DDL and stored procedures via our Java Application
• handle transactions
• use design patterns to structure our application better

Intended for

Application developers, technical analysts and database administrators who are involved in the development of Java applications that access relational databases.

Backgroud

The participants of this training should have experience with Java programming (see course Java programming) and be familiar with at least basic SQL (see course SQL and relational databases fundamentals).

You can test yourself to see if you have enough background by filling out the online selftest "Java" and the online selftest "SQL fundamentals".

Main topics

• Introduction to JDBC
  • history
  • JDBC drivers
• Connecting to the database
  • creating connections
  • connection options
  • closing connections
• Database handling
  • querying
  • DML and DDL
  • calling stored procedures
• Exception handling and transactions
  • working with SQLExceptions
  • transactions and locking
• Structuring the application with patterns
  • Singleton
  • Factory
  • DAO / Repository
• Java and Persistence Frameworks

Training method

Classroom training: lecture and hands-on exercises. The participants will work with Java applications accessing Oracle, SQL Server, PostgreSQL, MySQL or H2 databases.

Delivered as a live, interactive training: available in-person or online, or in a hybrid format. Training can be implemented in English, Dutch, or French.

Certificate

At the end of the session, the participant receives a 'Certificate of Completion'.

Duration
1 day.