JDBC Application Development Curriculum CBT Training CDs

Rating:
Summary: JDBC Application Development Curriculum CBT
Review: Course Overview
The JDBC Application Development Curriculum introduces learners to the JDBC API and explains how it is used to access any database from Java. 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. It teaches learners skills needed to help them create more advanced databases, 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. Lastly, how to use the new features in the JDBC 2.0 core API is covered.

# This curriculum consists of four courses: Course 86006 JDBC Application Development Part 1: Introduction and Architecture
# Course 86007 JDBC Application Development Part 2: Creating Database Programs
# Course 86008 JDBC Application Development Part 3: Advanced Features, OOAD and SQLJ
# Course 86009 JDBC Application Development Part 4: The 2.0 Core and Optional APIs

Learn To
See individual course descriptions for specific course objectives and scope.


Audience
The target audiences for this curriculum 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 Per Course

Language Options
US English

Total Learning Time
24 to 32 hours

Java 2 JDBC Application Development Part 1: Introduction and Architecture Training CD
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.


Java 2 JDBC Application Development Part 2: Creating Database Programs Training CD
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.


Java 2 JDBC Application Development Part 3: Advanced Features, OOAD and SQLJ Training CD
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.


Java 2 JDBC Application Development Part 4: The 2.0 Core and Optional APIs Training CD
Course Overview
This final course in the series teaches how to use the new features in the JDBC 2.0 core API. It also covers using the optional API, which includes the ability to connect to a database with datasource objects that work with JNDI, and using rowsets.

Learn To
# Identify new features in JDBC 2.0 Core API and JDBC 2.0 Optional Package API.
# Identify the rowset implementations, CachedRowSets, and RowSetReader and RowSetWriter.
# Identify how to use rowsets with EJB.


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: JDBC 2.0 API 3 - 4 hours
# Identify the new functionality supported by JDBC 2.0 Core API.
# Match the SQL3 data types supported by JDBC 2.0 API with their uses.
# Identify the code to create a scrollable ResultSet object.
# Complete the code to move the cursor to a specific row in a scrollable ResultSet object.
# Select the code to retrieve values stored in a scrollable ResultSet object by using a cursor.
# Complete the code to create an updatable ResultSet object.
# Identify the code that is used to update a database by using an updatable ResultSet object.
# Sequence the lines of code that are used to insert a row in a table programmatically by using an updatable ResultSet object.
# Write the code to delete a row from a table programmatically by using an updatable ResultSet object.
# Write the code to refresh data in an updatable ResultSet object.
# Complete the code to view the changes made to an updatable ResultSet object.
# Complete the code to create a Statement object for a batch update in a specified situation.
# Identify the code that is used to handle a batch update exception.
# Select the code to define a SQL structured data type.
# Identify the code to create a DISTINCT data type.
# Complete the code to retrieve data from a field that implements a SQL3 data type.
# Select the code to create a class that implements the SQLData interface.
# Identify the code to make an entry for a UDT in the type map associated with a Connection object.
# Identify the code to retrieve values from a column that implements a type map.
# Identify the reason for selecting JDBC 2.0 Optional Package API in a specified situation.
# Label the connection pooling process that uses DataSource objects with method call and return components.
# Label the distributed transaction process that uses DataSource objects with method call and return components.
# Complete the code that implements JNDI API to make the code portable.


Unit 2: Rowset 3 - 4 hours
# Identify the type of rowset that should be used in a specified situation.
# Write the code to create a CachedRowSet object at run time by using the default constructor provided by the RowSet class.
# Complete the code to set the properties of a rowset.
# Label the statement that must be specified with the statements that retrieve data from a table into a CachedRowSet object.
# Complete the code to propagate changes in a CachedRowSet object to a database.
# Write the code to register a bean as a listener to CachedRowSet.
# Match the components of EJB architecture with their functions.
# Identify the code that declares the methods that a client can call on an enterprise bean.
# Select the code for the home interface that declares the methods to locate, create, and remove a bean.
# Complete the code to define the business logic for an application.
# Complete the code to invoke the methods implemented in the enterprise bean class.