JDBC Application Development Part 1: Introduction and Architecture CBT Training CD

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

Learn To
# 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 two-tier and multitier 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.


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: RDBMS: Concepts 2 - 3 hours
# 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 2 - 3 hours
# 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 multitier application with the situation in which they are implemented.


Unit 3: DBC: Programming 2 hours
# 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.