Course announcements

  • Learn how to build, run and stabliize an ASE 16.0 database environment. Identify the major tasks of system & database administration with emphasis given to resourse management, system security, monitoring and troubleshooting.

Goals

  • Manage physical data replacement and storage
  • Create, backup and restore databases
  • Create and manage multiple temporary databases

Audience

  • Database Administrator
  • System Administrator

Prerequisites

Essential

Recommended

  • None

Course based on software release

  • SAP ASE 16.0

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