JDBC Application Development Part 2: Creating Database Programs CBT Training CD

Rating:
Summary: JDBC Application Development Part 2
Review: Course Overview
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.

Learn To
# 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.


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.

Deployment Options
e-Learning

Accreditation
NASBA credits: 4 CPE Credits
ITCAP credits: Not Applicable CEU credits: 0.70 CEUs

Language Options
US English

Total Learning Time
6 to 8 hours

Objectives
Unit 1: JDBC Drivers 3 - 4 hours
# 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 3 - 4 hours
# 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.