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

Notes

  • The course material is available in English only

CPE Credits

040 Credits

Please note CPE credits are available only for publicly scheduled courses delivered at SAP locations. CPE credits are not available for virtual classroom deliveries or customer specific deliveries.

Submit your request

Is the course not scheduled? Or looking for other dates and locations that fit your schedule? Let us know what works for you by clicking the button below and select your preferred location. We will do our best to consider your request.

Note: Location can be for a Virtual Classroom, Public Classroom or Any location (Any Physical location except Virtual Classroom.)

Register Interest