Live Panel Discussion - Leveraging Red Hat OpenShift for a Multi-Cloud Strategy

closeClose

System and Database Administration: Adaptive Server Enterprise

Course Details
Code: EDB358-v015
Tuition (USD): $3,750.00 • Virtual (5 days)
$3,750.00 • Classroom (5 days)
Course Details
GSA (USD): $3,037.78 • Virtual (5 days)
$3,037.78 • Classroom (5 days)

Skills Gained

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

Who Can Benefit

  • Database Administrator
  • System Administrator

Prerequisites

  • Essential:
       -EDB116
  • Recommended:
       -None

Course Details

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

Notes

  • The course material is available in English only

Course based on software release

  • SAP ASE 16.0