Sybase Version 15 New Features

Sybase Training Overview:

Students attending this class will learn about the newest features of Adaptive Server Enterprise version 15. Topics covered will include data partitioning, new optimization logic, and extended support for large databases.

Sybase Training Objectives:

Upon completion of this course, students will be able to:

Perform an Upgrade from a previous release of ASE
Become familiar with the new ASE 15.0 utilities
Identify the new functions available for SQL development
Partition data to improve overall performance
Learn the new techniques for performance monitoring and optimization
Acquire the knowledge to extend database support for web development
Develop and manage secure database environment systems

Sybase Training Prerequisites:

It is recommended that people attending this class have a working knowledge of Sybase version 12 and have worked with Sybase for a period of at least three months.

Sybase Training Audience:

The course is recommended for application developers, database administrators, systems programmers, database designers, system analysts, personnel interested in Sybase performance and tuning facilities and those who are interested in learning about the newest features of Sybase.

Course duration:

1 day

Sybase Training Course outline

Installation & Upgrade

What's New in ASE 15.0

Database Changes

Data Partitioning

Optimization Improvements

Query Processing technology

XML enhancements

Accessing unstructured data

Encryption based privacy system

Messaging services

Very large server support

Auto update statistics

Administration through the enterprise view

Administrator job wizards

Query plan viewer

Computed Columns and Function-based Indexes

Scrollable Cursors

Advance Monitoring, Diagnosis and Statistics