Sybase Training Overview:

The Sybase Performance and Tuning class provides the students with a detailed understanding of the many methods they can employ to maximize the advantages of the Sybase relational database management system. Students will be presented with numerous step by step procedures to implement in order to realize the most useful capabilities within Sybase.

Many class exercises and potential problem situations will be discussed as a means to reinforce the material presented within the lectures.

Upon completion of the course, the students will have a detailed knowledge of the manner by which to achieve the most practical and efficient processing available within the Sybase Server system.

Sybase Training Objectives:

Upon successful completion of this course, participants will be able to implement numerous tuning and performance factors that will provide them with very efficient processing within their databases.

The student will understand the internal means by which the optimizer processes, and will be knowledgeable of the advantages of indexes. Logical and physical data structures will be understood by the students, as well as the methods by which Sybase internally performs it processing.

The students will understand ways of writing SQL statements that will process quite efficiently. Methods which allow for effective processing in multi-user environments will be discussed in detail.

Sybase Training Prerequisites:

Students should have an understanding of the facilities of Structured Query Language processing, and should have attended the Introduction to Sybase and Transact_SQL facilities class. Additionally, students should have been working with Sybase for a period of at least three months.

Sybase Training Audience:

This course is recommended for applications programmers, system and database administrators, database designers and all other related personnel who require an in-depth understanding of the means by which to tune the Sybase system. People who are interested in learning how to code efficient SQL statements should also attend this course.

Course duration:

5 days

Sybase Training Course outline

Performance and Tuning Objectives

Factors that Influence Performance

SQL Coding Conventions

Means by which to code SQL Statements to obtain the most effective performance

Logical Database Design

Normalization versus Denormalization

Denormalization Techniques

Physical Data Structure

Index Structures

Row Modification Processing

Fill Factor Advantages and Disadvantages

Computing Index Sizes

Size and Speed of Indexes

Index Performance Considerations

Determining When to Use Indexes

Index Data Distribution Statistics

Query Optimizer Processing

Search Arguments

OR Processing

Optimizer Join Processing

Row and Page Estimates

Index Covering Techniques

Performance Considerations for Aggregates

Multi-Table Joins

Nested Iterations

Sort merge joins

Hash joins

Reformatting Strategy

Stored Procedure Considerations

When and how to recompile stored procedures

Temporary Tables

Multi-User Locking Facilities

System Tuning Capabilities

Database Options

Analyzing Problems