DURATION
4 days
Course Outlines & Details
Database Application Programming With Java Technology is a focused-technology course that provides students with a hands-on approach to developing database applications using Java technology and the JDBC 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.
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
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
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 (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
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
This is a version-specific reference outline. Confirm the current syllabus and delivery arrangements with EIEIO.