Technology Driven IT Training Longstanding IT Technologists Computer Education Techniques
Distance-learning - Db2 SQL for Java Developers

Home

distance-learning center

Distance-learning Distance-learning_Building

Professional Distance-learning

IT Training Services

MFRDB84

 Db2 SQL for Java Developers
DURATION: 2 days

FEE: $990

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 Programmer
  • IT Professional
  
   

DATES:

 CONTENT AND OBJECTIVES:
    1. SQL: Syntax and Overview
      • Create a constraint; attempt to violate it and produce an error.
    2. SQL Queries
      • Code queries using Db2 derived columns and mathematical expressions.
      • Code and execute basic queries for retrieving data.
    3. Using JDBC
      • Code a program to connect to a Db2 database.
      • Run a basic query. Process any SQL exceptions.
    4. Scalar Functions and Arithmetic
      • Code SQL performing arithmetic on data using functions and constants.
    5. Grouping Values
      • Produce a summary display with statistics.
    6. Join Operations
      • Perform basic joins on multiple tables.
      • Join data from two tables using an inner join and a full outer join.
    7. Unions and Subquery
      • Code a UNION and UNION ALL clause and demonstrate the differences.
    8. Updating Db2 Tables
      • Code multiple DML statements that will modify tables.
      • Update single rows, multiple rows, and all rows.
      • Insert a single row and perform a multiple row insert.
      • Delete a single row.
    9. COBOL and Java Datatypes (optional)
      • Code a wrapper around a Java/Db2 attribute.
    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.