Live Chat
Monday - Friday 8am - 6pm EST Chat Now
Contact Us
Monday - Friday 8am - 8pm EST 1-866-716-6688 Other Contact Options
Checkout

Cart () Loading...

    • Quantity:
    • Delivery:
    • Dates:
    • Location:

    $

System and Database Administration: Adaptive Server Enterprise (EDB358v15_ASE 16)

GK# 3133 Vendor# EDB358v15

Course Overview

TOP

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

This course is based on the following software release:

  • SAP ASE 16.0

What You'll Learn

TOP
  • Manage physical data replacement and storage
  • Create, back up, and restore databases
  • Create and manage multiple temporary databases

Outline

TOP
Viewing outline for:

Classroom Live Outline

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

Who Should Attend

TOP
  • Database administrator
  • System administrator
Course Delivery

This course is available in the following formats:

Classroom Live

Receive face-to-face instruction at one of our training center locations.

Duration: 5 day

Virtual Classroom Live

Experience expert-led online training from the convenience of your home, office or anywhere with an internet connection.

Duration: 5 day

Request this course in a different delivery format.
Enroll