
	Sun Educational Services

Course Catalog

Database Application Programming with Java[tm] Technology

( SL-330 )

Course Description

Database Application Programming With Java[tm] Technology is a focused-technology course that provides students with a hands-on approach to developing database applications using Java technology and the JDBC[tm] application programming interface (API). Students will learn to use the features of the JDBC 1.0 API, and will learn about the new features added in JDBC 2.0.

Note - Lab exercises currently include only JDBC 1.0 features.

Students will also learn how to map an object-oriented design to a relational database, and how to design a multi-tier database application.

Course details
id: SL-330
duration: 4 days
list price: $ 1795.00

Who Can Benefit

Programmers and database administrators interested in developing enterprise database applications, and those who have taken SL-285: Java Programming Workshop and want to learn more about the JDBC API.

Prerequisites

To succeed fully in this course, students should be able to:

Design applications using object-oriented analysis and design

Develop applications using the Java programming language

Use SQL to retrieve and manipulate data in a relational database

Skills Gained

Upon completion of this course, you should be able to:

Design a multi-tier database application architecture

Create a multi-tier database application using the Java programming language and the JDBC 1.0 API

Map an object-oriented design to a relational database

Explain the features added to the JDBC 2.0 API

Related Courses

Before: FJ-310: Developing J2EE Compliant Applications

After: SL-301: Distributed Computing With Java Technology

Course Content

Module 1: JDBC Overview Back To Top

Describe the purpose of the JDBC API

Explain how to use the JDBC API to connect an application using Java technology to a database

Define the different components of the JDBC architecture

Select the correct kind of JDBC driver for a given application architecture

Describe the uniform resource locator (URL) syntax used to identify a database

Module 2: Using JDBC

Select an appropriate method to register a JDBC driver

Establish a database connection with the registered JDBC driver

Query a database using the JDBC connection

Select the appropriate type of statement given the data query requirements

Manipulate data in the database using a JDBC connection

Process the results of a query

Shut down the appropriate objects after a JDBC process is complete

Module 3: OOAD and Database Design

Describe the purpose of an object ID

Describe two ways to create an object ID

Given a class diagram, map objects to a relational database

Given a class diagram, map object relationships in the database

Define the use of a persistence layer in a database application

Module 4: JDBC Advanced Topics

Write code to catch exceptions in JDBC processes

View metadata for a table or result set

Create transactions

Use concurrency control to determine how data is read and changed

Module 5: JDBC 2.0 Core Features

List the new features in the JDBC 2.0 Core API

Explain how to scroll forward and backward within a result set

Understand how to use a scroll cursor to process the results of a query

Use a scroll cursor to manipulate data in the database

Describe how to perform batch processing with statements

List the new data types added to JDBC 2.0

Module 6: JDBC 2.0 Standard Extensions

List the features in the JDBC 2.0 Standard Extension API

Understand how to use Java Naming and Directory Interface[tm] (JNDI) functionality to reduce dependence of a JDBC program on a particular driver

Learn how connection pooling is used to connect an application to a database

Understand how distributed transactions work

Explain how to use row sets to encapsulate rows for use with the JavaBeans[tm] component model

Module 7: Row Set Implementation

Explain how to use the CachedRowSet implementation

Modify a RowSetReader or RowSetWriter

Understand the benefit provided by using the CachedRowSet

Module 8: JDBC and Application Architecture

Define the components in a multi-tier application

Explain which components belong to each tier in a multi-tier application

Explain where JDBC components should be installed in a multi-tier application

Describe when to use a two-tier application architecture in a database application

Describe when to use a three-tier application architecture

Describe when to use an n-tier application architecture

Appendix A: Database Basics

Define database and database management system (DBMS)

Identify three major DBMS categories

Describe major characteristics of relational databases

Describe guidelines for partitioning work into transactions

Explain the importance of SQL

Query a database using the SQL statement SELECT

Modify database contents using the SQL statements INSERT, UPDATE, and DELETE

Appendix B: Using SQLJ

Explain how SQLJ works

Explain the purpose of the SQLJ Translator

Code database queries with SQLJ

Code database manipulation with SQLJ