|
|
|
|
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
|
|
|
|
|