Replaced by set of courses 86115-86123

Course Code NGE86008

Contents

1. Contents
2. Description
3. Audience
4. Prerequisites
5. Objectives
6. Topics Include
7. Duration
8. Minimum Requirements
9. Media

Screenshot

Description

This third course in the series teaches learners skills needed to help them create more advanced databases. It teaches advanced features for creating JDBC programs, including prepared statements, stored procedures, transactions, concurrency control, and metadata. It also teaches how to map an object-oriented design to a relational database and how to use SQLJ standards with Java.

Audience

The targeted audience for this course are system administrators, database administrators, programmers/analysts, software engineers, application developers, and system analysts. Learners should be able to design applications using object-oriented analysis and design, develop applications using the Java programming language, and use SQL to retrieve and manipulate data in a relational database.

Prerequisites

(Currently no course prerequisite information)

Objective

• Identify the advanced features for creating JDBC programs.
• Identify PreparedStatement objects, stored procedures, transactions, concurrency control, and metadata.
• Identify the method used to map an objectoriented design to a relational database.
• Identify SQLJ.
• Identify the method used to cerate database queries, manipulate data, and call stored procedures.

Topics Include

Unit 1: Advanced JDBC Features

• Identify the code for creating a PreparedStatement object for a specified situation.
• Complete the code to supply values to the input parameters of the SQL statement in a PreparedStatement object.
• Select the code for accepting the value returned after executing the SQL statement in a PreparedStatement object.
• Identify the code for disabling the auto-commit mode before beginning a transaction.
• Complete the code for processing a transaction.
• Identify the situation in which the specified type of concurrency control is used.
• Select the code for creating a stored procedure by using SQL statements.
• Identify the code to call a stored procedure by using JDBC.
• Identify the code to retrieve the values contained in output parameters of a stored procedure.
• Match the methods of exception-handling classes with the information returned by them.
• Select the code for catching exceptions.
• Identify the functions of the ResultSetMetaData interface.
• Select the code for displaying the metadata of a result set.

Unit 2: OOAD

• Identify the functions of the persistence layer.
• Identify the purpose of an object ID.
• Select the constructor for creating an object ID.
• Identify the class diagram that represents a type of mapping.
• Match the class diagram with the object relationship it represents.

Unit 3: SQLJ

• Sequence the steps for developing an application that contains SQLJ code.
• Sequence the translation steps performed by the SQLJ translator.
• Identify the code to query a database by using SQLJ.
• Select the code to manipulate data by using SQLJ.
• Identify the code to call a stored procedure by using SQLJ.

Duration

8

Minimum Requirements

The CDROM version of this course requires:

• At least a 486DX 33Mhz CPU.
• Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
• At least 8MB RAM.
• At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).
• At least a double speed CDROM drive.
• An MPC compliant sound card with attached speakers or headphones is recommended (Currently, only the CDROM version supports audio).

• At least a 486DX 33Mhz CPU.
• Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
• At least 8MB RAM and 22MB available hard disk space or file server space.
• At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).

Media