The Fast Track to Adaptive Server Enterprise Course
The target audience for this course is Database Administrators, Database Designers, End-Users and SQL Developers.
Аfter completion of this course you will be able to use the basic components of Adaptive Server Enterprise to connect to a server database, to create tables, populate the tables with data, and efficiently query data from those tables.You will be able also to write code in Transact-SQL. Upon completion of the course will be able to effectively use and manage transactions and create procedures for their operation.
SQL Anywhere 10.0 Fundamentals Course
This 2-days course is designed for Database Administrators and SQL Anywhere Application Developers. The goal of the course is to explain how to develop and manage standalone network databases; insert data into and retrieve data from local and remote databases.
The course explain how you should use proxy tables to access remote database and automate tasks with schedules and events. During the course will learn how to use the debugger for solving problems with procedures, events, queries for best performance. After the end of the course you will understand the common Application Programming Interfaces (ODBC, ESQL, JDBC, ADO, Open Client, .NET) in addition to the SQL Anywhere general programming interface.
ASE 15 Migration for DBAs Course
The target audience for this course is Database Administrators, Sybase System Administrators and SQL Developers.
During the course you will explore the Adaptive Server Enterprise 15.0.3 server environment from a database administration perspective before and after a migration. Also, take advantage of the monitoring and evaluation tools of Adaptive Server Enterprise 15; interpret their diagnoses into specific plans of action; and perform tasks to evaluate and modify the behavior of the optimizer. After the course you will be able to work more efficiently with the statistics used by the new optimizer and make changes to existing methodologies for generating them.
Performance and Tuning: Configuring Adaptive Server Enterprise Course
This 5-days course is designed for Database Administrators and Open Interface Developers.
During the course you will learn how you to tune Adaptive Server Enterprise (ASE) for optimal performance. After the course you will be familiar with the ASE architecture, and also be able to identify and correct problems in the database physical design, including table titles.
Study topics that include designing databases, diagnosing and correcting performance problems, managing ASE system resources (CPUs, disks, I/O), SMP features, benchmarking turning methodology and techniques.
Powering Up with ASE 15.0 Course
The target audience for this course is Database Administrators, Performance and Tuning Specialists, Database Designers, System Analysts and Architects.
This course is iniciated to give you skills and in-depth knowledge to upgrade from a previous release of ASE, become familiar with the new ASE 15.0 utilities. You will become familiar identify the new functions available for SQL development. During the course you will learn the new techniques for performance monitoring and optimization. Gain hands-on experience with the newest features of Adaptive Server Enterprise version 15.0, which includes a vast array of new capabilities for administrators, SQL developers, and end users.
Powering Up with ASE 15.7 Course
This 2 days course is designed for Database Administrators and SQL Developers.
During the course, you will gain familiarity with changes made in Adaptive Server Enterprise versions 15.5 and 15.7. You will learn a plethora of small functionality changes, code changes, MDA table changes, administration changes, changes to implementation of server security and new system procedures and utilities. During the course you will learn how to configure and use the transfer table functionality and take advantage of the new data compression capabilities in ASE version 15.7.