Back to Search Results

Training Course Summary:

The Database Application Programming With Java Technology course provides students with a hands-on approach to developing database applications using Java technology and the JDBC application programming interface (API). The features of the JDBC 1.0 API are described, and the new features added in JDBC 2.0 are discussed.

The course also explains how to map an object-oriented design to a relational database and how to design a multi-tier database application.

Pre-Requisites:

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

Who Should Attend:

Students who can benefit from this course are programmers and database administrators interested in developing enterprise database applications and individuals who have already taken SL-285: Java Programming Language Workshop and want to learn more about the JDBC API.

Training Course Overview/Content:

Module 1 -­ JDBC Overview


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
Describe how to use a scroll cursor to process the results of a query
Explain how to 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 (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 component model

Module 7 -­ Row Set Implementation


Explain how to use the CachedRowSet implementation
Modify a RowSetReader or RowSetWriter
Describe 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