SAP ASE for Database Administrators ( sapase | 28 hours )

• An understanding of database concepts
• Experience with the Linux command line

Audience

• Database Administrators (DBA)

SAP ASE (SAP Adaptive Server Enterprise), previously known as Sybase SQL Server, Sybase DB and Sybase ASE is a relational database for businesses.

In this instructor-led, live training, participants will learn the fundamentals of SAP ASE (SAP Adaptive Server Enterprise) Database Administration as they step through the creation and deployment of a sample SAP ASE Database System.

By the end of this training, participants will be able to:

• Install and configure SAP ASE for data storage as well as transactional operations.
• Understand and use SAP ASE components, tools, and utilities.
• Integrate SAP ASE with non-SAP ASE applications.

Format of the Course

• Interactive lecture and discussion.
• Lots of exercises and practice.
• Hands-on implementation in a live-lab environment.

Course Customization Options

• To request a customized training for this course, please contact us to arrange.

Introduction

• Understanding the differences among SAP ASE, SAP Sybase ASE and Sybase SQL Server
• Host vs Client/Server Systems

Overview of SAP ASE Architecture

SAP ASE SQL Fundamentals

Useful Linux/Unix Commands, Techniques and Tools

Installing and Configuring SAP ASE

Connecting SAP ASE with other Servers and Services

Creating an SAP ASE Database

Working with SAP ASE OS Files

Querying Data in SAP ASE

Transaction Management in SAP ASE

Integrating SAP ASE with non-SAP ASE applications

Configuring SAP ASE Memory for Optimal Performance

Administering System Roles and Logins

SAP ASE Security Management

SAP ASE Backup and Recovery

SAP ASE Space Management

Data Replication with SAP ASE

Managing Database Consistency

Object Resource Management

SAP ASE System Management Tools and Servers

Troubleshooting SAP ASE

Summary and Conclusion