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]

Logical Database Design
Course Format: Classroom
Learn to apply consistent methodology in creating a logical database design that is based on the relational data model and confirms to formal standards of normalization. Examine techniques for gathering and analyzing business rules, using entity-relationship diagrams to capture conceptual data designs, and modeling business processes with data flow diagrams. Study the theoretical foundations of...
 

Performance and Tuning: Adaptive Server Enterprise Query Optimizer
Course Format: Classroom
Learn how to tune queries and Stored Procedures for optimal performance using Adaptive Server Query Optimizer. Study various techniques for writing high-performance queries that allow the optimizer to use the most efficient query plan, and learn how to diagnose and correct performance problems with existing queries. Gain proficiency in interpreting and modifying optimizer statistics to improve ...
 

Troubleshooting Adaptive Server Data Structures
Course Format: Classroom
Gain a deeper understanding of the data structures inside Sybase Adaptive Server Enterprise (ASE) 12.5.0.1 and how they are allocated and de-allocated. This expert-level course gets you ¡°under the hood¡± and exposes you to in-depth technical detail. Use this knowledge to prevent potential problems from database corruption and to reduce time working with Sybase Technical Support. Troubleshoot, re...
 

Advanced Administration and Troubleshooting for Adaptive Server
Course Format: Classroom
Get a hands-on, in-depth look at Adaptive Server Enterprise (ASE). Examine relevant internal data structures and practical troubleshooting techniques. Learn to diagnose and prevent potentially disastrous situations, optimize your use of the features of ASE for normal administrative tasks, perform mission-critical administrative tasks for efficiently, improve system performance for end users and...
 

Performance and Tuning: Configuring Adaptive Server Enterprise
Course Format: Classroom
Learn to tune Adaptive Server Enterprise (ASE) for optimal performance and explore ASE architecture in depth. Study topics that include designing databases for performance, diagnosing and correcting performance problems, managing ASE system resources (CPUs, disks, I/o), optimizer statistics, SMP features, relevant data structures, benchmarking turning methodology and techniques, and parallel pr...
 

System and Database Administration: Adaptive Server Enterprise 12.5
Course Format: Classroom
Learn how to identify the major tasks of Sybase system and database administration and practice these tasks using your own Adaptive Server Enterprise (ASE) 12.5.0.1 in a safe and controlled environment. Emphasis is given to resource management (memory, disk, and CPU) with a goal of creating a reliable Adaptive Server environment. Examine fundamental monitoring and troubleshooting methods, backu...
 

Fast Track to Adaptive Server Enterprise
Course Format: Classroom
Gain hands-on experience with the newest features of Adaptive Server Enterprise (ASE), and learn to create database objects expertly using ANSI-standard SQL and Transact-SQL extensions. Study key features and functions of ASE including automatic recovery of transactions, writing Stored Procedures and triggers, and creating and using cursors. Course material also covers important concepts from I...
 

Mastering Transact-SQL Programming: Advanced Tips & Techniques
Course Format: Classroom
Learn an array of valuable tips, techniques, and advanced topics to implement cleaner and more efficient code. Lecture and lab emphasis is on good coding practices, manipulating numbers and dates, joins and subqueries, applied case logic, cursors, and proper Stored Procedure development and debugging, as well as generalized methods for solving specific problems. Course Objectives : Upon comp...
 

Securing Adaptive Server Enterprise Communications
Course Format: Classroom
Securing data while moving from client to server or from server to server is a major issue in a database environment for administrators and system security officers. Learn about network security issues in general and how Sybase Adaptive Server Enterprise (ASE) database software is configured to provide secure client/server and server/server communications. ASE 12.5 supports two mechanisms for c...
 

Backup Server Unleashed
Course Format: Classroom
The Backup Server is a critical element in the management of data; but it is often overlooked from a Disaster Recovery standpoint. Learn how to configure this new "no limits" Backup Server to dump and load any size database faster and on more devices, than ever before. A practical knowledge of the Adaptive Server Enterprise 12.5 Backup Server will also enable you to design appropriate...
 

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