JDBC - Java Database Connectivity Training

Answers to Popular Questions:

 
Yes, this class can be tailored to meet your specific training needs.
Yes, we provide Java Programming consulting services.
Yes, group discounts are provided.

Course Description

 
DBC is a Java technology for accessing SQL databases. It is a core part of J2EE, and it works with every major database product. This hands-on course covers all the details that you will need to use JDBC to access the information in your databases using Java. It also talks about real world issues in using JDBC.
Course Length: 1 Days
Course Tuition: $690.00 (US)

Prerequisites

Programmers with experience in working with Java and Object - Oriented (OO) programming.

Course Outline

 
Hands-on: 50% hands-on, 50% lecture
 
 
Skills Gained:
 
Understand the JDBC architecture
Connect to different databases with JDBC
Understand the JDBC API
Execute SQL statements using JDBC, and retrieve results
Call stored procedures from JDBC
Understand and control transactions with JDBC
Retrieve information about database structure using DatabaseMetaData
Use Advanced JDBC features
 
Course Details:
Introduction
Relational Database and JDBC Overview
Overview, Table Relationships, Web Based Data Access, JDBC Characteristics
JDBC Architecture, JDBC API Overview
DriverManager, JDBC Drivers
Naming databases with JDBC URLs
Connecting to a database
Connection interface, Establishing a connection
DataBaseMetaData
Handling Database Exceptions
 
Data Access
DAO – Data Access Objects, O-R Mapping, Value Objects
Processing Database Data
Executing statements, precompiled statements and stored procedures
Processing ResultSets,
Dealing with Null data
Updating, inserting, retrieving data
Controlling Transactions
JDBC Driver Types
DataSource
J2EE and DataSource
Using JNDI
Connection Pooling
Overview, Usage, Advantages, Statement Pooling
 
Advanced Topics
Other Database Access Technologies
SQLJ, O-R Mapping Tools, JDO (Java Data Objects), EJB Entity Beans
Advanced JDBC Features
Batch Updates, Srollable Result Sets, Rowsets, User Defined Types, BLOBS, CLOB
 

Course Directory [training on all levels]

Upcoming Classes
Gain insight and ideas from students with different perspectives and experiences.

Interesting Reads Take a class with us and receive a book of your choosing for 50% off MSRP.