System and Database Administration: Adaptive Server Enterprise

Duration: 5 days

During this course students will gain: Manage physical data placement and storage, Create, backup and restore databases, Create and manage multiple temporary databases and Create user accounts and manage permissions

This course is aimed at Database and System Administrators with an understanding of sap Sybase ASE & EDB116

Please find the course objectives below:

SAP Adaptive Server Enterprise 

  • 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 
  • 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 
  • Ensuring Database Consistency 

Backup 

  • Planning for Backups 
  • Executing Database Backups 
  • Restoring Database Backups 
  • Performing Transaction Log Backups
For an onsite course please contact us