Advanced Administration and Troubleshooting for Adaptive Server

Sybase, Inc.
Atlanta, Chicago, Concord, Bethesda, Dallas, Irvine, New York, Washington etc., U.S.

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' Get a hands-on, in-depth look at Adaptive Server Enterprise (ASE). Examine relevant internal data structures and practical troubleshooting techniques. Learn to diagnose and prevent potentially disastrous situations, optimize your use of the features of ASE for normal administrative tasks, perform mission-critical administrative tasks for efficiently, improve system performance for end users and troubleshoot disaster scenarios for data recovery.
Course Objectives :
Upon completion of this course, you will be able to:
Create a new ASE server and perform post-installation security tasks
Describe ASE connectivity and implement balanced network and port utilization with fail-over safety
Describe the mechanics of database and table allocation/de-allocation
Use DBCC commands to detect and resolve table fragmentation, allocation, and linkage problems
Configure ASE to obtain maximum performance for index creation and for bulk copying of data
Perform effective backups, and troubleshoot dump, load and recovery problems
Rebuild a damaged database with up-to-the-minute data
Rebuilt the master device and database without a backup
Course Topics :
Dynamic reconfiguration, using advanced installation techniques, troubleshooting connectivity problems, extending ASE using component integration services, managing physical devices, analyzing object allocation, managing table fragmentation, using dbcc to check consistency and to detect and resolve table fragmentation, allocation, and linkage problems, improving performance of bulkcopy and create index, troubleshooting database dumps and loads, and recovering from non-master device failures, recovering from master device failures. Optional modules include accessing remote servers and remote objects.

Who Should Attend : Database Administrators, System Administrators

Prerequisites : System and Database Administration: Adaptive Server Enterprise 12.5 (EDB354)


...''

Phone:1-800-8-SYBASE (800-879-2273)

School Address:

14800 Quorum
Suite 505
Dallas, Texas 75240
United States

8755 West Higgins Road
Suite 1100
Chicago, IL 60631

The Grace Building
1114 Avenue of the Americas, 32nd Floor
New York, NY 10036

Rock Spring Plaza
6550 Rock Spring Drive, Suite 700
Bethesda, Maryland

561 Virginia Rd.
Concord, MA 01742
(978) 287-1500

3820 Mansell Road
Suite 100
Alpharetta , GA 30022

19900 MacArthur Boulevard
Suite 510
Irvine, CA 92612

Jobs & Resumes: Atlanta, Chicago, Concord, Bethesda, Dallas, Irvine, New York, Washington etc.
Houses & Roommates: Atlanta, Chicago, Concord, Bethesda, Dallas, Irvine, New York, Washington etc.

Using SybMigrate
Powering Up to ASE Interim Releases
Introduction to SQL Expert
Behind the Scenes with DBCC Commands
Backup Server Unleashed
Securing Adaptive Server Enterprise Communications
Mastering Transact-SQL Programming: Advanced Tips & Techniques
Fast Track to Adaptive Server Enterprise
System and Database Administration: Adaptive Server Enterprise 12.5
Performance and Tuning: Configuring Adaptive Server Enterprise
Troubleshooting Adaptive Server Data Structures
Performance and Tuning: Adaptive Server Enterprise Query Optimizer
Logical Database Design
Physical Database Design
XML Certification Boot Camp
Introduction to Cascading Style Sheets
Introduction to JavaScript
Introduction to Java 2 Programming
Intermediate Java 2 Programming

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: ASKEDU jobs and talents message board can help you find jobs related to your experience in a specific city, or hire somebody in place with particular knowledges.