Calgary - Edmonton - Halifax - Mississauga - Montreal - Ottawa - Toronto - Vancouver - Victoria - Winnipeg

ASE training courses and schools
HP Accredited Sytems Engineer

School: Sybase Canada Ltd.
[All Courses]

Behind the Scenes with DBCC Commands
Course Format: Classroom
Corruption of a production database can be a serious problem. This could mean lost data and/or extensive down time. Either one resulting in huge financial losses. Behind the Scenes with DBCC Commands looks at a variety of DBCC commands that are available to assist in identifying database corruption before it becomes a problem. You’ll learn about the available commands, how they work and wh...
 

Introduction to SQL Expert
Course Format: Classroom
Gain an introduction to the new Sybase utility, SQL Expert. Focus is on core features of SQL Expert including: Database Explorer, SQL Editor, SQL Formatter, Syntactical SQL Optimizer and SQL Comparer. These features along with the SQL Monitor and the SQL Scanner make up the SQL Expert utility. Learn to use SQL Expert to enter code, benchmark performance and compare source SQL code with the alte...
 

Powering Up to ASE Interim Releases
Course Format: Classroom
Course will include how to download and install the current interim release version 0.1 for Adaptive Server Enterprise (ASE) 12.5. We will cover the new features associated with 0.1, including disk resize, grantable dbcc’s, the new ASE migration tool, performance enhancements to JAVA and XML, and introduce the new ASE lightweight replication feature. We will also introduce available featur...
 

Using SybMigrate
Course Format: Classroom
This lecture covers an understanding of the architecture and functionality of the new SybMigrate Utility. This will prepare you to use and fully employ the utility when migrating a database from an existing server to a server with a larger page size. Topics covered include the Architecture and features of the Utility as well as the requirements for using the utility. A walk through the migratio...
 

Harness the Power with Configurable Parameters
Course Format: Classroom
Take full advantage of the power and capabilities of Sybase Adaptive Server Enterprise database software. The lecture reviews and explains parameters that can be modified to improve server performance. Other parameters are discussed providing you with a complete understanding of possible modifications through configurable parameters. Become familiar with options to a server, identify parameters...
 

Understanding Indexes
Course Format: Classroom
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 ...
 

Open Server Programming
Course Format: Classroom
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...
 

Open Client Programming Using Client-Library
Course Format: Classroom
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...
 

Fooling, Cheating, Lying and Understanding the Optimizer
Course Format: Classroom
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...
 

Advanced Performance: Monitoring Tables Facility
Course Format: Classroom
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...
 

Page(s):- ...4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 [ Popular Topics ]