PRIVATE GROUP FEE:
$ Based upon a class size of six students.
Scheduling can be adjusted to employee work hours and incorporate client assignments.
SMALL CLASS SIZE:
There is a surcharge associated with training two or fewer students.
CONTENT AND OBJECTIVES:
How JDBC connections support the creation and execution of statements.
Use the update statements: SQL CREATE, INSERT, UPDATE, and DELETE.
Demonstrate query statements.
How stored procedures can be invoked through a JDBC connection.
How JDBC represents statements these classes: Statement, PreparedStatement, and CallableStatement.
Use the method Class.forName(String) for loading the JDBC driver class.
Coding a Db2 Application in Java
Code and test a JDBC application.
Code and test an application which retrieves a variable number of rows from a table and displays the results; the input parameters for the query will be supplied by the user.
Use static SQL to code and test a JDBC application.
Use the identical specifications from the previous exercise, recode the program using SQLJ.
The compile procedure for SQLJ will be provided by the instructor.
Code and test a JDBC application for extracting metadata information from the database.
Given a table name, display all the columns and their attributes.
List all the associated indexes.
Code and test a complete JDBC application for maintaining the data in a database.
Use JDBC for retrieving data for reports and maintaining data integrity.
JDBC Programming: Advanced
The reason for escape codes in Java.
Code escape codes in a dynamic SQL statement.
How concurrency is the ability of a database management system to allow multiple users to access data at the same time while maintaining the integrity and consistency of the data.
Acquire experience with lost updates, unrepeatable reads, and access to uncommitted data.
Prepared and Stored Procedures
A dynamic SQL statement must be first prepared for execution.
When the same SQL statement is to be executed multiple times, the recommendation is to perform the preparation prior to use.
Prepare stored procedures and their invokers for execution.
Db2 Application Techniques
Use generated columns, identity, and temporary tables.
Given a variety of scenarios, provide design guidelines and recommendations for improvements.
Effective February 27, 2012, the course dates listed on the SYS-ED schedules only will be available based upon approved and authorized user ID.
Copyright Acknowledgement: The software product(s) listed in this outline are owned and copyrighted by their respective companies. SYS-ED makes no representation regarding ownership in any of the software products that we train on.
SYS-ED courses are not intended for or open to the general public. They are intended for employees of Fortune 1000 companies, government municipalities, consulting companies, software, companies, healthcare providers. and mid-sized businesses. Individuals attending such courses will be required to execute a statement acknowledging that the employer will be paying for the SYS-ED course and that the employer has a licensed version of the software.