Replaced by set of courses 86115-86123

Course Code NGE86007

Contents

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

Screenshot

Description

This second course in the series teaches how to use the JDBC API to create database programs. It provides more detailed information about types of JDBC drivers and how to use them with Java programs. It also covers basic features of using data definition language and data manipulation language commands to create and query tables and databases.

Audience

The target audiences for this course are System Administrators, Database Administrators, Application Developers, System Analysts, Software Engineers, and Programmer/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 types of JDBC drivers and how to use them with the Java programs.
• Identify the installation of an RDBMS.
• Create database programs using DDL and DML commands in JDBC and accessing data using JDBC.

Topics Include

Unit 1: JDBC Drivers

• Match the functions of the JDBC DriverManager class with the situations in which they are used.
• Match the various types of drivers with the situations in which they are used.
• Match the characteristics of the JDBC-ODBC Bridge Driver with the situations in which they are useful.
• Identify the code used to load a JDBC driver.
• Establish a connection with a database by using a registered JDBC driver.
• Shut down an established connection.

Unit 2: JDBC and Database Commands

• Identify the DDL commands to be used in the specified situations.
• Identify the code to create a table by executing a DDL command in JDBC for a specified situation.
• Identify the code to alter a table by executing a DDL command in JDBC for a specified situation.
• Identify the code to drop a table by executing a DDL command in JDBC for a specified situation.
• Identify the DML commands to be used in the specified situations.
• Identify the code to insert a row into a table by executing a DML command in JDBC.
• Identify the code to update a row in a table by executing a DML command in JDBC.
• Identify the code to delete a row in a table by executing a DML command in JDBC.
• Identify the code to query a database by using the executeQuery() method in JDBC for a specified situation.
• Identify the code to traverse a ResultSet object by using the next() method.
• Match the getXXX method code fragments with their functions.

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