www.protechtraining.com Open in urlscan Pro
2606:4700:20::681a:e9c  Public Scan

Form analysis
1 forms found in the DOM

/training/search

<form action="/training/search" id="header-search-form">
  <input id="terms" name="terms" type="text" placeholder="SEARCH" class="search-input">
  <i class="fa fa-search search-icon" style="cursor: pointer;" onclick="document.getElementById('header-search-form').submit();"></i>
</form>

Text Content

Skip to main content
 

  Login
Contact Us

 




HEADER MAIN

 * Training
   ProTech Training Virtual Classroom Schedule Browse Full Catalog (3000+) View
   Courses By Location Guaranteed To Run Courses Recently Added Courses
   Multi-Week Bootcamp Courses Voucher Eligible Courses Course Delivery Options
   Digital Badge Program Government Training Solutions
   BROWSE OUR COURSE CATALOG
   ITIL & Governance Project & Portfolio Management Communication & Business
   Skills Business Analysis, Agile & DevOps Software Testing & Quality Assurance
   Java & Open-Source IBM Mainframes & ISV Products Databases, Data Science &
   Automation
   Unix & Linux Front-End Web & Mobile Development Microsoft Infrastructure,
   Development & Business Applications Cloud & Virtualization CompTIA, Help
   Desk, Apple & Multimedia Networking and Wireless Cybersecurity & IT Auditing
   
 * Consulting
   * ProTech Consulting
   * Automation Assessment
   * Automation Consulting
   * Automation Outsourcing
   * Operations Processing Assessment
   * Performance Availability Engineering
   * Scheduling Assessment
   * Scheduling Conversion
 * Software
   * ProTech Software
   * Free Downloads
 * About Us
   * About Us
   * Our Clients
   * Partners
   * Blog
   * Careers
   * Contact Us
   * News
 * Resources
   * Upcoming Webinars
   * Past Webinars
   * Articles and Blogs
   * Video Resources

 1. Home
 2. Training
 3. IBM Mainframes & ISV Products
 4. Db2 for z/OS for Developers


DB2 FOR Z/OS SQL ACCESS PATH OPTIMIZATION & PERFORMANCE TUNING

