Training

 

 

Popular Courses

Browse Our Free Resources

  • whitepapers
  • whitepapers
  • webinars
  • blogs

Our Locations

Training Centres

Vancouver, BC
Calgary, AB
Edmonton, AB
Toronto, ON
Ottawa, ON
Montreal, QC
Hunt Valley
Columbia

locations map

Calgary

550 6th Av SW
Suite 475
Calgary, AB
T2P 0S2

Toronto

821A Bloor Street West
Toronto, ON
M6G 1M1

Vancouver

409 Granville St
Suite 902
Vancouver, BC
V6C 1T2

U.S. Office

436 York Road
Suite 1
Jenkintown, PA
19046

Other Locations

Dallas, TX
Miami, FL

Home > Training > DB2 > SQL for DB2 Advanced Training

SQL for DB2 Advanced Training

Course#: WA1334

This course is designed to present some advanced SQL topics, using DB2. SQL statements will be used to create objects for application design and development. Design issues of referential Integrity, table check constraints, user defined data types, functions and triggers will be reviewed. Performance related issues will also be reviewed.

Objectives

After completing this course the student should be able to:

  • create relational objects for application development.
  • Use advanced SQL queries to access and manipulate data on DB2 tables.
  • Review and use different methods of improving performance.
  • Know how to create SQL Functions (UDF) and also code SQL to use them.
  • Use SQL for OLAP
  • Use recursive SQL

Target Audience

DB2 users requiring knowledge of advanced SQL features

Prerequisites

  • Relevant Operating Systems experience.
  • Previous experience with relational database systems and SQL.

Format

Classroom instruction and review with hands-on workshops.

Duration

Two days.

Outline of WA1334 SQL for DB2 Advanced Training

Day 1

  • Creating Objects
  • SQL queries
  • Advanced SQL

Day 2

  • TRIGGERS, UDT and UDF
  • SQL Functions
  • performance for SQL
  • Data Access and EXPLAIN
We regularly offer classes in these and other cities. Atlanta, Austin, Baltimore, Calgary, Chicago, Cleveland, Dallas, Denver, Detroit, Houston, Jacksonville, Miami, Montreal, New York City, Orlando, Ottawa, Philadelphia, Phoenix, Pittsburgh, Seattle, Toronto, Vancouver, Washington DC.
*Your name:

*Your e-mail:

*Phone:

*Company name:

Additional notes:

We have received your message. A sales representative will contact you soon.

Thank you!.

more details
buy this course

Register for a courseware sample

It's simple, and free.

 

Thank You!

You will receive an email shortly containing a link to download the requested sample of the labs for this course.