JDBC Training Course

Duration: 2 days
Course code: SS-JAV-016

Audience
  • Application developers
  • Programmers
  • System designers
Prerequisites

Knowledge of database principles is preferred but not required. Experience with the Java programming language is required

Description

The JDBC training course teaches developers and designers the art and science of database application development using the application programming interface (API) provided by Java, JDBC. In this course, attendees will learn about installing and managing database drivers in Java, using the DDL and DML functionality of JDBC, formulating simple and complex queries, using compiled queries and stored procedures, handling and formatting the results of queries and transaction management primitives. Extensive hands-on lab exercises reinforce various concepts and techniques as they are introduced.

While this is not a full course on database systems, fundamental database concepts are covered briefly with a special emphasis on relational databases. An overview of the Structured Query Language (SQL) will be provided.

The JDBC training course consists of 50% instruction and 50% lab exercises.

Objectives

The JDBC training course teaches a developer to use JDBC to design and implement Java database solutions. On completion of this course, students will be able to:

  • Master the JDBC API
  • Use various database drivers, including the JDBC-ODBC bridge
  • Use the DDL features to define relational tables, and update data
  • Formulate and execute complex queries in SQL using the API
  • Use the MetaData facilities to parse and format the results

Outline for JDBC Training Course

Fundamentals of Databases

  • Concepts
  • Various models of data storage
  • Data Definition Language (DDL)
  • Data Manipulation Language (DML)

Relational Databases

  • The relational model of data storage
  • Relational algebra
  • Normalization
  • Structured Query Language (SQL)

Database Programming in Java using JDBC

  • JDBC concepts
  • Database drivers
  • Connection objects
  • Defining and creating databases and tables
  • Updating database records
  • Query formulation using Statements objects
  • Using compiled queries and stored procedures
  • Using the ResultSet and MetaData objects with query results
  • Datasources
  • Transaction processing: Commit, Rollback, etc.
  • Connection Pooling

Comments are closed.