Overview
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.
Requirements
- An understanding of database concepts
- Experience with the Linux command line
Audience
- Database Administrators (DBA)
Course Outline
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