Description
This course provides an opportunity to learn and practice the major tasks of Adaptive Server and database administration. It explains how to install, monitor and maintain Sybase Adaptive Server. It covers resource management, monitoring, troubleshooting, and maintaining a secure and reliable Adaptive Server environment.

Audience
SQL Server administrators and database administrators.

Prerequisites
Attendance at Arkoa’s Developing with Sybase Transact SQL Server or a similar course, or practical experience with Sybase.

Hardware and Software
Sybase SQL Transact Server installed on Unix or Windows NT. The Sybsyntax database should be installed for online help with SQL. It should be possible to load a 3.5” DOS-formatted diskette for use in course exercises.

Format

• Presentation
  
• Hands-on
  

Objectives
After completing this course, participants should be able to:

• Allocate resources
• Create databases and database segments
• Control access by applying security features
• Maintain server, database, and tables
• Backup and restore databases and logs
• Troubleshoot problems
  
  

Introduction

Server Definition

• Installation steps
• Starting, running, and shutting down the server

Resource Definition

• Disk initialization and disk mirroring

Databases

• Creating databases and segments

Security

• Special users
• sysusers and syslogins
• Security, permissions, and ownership
• Role definitions and functions

Database Logging and Recovery

• Transaction log
• Recovery options

Backup and Restore

Periodic Maintenance

• Server, database, and table maintenance

Utilities

• Script maintenance

Configuration and Tuning

• Memory utilization
• Configuration variables and options

Remote Server Management

• Remote access and logins

Basic Application Performance Tuning

• Sybase Optimizer

Troubleshooting

• Common problems and solutions

Development Standards

• Audit Server