|
Provided by: Ahana Systems and Solutions (P) Ltd Sybase TrainingIT Certification Prep |
 |
Training
Provided by Ahana Systems and Solutions (P) Ltd
Our Sybase database training develops and delivers excellent learning solutions to support your personal and organizational learning goals. We developed our courses to provide real solutions for the challenges you face every day, these task-based courses get to the heart of Sybase technology and provide you with the technical know-how that you can apply to achieve effective results, the ability to address specific real-world issues that pertain to your company's unique environment.
When it comes to delivering Sybase database administration and technology training, there is no one better equipped than real-world production Sybase DBA's. Our access to production DBA, technical support and database architects ensures that our programs incorporate the most recent tips, tools and best practices to bring you up to speed and help you get the most out of your Sybase training.
|
|
||||||||||
Sybase Training
Introduction to SQL
Fast Track to Adaptive Server Enterprise
System and Database Administration: Adaptive Server Enterprise
Performance and Tuning: Configuring Adaptive Server Enterprise
Powering Up with ASE 15. 0
Upon completion of this course, you will be able to:
Gain familiarity with the ASE by navigating through key features of the ASE environment
Manage physical data placement and storage
Create, backup and restore databases
Configure auto-expansion
Create and Manage multiple temporary databases
Create user accounts and manage permissions
Use Sybase Central to maintain an Enterprise environment
Run diagnostic and repair functions
Reconfigure Adaptive Server dynamically
Discuss tradeoffs involved in performance tuning
Use sp_sysmon and other utilities to tune the server for performance gains
Properly configure memory for optimal performance
Manage multiple engines
Configure, tune, and size data, procedure, and partitioned caches
Identify and correct problems in database physical design, including table partitions
Use statistics to manage space on DOL tables and indexes
Choose the appropriate table locking scheme for a given application
Reconfigure Adaptive Server dynamically
Improve performance of tempdb by sizing, placement, and solving locking
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
Installation & Upgrade
What's New in ASE 15. 0
Database Changes
Data Partitioning
Optimization Improvements
Computed Columns and Function-based Indexes
Scrollable Cursors
Advance Monitoring, Diagnosis and Statistics
Fast Track to Adaptive Server Enterprise
System and Database Administration: Adaptive Server Enterprise
Performance and Tuning: Configuring Adaptive Server Enterprise
Powering Up with ASE 15. 0
Upon completion of this course, you will be able to:
Gain familiarity with the ASE by navigating through key features of the ASE environment
Manage physical data placement and storage
Create, backup and restore databases
Configure auto-expansion
Create and Manage multiple temporary databases
Create user accounts and manage permissions
Use Sybase Central to maintain an Enterprise environment
Run diagnostic and repair functions
Reconfigure Adaptive Server dynamically
Discuss tradeoffs involved in performance tuning
Use sp_sysmon and other utilities to tune the server for performance gains
Properly configure memory for optimal performance
Manage multiple engines
Configure, tune, and size data, procedure, and partitioned caches
Identify and correct problems in database physical design, including table partitions
Use statistics to manage space on DOL tables and indexes
Choose the appropriate table locking scheme for a given application
Reconfigure Adaptive Server dynamically
Improve performance of tempdb by sizing, placement, and solving locking
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
Installation & Upgrade
What's New in ASE 15. 0
Database Changes
Data Partitioning
Optimization Improvements
Computed Columns and Function-based Indexes
Scrollable Cursors
Advance Monitoring, Diagnosis and Statistics
About The Training Provider: Ahana Systems and Solutions (P) Ltd
Ahana Systems and Solutions (P) Ltd - Oracle9i DBA
Oracle 10g DBA
Oracle 10g RAC
Sybase DBA
ASE DBA
Sybase Replication DBA
Oracle DBA
MSSQL DBA
MySQL DBA
Perl scripting
Shell scripting
Clearcase Administration
Linux Administration
VMWare
Windows Administration
Our In-house training is aimed at individuals who want to build their career in IT infrastructure field. Its mainly aimed at studends who are in the verge of...
