In this course, students learn how to manage physical data replacement and storage, create, backup and restore databases, and create and manage multiple temporary databases.

starstarstarstarstar_outline

* Actual course outline may vary depending on offering center. Contact your sales representative for more information.

Learning Objectives

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

1

  • SAP Adaptive Server Enterprise (ASE)

  • Explaining SAP ASE
    Describing the Database Architecture
    Using Query Editors
2

  • Installation

  • Installing Servers
    Identifying Installation Parameters
    Starting and Stopping SAP ASE
    Connecting Clients to the Server
3

  • Database Server Configuration

  • Explaining the Server Configuration File
    Modifying the Server Configuration File
    Explaining Memory Mechanisms
    Configuring Memory
    Configuring the Size of Caches
4

  • Space Management

  • Creating Devices
    Managing Devices
    Mirroring Devices
    Creating Databases
    Managing Databases
    Managing Disk Resources
    Managing Temporary Databases
5

  • Security

  • Managing Roles
    Creating Logins
    Managing Logins
    Managing Database Users
    Managing Creation Permissions
    Managing Object Permissions
    Creating Groups
    Creating Roles
6

  • Maintenance

  • Using SAP ASE Extraction Utilities
    Using the Bulk Copy Utility
    Explaining Automatic Recovery
    Ensuring Database Consistency
    Setting Up the High Speed Consistency Checker
7

  • Backup

  • Planning for Backups
    Executing Database Backups
    Restoring Database Backups
    Performing Transaction Log Backups
    Using Advanced Backup Techniques
8

  • Monitoring

  • Using SAP DB Control Center
    Monitoring SAP ASE

Audience

Database and system administrators will benefit from this course.

Language

English

Prerequisites

Students should take the EDB116: Fast Track to SAP Adaptive Server Enterprise course in order to prepare for this course.

$4,335

Length: 5.0 days (40 hours)

Level:

Not Your Location? Change

Course Schedule:

To request a custom delivery, please chat with an expert.

Loading...