Replaced by set of courses 86115-86123

Course Code NGE86006

Contents

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

Screenshot

Description

This first course in the series provides the foundation for the rest of the course series. It introduces learners to the JDBC API and explains how it is used to access any database from Java. It also covers the basics of working with relational database systems, how to use JDBC to design multi-tier database applications, and an overview of the major steps in the JDBC program.

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 features and components of RDBMSs.
• Identify the features of SQL.
• Identify how to create and manipulate database tables, and the concepts of database querying and transaction control.
• Identify the features of the JDBC API.
• Identify the architecture of JDBC and advantages and limitations of twotier and multi tier JDBC applications.
• Identify the basic JDBC programming concepts used to establish a database connection.
• Identify the methods used for updating and querying a database, and processing the result set.

Topics Include

Unit 1: RDBMS: Concepts

• Match the features of an RDBMS with their benefits.
• Match the components of an RDBMS with their functions.
• Identify the components of an RDBMS.
• Match the features of SQL with the situations in which the features can be used.
• Complete the code to define a database table by using DDL commands.
• Identify the code for manipulating tables by using DML commands.
• Identify the code to query a database for extracting data by using the SELECT clause.
• Identify the code for executing an advanced query on a database in a specified situation.
• Identify the code to retrieve data from multiple tables using a join query.
• Identify the situations where transaction processing can be used to solve data integrity problems.

Unit 2: JDBC: Concepts

• Match the advantages of JDBC with the situations in which the advantages are used.
• Match the database management features of JDBC with the situations implementing the features.
• Match the application management features of JDBC with the situations implementing the features.
• Label the flowchart depicting the JDBC communication path with the components used.
• Match the types of JDBC drivers with their features.
• Identify the advantages of implementing a JDBC two-tier application.
• Identify the limitations of implementing a JDBC two-tier application.
• Match the features of a JDBC multi tier application with the situation in which they are implemented.

Unit 3: DBC: Programming

• Identify the JDBC URL syntax to access a database in a specified situation.
• Match the method of loading a driver with the situation in which it is used.
• Sequence the steps in the process for establishing a database connection.
• Complete the code for manipulating a table by using the executeUpdate() method.
• Select the code for querying a database by using the executeQuery() method.
• Identify the code for processing the result set of a query performed on a database table.

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