Technology Driven IT Training Longstanding IT Technologists Computer Education Techniques
Distance-learning - Db2: Programming in Java with JDBC

Home

distance-learning center

Distance-learning Distance-learning_Building

Professional Distance-learning

IT Training Services

MFRDB61

 Db2: Programming in Java with JDBC
DURATION: 4 days

FEE: $2,380

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.

AUDIENCE:

  • Programmer
  • Database Administrator
  • System Analyst
  • System Designer
  • IT Professional
  
   

DATES:

 CONTENT AND OBJECTIVES:
    1. Getting Started
      • 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.
    2. 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.
    3. JDBC API
      • 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.
    4. JDBC Programming
      • 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.
    5. 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.
    6. 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.
    7. Db2 Application Techniques
      • Use generated columns, identity, and temporary tables.
      • Given a variety of scenarios, provide design guidelines and recommendations for improvements.
    Virtual Classroom   Blended Learning    

↓
Synchronous
Instruction		 Asynchronous
Instruction

Effective February 27, 2012, the course dates listed on the CETi 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. CETi makes no representation regarding ownership in any of the software products that we train on.

CETi 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 CETi course and that the employer has a licensed version of the software.

Certain courses only should be taught by the source software company training company and open source purveyor.