Welcome to Outsource Laboratories
Home
News
Courseware
Training
Publishing
Customer Service
About Us
Contact OLabs
Site Map

Quick Links:

Book Catalog
Java Coursemap
Courseware List
Course Curriculum
Request Info/Copy
Provide Feedback
Place an order
 

 
Welcome Pages for:  Educators  |  Students   |  Corporate Training   |  Instructors   |  Authors   |  Resellers  

* OL311:  Database Programming using JDBC Technology

Description:
 
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.  

Objectives:

    At the end of the course, participants will be able to:
       
    1. Apply the nine-step process for accessing a database through the use of JDBC technology.
    2. Develop code using the JDBC 2.0 API for gaining access to a database within a Java application.
 
Audience:
 
People involved with Web publishing and Web technology based GUI development, or people writing multi-tiered networking applications.
Prerequisites:
 
Students should have taken OL309 or OL304 or have equivalent Java programming experience.
 
Duration: 2 days
 
Outline of Contents:
 
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.

 

[an error occurred while processing this directive]