ASE Training Courses and Workshops
School(s) providing training of HP Accredited Sytems Engineer

Understanding Indexes
Course Format: Classroom
School/Trainer: Sybase, Inc. [>>]
Training Centers: Atlanta, Chicago, Concord, Bethesda, Dallas, Irvine, New York, Washington etc., U.S.

Indexes are chosen by the optimizer based on information that is perceived to be true. Gain an understanding of how perception can differ from reality and the impact that it can have on query performance. Study actual benchmark statistics for such actions as creating indexes, running update statistics and executing various queries under a number of real-life circumstances. Actual statistics on ......

Course description>>

 

Learn to write flexible, customized Open Server Library 11 applications. Open Server allows you to develop middle tier server applications. Develop a Help Desk application that demonstrates the fundamental Open Server techniques including starting and stopping the server; getting information from the client; handling errors; and returning results to the client. Objectives Upon co......

Course description>>

 

Learn the new features and functionality in Open Client-Library 11. Client-Library enables you to write flexible, customized applications that communicate with Sybase SQL Server, Adaptive Server Enterprise or Open Server. Learn how to initialize the client/server environment, connect to a server, send static and dynamic requests to the server, and process the results - including normal and comp......

Course description>>

 

This lecture-only course presents ways you can affect the optimizer’s behavior by fooling it, cheating it, and lying to it. We’ll discuss the well-known, understood, and documented force index and forceplan options, and examine how you can affect the optimizer’s behavior by adding, modifying and deleting statistics. Have your queries get to the data with less I/O. Understand docu......

Course description>>

 

Available server monitoring tools typically generate reports that are server wide: you can’t easily focus on a particular database, process, or table; and monitoring tools can be expensive. You can build performance enhancement tools for your Adaptive Server Enterprise 12.5.3 and later servers, that allow you to focus on the specifics of your particular environment - database, process, obj......

Course description>>

 

Understand this site critical report and how best to use its information. Gain an overall view of the different reports that are generated by SP_SYSMON. Get a line-by-line analysis of what the eighteen reports are; when and how often they should be run and what each report provides. Each of the SP_SYSMON reports will be covered. Recommendations will be provided on which reports should be focuse......

Course description>>

 

Acquire a working knowledge of Sybase IQ through a combination of lecture presentation and hands-on laboratory exercises. Learn Sybase IQ architecture, concepts, and terminology while setting up, loading, and maintaining a Sybase IQ database. Course material also covers must-know monitoring and troubleshooting methods, as well as important technical information to increase the performance and t......

Course description>>

 

Linux is quickly becoming a mainstream operating system for businesses requiring the stability and reliability of Unix with the additional benefits of lower IT infrastructure and computing costs. Sybase has responded to this trend by certifying and supporting its products on Linux, including Sybase Adaptive Server Enterprise. This training course will show you how to assess an existing Unix or ......

Course description>>

 

Introduce the new Sybase ASE 12.5.0.1 feature ASE Replicator. Walk through the process of setting up ASE Replicator, discuss it use and limitations. Additionally, basic troubleshooting hints are covered. Who Should Attend Sybase Database Administrator’s who are planning on implementing ASE Replicator Topics Review of Replication techniques Implementing ASE Repl......

Course description>>

 

This course will teach ASE administrators how to read and interpret information found with the ASE system tables . Who Should Attend Database Administrators Objectives Upon completion of this course, you will be able to: Identify all major ASE System Tables Understand the function and relationship between key ASE system tables Customize existing sp_¡¯s Write......

Course description>>

 

Pages:- ...41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 ...

Algeria - Argentina - Australia - Austria - Belgium - Brazil - Canada - Chile - Denmark - Egypt - Finland - France - Germany - Greece - India - Indonesia - Ireland - Italy - Japan - Luxembourg - Malaysia - Netherlands - New Zealand - Nigeria - Norway - Pakistan - Peru - Philippines - Russia - Singapore - South Africa - Spain - Sweden - Switzerland - United Arab Emirates - United Kingdom - United States