Adaptive Server Enterprise school training courses in Chicago, IL (public, in-house or online)

Learn how to identify the major tasks of Sybase system and database administration and practice these tasks using your own Adaptive Server Enterprise (ASE) in a safe and controlled environment. Emphasis is given to resource management (memory, disk, and tempdb space with a goal of creating a reliable Adaptive Server environment. Examine fundamental monitoring and troubleshooting methods, backup and recovery strategies, job scheduling and user access issues.
Course Objectives :
Upon comple...

Full archival course description>>

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 Introduction to SQL (EDB100), new functions, increased number of arguments in IN statements, increased l...

Full archival course description>>

Designed as a core requirement for ASE SQL Developers who want to explore the Adaptive Server Enterprise 15.0 Query Optimizer so as to enable them to improve the performance of their queries. This course is also the core requirement in our ASE 15 Migration for Developers training program.

Learn to measure the performance of T-SQL queries and tune your query development for the specific requirements of your business. Take advantage of the monitoring and evaluation tools of Adaptive Server ...

Full archival course description>>

Gain an introduction to and familiarity with the implementation of Mode-2 high availability, a high availability architecture [also called distributed workloads] in which disjoint applications can run on each of the nodes of a cluster. When one node fails, the surviving node takes over its workload avoiding the "e-nightmare" of lost data access during planned or unplanned server downtime. Use Adaptive Server Enterprise 12.0’s companion server functionality to provide continuous da...

Full archival course description>>

Learn the extended skills of server administration: what to do when hardware fails, and how to implement special-use features of Adaptive Server Enterprise 15. Practical troubleshooting techniques and disaster prevention will make ASE highly available. Special features allow for greater flexibility in migration and automating administration, server monitoring, integrated data spaces, and resource management.
Course Objectives :
Upon completion of this course, you will be able to:
Crea...

Full archival course description>>