Advanced SQL via DB2 EXPLAIN

Wise

Course

In Gatwick

£ 1,195 + VAT

The best Other Database courses

See all

See all

Description

  • Type

    Course

  • Level

    Advanced

  • Location

    Gatwick

  • Duration

    3 Days

Upon completion of this presentation, the participant should be able to exploit the DB2 Optimizer in deciding which of several SQL alternatives will provide reduced elapsed times, CPU and I/O. Suitable for: Application Developers, Application Programmers, Production DBAs, Database Administrators and Capacity Planners.

Facilities

Location

Start date

Gatwick (London)
Regus Centre, First Point, Buckingham Gate, London Gatwick Airport, RH6 0NT

Start date

On request

About this course

Completion of our course DB2 SQL Essentials or at least one year of SQL experience in a Windows, UNIX or OS/2 environment.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Course programme

This course focuses on tuning advanced SQL via DB2 Explain facilities in terms of the following DB2 UDB features:

  • Isolation levels
  • Locking and concurrency
  • Join optimisation
  • Sequence and identity columns
  • Common Table Expressions
  • Recursive queries
  • Grouping sets
  • Materialized Query tables (MQTs)
  • Index design and usage
  • SARGable vs. non-SARGable predicates
  • Elapsed, CPU and I/O times

See related categories

Advanced SQL via DB2 EXPLAIN

£ 1,195 + VAT

The best Other Database courses

See all

See all