SAP System and Database Administration: Adaptive Server Enterprise

Course Content

• SAP Adaptive Server Enterprise (ASE)
     -Explaining SAP ASE
     -Describing the Database Architecture
     -Using Query Editors
• Installation
     -Installing Servers
     -Identifying Installation Parameters
     -Starting and Stopping SAP ASE
     -Connecting Clients to the Server
• Database Server Configuration
     -Explaining the Server Configuration File
     -Modifying the Server Configuration File
     -Explaining Memory Mechanisms
     -Configuring Memory
     -Configuring the Size of Caches
• Space Management
     -Creating Devices
     -Managing Devices
     -Mirroring Devices
     -Creating Databases
     -Managing Databases
     -Managing Disk Resources
     -Managing Temporary Databases
• Security
     -Managing Roles
     -Creating Logins
     -Managing Logins
     -Managing Database Users
     -Managing Creation Permissions
     -Managing Object Permissions
     -Creating Groups
     -Creating Roles
• Maintenance
     -Using SAP ASE Extraction Utilities
     -Using the Bulk Copy Utility
     -Explaining Automatic Recovery
     -Ensuring Database Consistency
     -Setting Up the High Speed Consistency Checker
• Backup
     -Planning for Backups
     -Executing Database Backups
     -Restoring Database Backups
     -Performing Transaction Log Backups
     -Using Advanced Backup Techniques
• Monitoring
     -Using SAP DB Control Center
     -Monitoring SAP ASE