Prerequisites
To apply for the SAP Adaptive Server Enterprise Training, you need to either:
There are no specific prerequisites to start learning SAP Adaptive Server Enterprise skills.
Course Curriculum
Topic – 1 Fundamentals of SAP Adaptive Server Enterprise (ASE)
- Overview and basics of SAP ASE
- Learning Adaptive Server Enterprise 16.0 & related Databases
- System Admin’s Key Responsibilities
Topic – 2 Server Behavior and Memory Configuration
- Set Configuration Values for SAP ASE
- Handling Various Configuration Files
- Viewing and Adjusting Configuration Parameters
- Memory Allocation & Components in SAP ASE
- Critical Uses of Memory for SAP Adaptive Server
Topic – 3 Recommended Disk Resource Strategies
- Allocating Resources for System and User Databases
- Adding and Modifying Data Files or Devices within DBs
- Space Usage Monitoring
Topic – 4 Managing Object Permissions & Groups and Roles
- Setting Object Permissions in ASE
- Build and Manage Groups within ASE
- Understanding User-Defined Roles
- Implementing Custom User Roles
Topic – 5 Performing Database Backups
- Registering Backup Servers with Adaptive Server
- Backing Up and Restoring Databases on SAP ASE 16.0
- Handling Transaction Log Backups
- Practical Backup Exercises
Topic – 6 Overview of Sybase ASE Replication
- Data Replication Benefits for SAP ASE
- Techniques of Data Replication & Failover
- Learning the Replication of Server Threads & System Domains
Topic – 7 Servers Installation
- SAP ASE Software Downloading
- Install SAP Adaptive Server on Linux
- Exploring Directory Structure of ASE on Linux
- Explore how to Start & Stop ASE Servers
Topic – 8 Connectivity Establishment
- Interfaces File Configuration & Windows sql.ini File
- Maintaining Interfaces Files on Linux & Windows OS
- Overview of LDAP Directory Services
- Hands-On Practice with Databases
Topic – 9 Creation and Usage of Databases
- Sizing and Creating Databases
- Setting Ownership and Database Options within SAP ASE
- Databases Expansion
Topic – 10 Concepts of Auto Expansion
- Understanding Auto Database Expansion
- Implementing Auto Expansion on Sybase ASE
- Managing Auto Expansion with sp_dbextend
Topic – 11 Introduction to Automatic Recovery
- Understanding Automatic Recovery Processes
- Recovering Data After a Shutdown
- The Role of Checkpoints