Email Us   Phone : 503-259-0312   
  Home    |    Instructor-led Training    |    Online Training     


Contact Us   -   Why Choose Wintrac   -   Clients    

Courses
ADA
Adobe
Agile
AJAX
Android
Apache
AutoCAD
Big Data
BlockChain
Business Analysis
Business Intelligence
Business Objects
Business Skills
C/C++/Go programming
Cisco
Citrix
Cloud Computing
COBOL
Cognos
ColdFusion
COM/COM+
CompTIA
CORBA
CRM
Crystal Reports
Data Science
Datawarehousing
DB2
Desktop Application Software
DevOps
DNS
Embedded Systems
Google Web Toolkit (GWT)
IPhone
ITIL
Java
JBoss
LDAP
Leadership Development
Lotus
Machine learning/AI
Macintosh
Mainframe programming
Microsoft technologies
Mobile
MultiMedia and design
.NET
NetApp
Networking
New Manager Development
Object oriented analysis and design
OpenVMS
Oracle
Oracle VM
Perl
PHP
PostgreSQL
PowerBuilder
Professional Soft Skills Workshops
Project Management
Rational
Ruby
Sales Performance
SAP
SAS
Security
SharePoint
SOA
Software quality and tools
SQL Server
Sybase
Symantec
Telecommunications
Teradata
Tivoli
Tomcat
Unix/Linux/Solaris/AIX/
HP-UX
Visual Basic
Visual Foxpro
VMware
Web Development
WebLogic
WebSphere
Websphere MQ (MQSeries)
Windows programming
XML
XML Web Services
Other
Sybase Performance and Tuning Considerations for Developers
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




 
About us
Contact us
Careers at Wintrac
Our Clients
Why Wintrac


Register for a free training CD-ROM drawing
Refer a client or instructor and earn $$$


Wintrac Inc.
16523 SW McGwire Ct.
Beaverton OR 97007
 
Wintrac, Inc. All rights reserved.                                                                               Site Map   |   Terms of Use   |   Privacy Policy