System and Database Administration: Adaptive Server Enterprise

Code: EDB358v15

5 days

List Tuition : $3,000.00 USD

Course Overview

    Download PDF 

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

  • Database administrator
  • System administrator
  • Manage physical data replacement and storage
  • Create, back up, 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

EDB116

Request a Discounted Quote




Bring Training to You

Request schedule for this course

Request a Quote for this Class

We provide government and government contractor discounts, please request a quote

Schedule



total option: 0

Hotel and Travel can be included on your quote.
For immediate response, you can call 1-855-515-2170 or we will provide a quote within 4 business hours. Travel must be booked 14 days before training for rate to apply.

Learn How to Become a Managed Learning Member

Request a Quote

Thank you for requesting a quote, we will be in touch shortly with a quote. If you need immediate assistance, please call 855-515-2170.

Request Other Date

Request date or location you need

Don’t see the date or location you need? Contact us and let us know, we are adding dates and locations daily.