System and Database Administration: Adaptive Server Enterprise

Code: EDB358v10

5 days

List Tuition : $3,375.00 USD

Course Overview

    Download PDF 

In this course, you will learn how to build, run, and stabilize an ASE 15.7 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 Software release Adaptive Server Enterprise 15.7.

Certification:

C_SASEAA157 - SAP Certified Technology Associate - Database Administrator for SAP Sybase ASE 15.7

  • Database administrator
  • System administrator
  • Manage physical data placement and storage
  • Create, backup, and restore databases
  • Configure auto-expansion
  • Create and manage multiple temporary databases
  • Create user accounts and manage permissions
  • Run diagnostic and repair functions
  • Reconfigure Adaptive Server dynamically

1. SAP Adaptive Server Enterprise

  • 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 Deviceso
  • 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 Control Center
  • Monitoring SAP ASE
  • EDB116 or equivalent experience

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.