Module 1:Introducing Adaptive Server
Adaptive Server Enterprise 15.0
Adaptive Server Databases
System Administrator Responsibilities
Module 2:Installing Servers
Loading the ASE Software
Installing Adaptive Server
ASE Directory Structure
Starting and Stopping Servers
Module 3:Establishing Connectivity
The interfaces File
The UNIX interfaces File
The Windows sql.ini File
Maintaining the interfaces File
Introduction to LDAP Directory Services
Module 4:Configuring Server Behavior
The Configuration File
Viewing Configuration Values
Modifying Configuration Values
Multiple Configuration Files
Module 5:Configuring Memory
Components of Memory
Allocation of Memory
Major Uses of Memory
Estimating Initial Configuration Values
Module 6:Initializing and Using Devices
Creating and Dropping Devices
Default Devices
Mirroring Devices
Module 7: Creating and Using Databases
Sizing and Creating Databases
Setting Ownership and Options
Expanding Databases
Module 8:Suggested Disk Resource Strategies
Resource Allocation for System Databases
Resource Allocation for User Databases
Monitoring Space Usage
Module 9: Auto Expansion
Overview of Auto Database Expansion
Installing Auto Expansion
Managing Auto Expansion using sp_dbextend
Module 10: Managing tempdb
Review of System tempdb
Installing Multiple tempdbs
Binding to a tempdb
Managing tempdbs - Precedence
Troubleshooting and Recommendations
Module 11: Administering System Roles and Logins
Overview of Access
System Roles
Logins
Proxy Authorization
Module 12: Managing Database Access and Users
Database Owners
Database Users
Object Creation Permissions
Module 13: Implementing Object Permissions,
Groups, and Roles
Object Permissions
Groups
Overview of User-defined Roles
Implementing User-defined Roles
Module 14: Using Bulk Copy Utility
Copying Definitions
Bulk Copy Overview
Bulk Copy Syntax
Module 15: Overview of Automatic Recovery
Overview of Automatic Recovery
Recording Modifications
Recovering Modifications After a Shutdown
Checkpoints
Recovery Order
Module 16: Checking and Fixing Database
Consistency
Overview of the dbcc Commands
Checking Page Linkage
Checking Page Allocation
Setting Up the dbccdb Database
Using dbcc checkstorage
Module 17: Planning for Backups
Backup Basics
Backup Server
Truncating the Transaction Log
Developing a Backup Plan
Module 18: Performing a Backup
Making Backup Servers Known to Adaptive Server
Dumping Databases
Loading Databases
Dumping Transaction Logs
Loading Transaction Logs
Module 19: Practicing Advanced Backup Techniques
Thresholds
Transaction Log Recovery
Database Recovery
Rebuilding the master Database
Module 20: Sybase Central
Sybase Central Defined
Using Sybase Central
Administration Tasks
Job Scheduler
Interactive SQL
Module 21: Monitoring the System
Monitoring
Errors
Monitoring
Processes
Monitoring
Licenses
Monitoring
System Performance

Contact Us:

Ahana Systems & Solutions (P) Ltd.

105/22, Ist floor, 50 Feet Road
Hanumanth Nagar, Near Nirmala Store Bus Stop
Banashankari, Bangalore – 560050

Call Us

+91 80 26675891 (INDIA)
+91 80 65462066 (INDIA)

+44 20 7993 8018 (UK)
+1 408 416 3150 (US)
 9686113314 (M)

E-Mail Us
Email: contact@ahana.co.in
Web : http://www.ahana.co.in