KT-OD400 IBM DB2 for i SQL Performance Monitoring and Tuning Workshop Training - Minneapolis, Minnesota IT MN Technical Financial New York, NY
Knowledge Transfer Microsoft Certified Silver Training Partner CPLS
Knowledge Transfer is a Microsoft Certified Silver Learning Partner
Oracle University

 

Microsoft Certified Training Partner CTEC
Search for a Course Topic:
Public Courses
Corporate Services & Training
 

 

 



 Course Search
Keyword
Course #
State

 Training Delivery
 
Training Delivery
Custom Curriculum
Course List
Certifications
 
 Main Menu
 
Home
View Courses
Site Index
 
 


IBM DB2 for i SQL Performance Monitoring and Tuning Workshop


Description: 

Learn the information, tools and strategies for monitoring, analyzing and tuning IBM DB2 for i5/OS Structured Query Language (SQL). Explore the science and art behind the DB2 for i5/OS query optimizer and database engine, including database performance and scalability. Discuss performance issues affecting database design and data-centric applications. Get hands on experience with database performance parameters and options, as well as the various tools that assist in performance monitoring, analysis and tuning. Knowledge and skill gained by attending this course are considered critical success factors when building and deploying SQL based solutions.

Skills taught 

  • Understand the art and science of DB2 for i5/OS SQL query optimization and execution  
  • Explain the strategies and related methodology for monitoring, analyzing and tuning DB2 for i5/OS SQL and query performance Discuss how to design high-performing SQL applications on the System i  
  • Recognize the database and system parameters and options that can impact performance

 
Click here to view the Course Outline
     
Prerequisite: 

Audience 

This is an intermediate course for i5/OS database designers, performance analysts, and application developers who are concerned about SQL and query performance. It is highly recommended for individuals interested in SQL and query performance of System i running i5/OS as the database server, application server or web server. This course is also designed for database administrators, database consultants and performance analysts working in and around iSeries or System i.

Prerequisites 

You should have:

  • Intermediate knowledge of SQL and relational database concepts Basic understanding of DB2 for i5/OS  
  • Basic understanding of Sytem i and i5/OS architecture and application concepts  
  • Basic understanding of System i and i5/OS work management
 
   
     
Duration: 
4 Days  
     
     

View Printer Friendly Page

 


To Inquire About Future Classes

Request a class date

if one is not scheduled.