Call : (+91) 968636 4243
Mail : info@EncartaLabs.com

JDBC Programming with Java

( Duration: 2 Days )

This JDBC Programming with Java training course is designed to provide you with the skills needed to develop solid Java applications using Java Data Base Connectivity (JDBC) to interact with relational databases such as Derby, DB2, Oracle, and Microsoft SQL Server.

By attending JDBC Programming with Java workshop, delegates will learn to:

Use JDBC statements to process JDBC Result Sets
Manage JDBC exceptions
Use prepared statements
Call stored procedures
Understand how to configure type 2 and 4 JDBC drivers
Understand how enterprise Java works with JDBC

Basic Java programming skills
Basic understanding of relational databases
Basic understanding of Structured Query Language (SQL) statements
Basic understanding of Data Access Objects (DAOs) is helpful but not required

The JDBC Programming with Java class is ideal for:

Java developers who need to read and update relational data bases using JDBC
Other IT personnel who need to interact with Java JDBC data base developers

COURSE AGENDA

Introduction to Java Data Base Connectivity (JDBC)

What is JDBC?
JDBC versus Open Data Base Connectivity (ODBC)
JDBC Driver Types
How Does JDBC Work?
Using SQL Statements with JDBC

Connecting to a Data Base

The Driver Manager Class
Connecting to Data Bases Using JDBC
Data Base Connection Failures
Read-Only Connections
Closing the Connection

Executing SQL Part 1: Static SQL Statements

What Are Static SQL Statements?
Creating a Statement
Executing a Statement
Closing a Statement

JDBC Data Types

Mapping Data Types Between Java and the Data Base
Special SQL Data Types
Reading and Updating SQL Data

Result Sets Part 1: The Basics

What Are Result Sets?
When the Data Base Returns a Result Set
Positioning Within the Result Set
Reading Data from the Result Set
Returning Data Values from the Current Result Set Row
How to Check for Nulls
Closing a Result Set

Result Sets Part 2: More Features

Result Set Values
Fetching Data from Result Sets
Updating Data within Result Sets

Handling JDBC Exceptions

Catching SQL Errors
The SQL Exception
Handling SQL Warnings
Data Truncation when Reading, Writing, and Updating Data

Executing SQL Part 2: Prepared Statement Processing

What Are Prepared Statements?
Preparing a SQL Statement
Setting Input Parameters
Executing a Prepared Statement
Putting It All Together
What is Meta Data?
Reading Meta Data
Result Set Meta Data
Data Base Meta Data
JDBC Driver Meta Data

Escape Clauses

What are Escape Clauses?
JDBC Escape Clauses
Processing Escape Clauses

Executing SQL Part 3: Calling Stored Procedures

Calling Stored Procedures Using JDBC
Using Callable Statements
Stored Procedure Meta Data

JDBC Data Management

Data Management Issues
Maintaining Data Consistency
Handling Concurrent Threads

Executing SQL Part 4: More SQL Statement Features

What is Dynamic SQL?
Using Dynamic SQL
JDBC SQL Batch Processing

Enterprise JDBC

How JDBC Works with Enterprise Java
Defining Data Sources
Processing Row Sets
Connection Pooling
JDBC Events

Encarta Labs Advantage

One Stop Corporate Training Solution Providers for over 6,000 various courses on a variety of subjects
All courses are delivered by Industry Veterans
Get jumpstarted from newbie to production ready in a matter of few days