Custom Search

JDBC Application Development Part 2: Creating Database Programs

JDBC

Serebra Learning Corporation
Training Provided by Serebra Learning Corporation 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.
This is primarily online training
on-line e-learning cbt (computer based)This is an online eLearning or CBT training program
Contact Serebra Learning Corporation for more information
Duration:8 hours
Training Presented in:English
JDBC Application Development Part 2: Creating Database Programs Course Outline - NGE86007 - Replaced by set of courses 86115-86123

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


click to enlarge

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).
The network 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 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

Serebra Learning Corporation, 1660 - 999 West Hastings, Vancouver, BC    V6C 2W2 Canada
Tel: (604) 676-5480 or 1-800-567-7766 - Fax: (604) 676-5490
E-Mail: sales@serebra.com - Web Site: www.serebra.com
About The Training Provider: Serebra Learning Corporation
Serebra Learning Corporation - Serebra Learning Corporation provides technology-based training solutions through a combination of Cortex, its proprietary learning management system (LMS), and a curriculum catalog with over 1, 825 current courseware titles. Founded in 1987 (as FirstClass Systems, with a name change to Serebra in 2001), Serebra has over sixteen years" experience delivering e-learning solutions to both...
Want to market your application training?
tcw11-gfc-v396M-10/25/09-10:33:05-()[B]-[B]-[A] -10:23:04