//|||| \\\
      //  || \\  \\
     //   || \\
    //    ||   \\
   //     ||     \\
  ////////||      \\
 //       || \\  \\\
//       ||||  \\\

ABLE Information Services

Database Index Design

Database Index Design logo

Home
Course Description
Manager's Benefits
Contact DBIndexDesign
Course Author
Schedule and Directions
How to Register
About DBIndexDesign
Index Design Quiz1
HR/Training In-house
Tapio's Book

ABLE Information Services presents in partnership with Tapio Lahdenmäki S. P.

A New Performance Course that moves cost-saving design up front to your development team:

        TL120   Cost-Saving Database Index Design

       Next class July 24 - 25, 2008 in Belleville/East St. Louis Illinois          Schedule

                   Test your skills...take our  Index Design Quiz1

   "Inadequate indexing … … …
     … … is the most common reason for performance problems"

Today's database systems are complex, constantly adding applications and queries, and difficult for your
DBA' team to keep tuned. So let's train them and your best developers about how optimizers work,
how indexes are exploited by the SQL they write, and how to design the best possible index for each
important query and report. When the training is complete you won't worry :


Has your best programmer cost you money today unnecessarily?
. . .kept one customer from coming back? . . .made your warehouse crew curse the slow computer?
. . .. . . kept your call-center associates apologizing for slow response times?
Does your marketing team get slow turn-around on big queries?
. . .Does your web-page take 5 seconds to return a customer's last 20 transactions?
. . . . . .Does a 5-table join make your users go for a coffee break?

You wouldn’t allow an incorrect program to run:
. . . why isn’t a too-slow query or report also considered a costly, poor quality defect?


Send your best programmers and application DBA's to ABLE Information Service's
2-day class and we'll show them how to keep customers coming back and save you thousands of dollars.

  It's easy to teach a developer how to save $1,000 a month while producing
  her top-notch system. ABLE's experienced instructors will teach those techniques
  in a 2-day class for just US $621 when you send two or more [ regular price US $690 ].
  And your students will get a copy of Tapio Lahdenmäki's book on index design
  for in-depth background, examples and review.

  See a list of Benefits for Managers


  Course Objective

  Students will learn a well-tested method to predict                               
  and detect inadequate indexing as early as possible for new programs.         

  They'll know how optimizers use indexes.

  They'll learn a technique to derive cost-effective indexes for SELECT statements
     -- including complex joins.


  Students do several design exercises and case studies from real systems.                      Master teacher Larry Kintisch

  They'll learn cost-saving methods for improving existing production database applications,
       usually without changing application programs.

The recommendations and rules are based on current (2007-2008) hardware and the course is product-independent.
The methods have been applied with good results in the following environments:

  Oracle,  DB2 for z/OS,  DB2 for Unix and Linux,  
           Microsoft SQL Server,  Sybase and  Informix.

Audience

Course developer: Tapio Lahdenmäki.    US Course Instructor:  Larry Kintisch

To See Course Contents

To See Management Overview of Index Design benefits

To See a Schedule of Planned Classes       Next class can be in a city near you!      City Request

To See Pricing and How to Register

About Database Index Design and ABLE Information Services

Test your skills...take our Index Design Quiz1

Contact Database Index Design

Web Hosting by EASYCGI.com

Database Index Design is a division of ABLE Information Services    [v080323]