Select a training location Virtual Classroom Albany, New York + Virtual
Classroom Albuquerque, New Mexico + Virtual Classroom Annapolis, Maryland +
Virtual Classroom Atlanta, Georgia + Virtual Classroom Augusta, Maine + Virtual
Classroom Austin, Texas + Virtual Classroom Baltimore, Maryland + Virtual
Classroom Baton Rouge, Louisiana + Virtual Classroom Billings, Montana + Virtual
Classroom Bismarck, North Dakota + Virtual Classroom Boise, Idaho + Virtual
Classroom Boston, Massachusetts + Virtual Classroom Buffalo, New York + Virtual
Classroom Calgary, Alberta + Virtual Classroom Carson City, Nevada + Virtual
Classroom Charleston, West Virginia + Virtual Classroom Charleston, South
Carolina + Virtual Classroom Cheyenne, Wyoming + Virtual Classroom Chicago,
Illinois + Virtual Classroom Cincinnati, Ohio + Virtual Classroom Cleveland,
Ohio + Virtual Classroom Colorado Springs, Colorado + Virtual Classroom
Columbia, South Carolina + Virtual Classroom Columbia, Maryland + Virtual
Classroom Columbus, Ohio + Virtual Classroom Concord, New Hampshire + Virtual
Classroom Dallas-Ft Worth, Texas + Virtual Classroom Denver, Colorado + Virtual
Classroom Des Moines, Iowa + Virtual Classroom Detroit, Michigan + Virtual
Classroom Dover, Delaware + Virtual Classroom Framingham, Massachusetts +
Virtual Classroom Frankfort, Kentucky + Virtual Classroom Halifax, Nova Scotia +
Virtual Classroom Harrisburg, Pennsylvania + Virtual Classroom Hartford,
Connecticut + Virtual Classroom Helena, Montana + Virtual Classroom Honolulu,
Hawaii + Virtual Classroom Houston, Texas + Virtual Classroom Indianapolis,
Indiana + Virtual Classroom Jackson, Mississippi + Virtual Classroom Jefferson
City, Missouri + Virtual Classroom Juneau, Alaska + Virtual Classroom Kansas
City, Missouri + Virtual Classroom Lansing, Michigan + Virtual Classroom Las
Vegas, Nevada + Virtual Classroom Lincoln, Nebraska + Virtual Classroom Little
Rock, Arkansas + Virtual Classroom Los Angeles, California + Virtual Classroom
Madison, Wisconsin + Virtual Classroom Memphis, Tennessee + Virtual Classroom
Miami, Florida + Virtual Classroom Milwaukee, Wisconsin + Virtual Classroom
Minneapolis-St. Paul, Minnesota + Virtual Classroom Montgomery, Alabama +
Virtual Classroom Montpelier, Vermont + Virtual Classroom Montreal, Quebec +
Virtual Classroom Nashville, Tennessee + Virtual Classroom New Orleans,
Louisiana + Virtual Classroom New York, New York + Virtual Classroom Oklahoma
City, Oklahoma + Virtual Classroom Olympia, Washington + Virtual Classroom
Omaha, Nebraska + Virtual Classroom Orlando, Florida + Virtual Classroom Ottawa,
Ontario + Virtual Classroom Parsippany, New Jersey + Virtual Classroom
Philadelphia, Pennsylvania + Virtual Classroom Phoenix, Arizona + Virtual
Classroom Pierre, South Dakota + Virtual Classroom Pittsburgh, Pennsylvania +
Virtual Classroom Portland, Maine + Virtual Classroom Portland, Oregon + Virtual
Classroom Providence, Rhode Island + Virtual Classroom Raleigh-Durham, North
Carolina + Virtual Classroom Reston, Virginia + Virtual Classroom Richmond,
Virginia + Virtual Classroom Rockville, Maryland + Virtual Classroom Sacramento,
California + Virtual Classroom Salem, Oregon + Virtual Classroom Salt Lake City,
Utah + Virtual Classroom San Francisco, California + Virtual Classroom Santa Fe,
New Mexico + Virtual Classroom Seattle, Washington + Virtual Classroom
Springfield, Illinois + Virtual Classroom Springfield, Missouri + Virtual
Classroom St Louis, Missouri + Virtual Classroom Tallahassee, Florida + Virtual
Classroom Tampa-St Pete, Florida + Virtual Classroom Topeka, Kansas + Virtual
Classroom Toronto, Ontario + Virtual Classroom Trenton, New Jersey + Virtual
Classroom Tucson, Arizona + Virtual Classroom Tulsa, Oklahoma + Virtual
Classroom Vancouver, British Columbia + Virtual Classroom Victoria, British
Columbia + Virtual Classroom Wash Metro Area, District Of Columbia + Virtual
Classroom Wichita, Kansas + Virtual Classroom Your Training Location:
Virtual Classroom
 * Select a training location
 * Virtual Classroom
 * Albany, New York + Virtual Classroom
 * Albuquerque, New Mexico + Virtual Classroom
 * Annapolis, Maryland + Virtual Classroom
 * Atlanta, Georgia + Virtual Classroom
 * Augusta, Maine + Virtual Classroom
 * Austin, Texas + Virtual Classroom
 * Baltimore, Maryland + Virtual Classroom
 * Baton Rouge, Louisiana + Virtual Classroom
 * Billings, Montana + Virtual Classroom
 * Bismarck, North Dakota + Virtual Classroom
 * Boise, Idaho + Virtual Classroom
 * Boston, Massachusetts + Virtual Classroom
 * Buffalo, New York + Virtual Classroom
 * Calgary, Alberta + Virtual Classroom
 * Carson City, Nevada + Virtual Classroom
 * Charleston, West Virginia + Virtual Classroom
 * Charleston, South Carolina + Virtual Classroom
 * Cheyenne, Wyoming + Virtual Classroom
 * Chicago, Illinois + Virtual Classroom
 * Cincinnati, Ohio + Virtual Classroom
 * Cleveland, Ohio + Virtual Classroom
 * Colorado Springs, Colorado + Virtual Classroom
 * Columbia, South Carolina + Virtual Classroom
 * Columbia, Maryland + Virtual Classroom
 * Columbus, Ohio + Virtual Classroom
 * Concord, New Hampshire + Virtual Classroom
 * Dallas-Ft Worth, Texas + Virtual Classroom
 * Denver, Colorado + Virtual Classroom
 * Des Moines, Iowa + Virtual Classroom
 * Detroit, Michigan + Virtual Classroom
 * Dover, Delaware + Virtual Classroom
 * Framingham, Massachusetts + Virtual Classroom
 * Frankfort, Kentucky + Virtual Classroom
 * Halifax, Nova Scotia + Virtual Classroom
 * Harrisburg, Pennsylvania + Virtual Classroom
 * Hartford, Connecticut + Virtual Classroom
 * Helena, Montana + Virtual Classroom
 * Honolulu, Hawaii + Virtual Classroom
 * Houston, Texas + Virtual Classroom
 * Indianapolis, Indiana + Virtual Classroom
 * Jackson, Mississippi + Virtual Classroom
 * Jefferson City, Missouri + Virtual Classroom
 * Juneau, Alaska + Virtual Classroom
 * Kansas City, Missouri + Virtual Classroom
 * Lansing, Michigan + Virtual Classroom
 * Las Vegas, Nevada + Virtual Classroom
 * Lincoln, Nebraska + Virtual Classroom
 * Little Rock, Arkansas + Virtual Classroom
 * Los Angeles, California + Virtual Classroom
 * Madison, Wisconsin + Virtual Classroom
 * Memphis, Tennessee + Virtual Classroom
 * Miami, Florida + Virtual Classroom
 * Milwaukee, Wisconsin + Virtual Classroom
 * Minneapolis-St. Paul, Minnesota + Virtual Classroom
 * Montgomery, Alabama + Virtual Classroom
 * Montpelier, Vermont + Virtual Classroom
 * Montreal, Quebec + Virtual Classroom
 * Nashville, Tennessee + Virtual Classroom
 * New Orleans, Louisiana + Virtual Classroom
 * New York, New York + Virtual Classroom
 * Oklahoma City, Oklahoma + Virtual Classroom
 * Olympia, Washington + Virtual Classroom
 * Omaha, Nebraska + Virtual Classroom
 * Orlando, Florida + Virtual Classroom
 * Ottawa, Ontario + Virtual Classroom
 * Parsippany, New Jersey + Virtual Classroom
 * Philadelphia, Pennsylvania + Virtual Classroom
 * Phoenix, Arizona + Virtual Classroom
 * Pierre, South Dakota + Virtual Classroom
 * Pittsburgh, Pennsylvania + Virtual Classroom
 * Portland, Maine + Virtual Classroom
 * Portland, Oregon + Virtual Classroom
 * Providence, Rhode Island + Virtual Classroom
 * Raleigh-Durham, North Carolina + Virtual Classroom
 * Reston, Virginia + Virtual Classroom
 * Richmond, Virginia + Virtual Classroom
 * Rockville, Maryland + Virtual Classroom
 * Sacramento, California + Virtual Classroom
 * Salem, Oregon + Virtual Classroom
 * Salt Lake City, Utah + Virtual Classroom
 * San Francisco, California + Virtual Classroom
 * Santa Fe, New Mexico + Virtual Classroom
 * Seattle, Washington + Virtual Classroom
 * Springfield, Illinois + Virtual Classroom
 * Springfield, Missouri + Virtual Classroom
 * St Louis, Missouri + Virtual Classroom
 * Tallahassee, Florida + Virtual Classroom
 * Tampa-St Pete, Florida + Virtual Classroom
 * Topeka, Kansas + Virtual Classroom
 * Toronto, Ontario + Virtual Classroom
 * Trenton, New Jersey + Virtual Classroom
 * Tucson, Arizona + Virtual Classroom
 * Tulsa, Oklahoma + Virtual Classroom
 * Vancouver, British Columbia + Virtual Classroom
 * Victoria, British Columbia + Virtual Classroom
 * Wash Metro Area, District Of Columbia + Virtual Classroom
 * Wichita, Kansas + Virtual Classroom


 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $3,120.00 CAD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $3,120.00 CAD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $3,120.00 CAD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $3,120.00 CAD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $3,120.00 CAD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $3,120.00 CAD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $3,120.00 CAD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $3,120.00 CAD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $3,120.00 CAD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $3,120.00 CAD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $3,120.00 CAD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $3,120.00 CAD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $3,120.00 CAD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $3,120.00 CAD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * Feb 12 - 15, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart
 * May 28 - 31, 2024 10:00 AM - 5:00 PM ET
   $2,600.00 USD
   Add to cart

