JDBC - Database Programming Using Java JDBC Technology
| Categories |
Internet Training, Database Training, Programming Training, Java Training |
| Duration |
2 days (14 hours) |
| Pre-requisites |
Programmers with sound experience in structured programming. Understanding of object-oriented concepts. Programming experience in Java encompassing data structures, exception handling, multi-threading, and IO, or equivalent of JV1 - Java Programming are prerequisites for this course. |
|
|
|
| Courseware |
JDBC-OL-01 (100 pages) |
| Price |
$790 |
| Notes |
Who should take this course?...anyone involved with Web publishing and Web technology based GUI development, or people writing multi-tiered networking applications.
After taking this course, participants will be able to apply the nine-step process for accessing a database through the use of JDBC technology and develop code using the JDBC 2.0 API for gaining access to a database within a Java application.
|
This course explores Java's database connectivity package, JDBC 2.0. Topics include JDBC elements, the steps used to access a database with JDBC, data retrieval issues, and some of the advanced features that will gain more support with future releases of the JDBC API. Participants will use the JDBC interface to provide a call-level API for SQL-based database applications. This hands-on course is composed of comprehensive lectures, practical project illustrations, and independent programming sessions. The session's exercises include a realistic database application using modular Java architecture where the participant produces specific reports based on data in the database.
Unit 1: Introducing JDBC Technology
Explore JDBC technology and its advantages.
Identify important components for JDBC applications.
Understand JDBC driver categories and when and where they are used.
Unit 2: JDBC Basics
Learn the main steps involved in using JDBC technology.
Write an application accessing a database using JDBC.
Unit 3: Advanced JDBC Technology
Implement some of the advanced features of JDBC.
Employ various transaction control mechanisms using JDBC.
Learn mechanisms for retrieving database and ResultSet info at runtime.
Unit 4: A Database Application
Use another database application architecture.
Write a specific report on data in the database.