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

Home

distance-learning center

Distance-learning Distance-learning_Building

Professional Distance-learning

IT Training Services

MFRDB86

 Db2 SQL for Java Developers - Advanced
DURATION: 3 days

FEE: $1,785

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. JDBC: Java Database Connectivity
      • Process specific SQL exceptions when opening a connection or executing a query.
      • Determine the number of rows in a resultset.
    2. CASE Clause
      • Demonstrate different CASE uses and clauses.
    3. Advanced Data Modification
      • Code SQL to specify the DEFAULT values for a column when inserting a row.
    4. Functions
      • Create and use a UDT in defining a column in a table.
      • Code SQL using different casting techniques.
    5. Row and CTE expressions
      • Code a nested table to simplify an operation.
      • Apply recursive SQL.
    6. EXPLAIN
      • Tune SQL statements by using the EXPLAIN command and interpreting the PLAN_TABLE.
    7. Tuning SQL
      • Identify the different types of isolation methods in Db2.
      • Code a SQL statement specifying cursor stability.
    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.