JDBC Application Development Part 3: Advanced Features, OOAD and SQLJ CBT Training CD

Rating:
Summary: JDBC Application Development Part 3: Advanced Features, OOAD
Review: Course Overview
This third course in the series teaches learners skills needed to help them create more advanced databases. It teaches advanced features for creating JDBC programs, including prepared statements, stored procedures, transactions, concurrency control, and metadata. It also teaches how to map an object-oriented design to a relational database and how to use SQLJ standards with Java.

Learn To
# Identify the advanced features for creating JDBC programs.
# Identify Prepared Statement objects, stored procedures, transactions, concurrency control, and metadata.
# Identify the method used to map an object-oriented design to a relational database.
# Identify SQLJ.
# Identify the method used to cerate database queries, manipulate data, and call stored procedures.


Audience
The targeted audience for this course are system administrators, database administrators, programmers/analysts, software engineers, application developers, and system 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: Advanced JDBC Features 2 - 3 hours
# Identify the code for creating a PreparedStatement object for a specified situation.
# Complete the code to supply values to the input parameters of the SQL statement in a PreparedStatement object.
# Select the code for accepting the value returned after executing the SQL statement in a PreparedStatement object.
# Identify the code for disabling the auto-commit mode before beginning a transaction.
# Complete the code for processing a transaction.
# Identify the situation in which the specified type of concurrency control is used.
# Select the code for creating a stored procedure by using SQL statements.
# Identify the code to call a stored procedure by using JDBC.
# Identify the code to retrieve the values contained in output parameters of a stored procedure.
# Match the methods of exception-handling classes with the information returned by them.
# Select the code for catching exceptions.
# Identify the functions of the ResultSetMetaData interface.
# Select the code for displaying the metadata of a result set.


Unit 2: OOAD 2 - 3 hours
# Identify the functions of the persistence layer.
# Identify the purpose of an object ID.
# Select the constructor for creating an object ID.
# Identify the class diagram that represents a type of mapping.
# Match the class diagram with the object relationship it represents.


Unit 3: SQLJ 2 hours
# Sequence the steps for developing an application that contains SQLJ code.
# Sequence the translation steps performed by the SQLJ translator.
# Identify the code to query a database by using SQLJ.
# Select the code to manipulate data by using SQLJ.
# Identify the code to call a stored procedure by using SQLJ.