Show Full Schedule

Add To Watch List Request In Your Area Request Private Class View PDF
PT25935
Training Summary
This class is designed to break down SQL statements in detail so the
participants understand in depth what the Db2 optimizer goes through in
fulfilling an SQL request. Time will especially be spent breaking down SQL Joins
and Subqueries in order to understand the fundamental issues associated with
performance. The class will address performance-related issues in relationship
to database design, indexing, efficient and effective SQL queries, and the
gathering of accurate statistical information for optimization. Participants
will come out of this class having a much better understanding of why certain
optimizations are chosen, and what can be done to get Db2 to choose differently.
Much of the class will be in workshops where the participants will review
queries, execute Db2 Explains, and perform analysis on the information. Many of
the workshops have the participants apply tuning statements to existing queries
in order to get them to perform more efficiently. Participants will know exactly
what steps to take in getting poor performing SQL queries to execute more
efficiently.
Prerequisites
A working knowledge of Db2 for z/OS environment and the SQL language.
Duration
4 Days/Lecture & Lab
Audience
All personnel involved in SQL Access path performance tuning that require an
in-depth understanding of the full complement of Explain Tables provided by Db2.
Course Topics
 * Introduction
 * Predicate Types and Performance
 * Basic Access Paths and Performance
 * Tuning Joins
 * Aggregate Functions, SQL Subqueries & Performance
 * Tables expressions and Performance
 * Db2 Catalog Statistics and Access Path Selection
 * Advanced Query Tuning


RELATED SCHEDULED COURSES

DB2 FOR Z/OS APPLICATION PROGRAMMING AND DESIGN

DB2 CONCEPTS AND FACILITIES

DB2 FOR Z/OS ADVANCED SQL WITH PERFORMANCE AND TUNING FOR PROGRAMMERS

DB2 FOR Z/OS COBOL STORED PROCEDURES

PAGINATION

 * 1
 * 2
 * 3
 * Next › Next page
 * Last » Last page

‌ ‌ ‌ ‌

ProTech Professional Technical Services, Inc.
EMAIL: INFO@PROTECHTRAINING.COM
Toll Free: 866-358-1727
GSA #GS-35F-0486W

Join Our Mailing List

 

Copyright © 2023 ProTech Professional Technical Services, Inc. All Rights
Reserved.