In this course the participants install and operate SAP HANA SPS12. The course covers the most important tasks for the daily work of an SAP HANA system administrator. Furthermore, it provides details about starting and stopping, changing the configuration, troubleshooting and assuring the high-availability of an SAP HANA SPS12 system.

* The price includes lunch, snacks and beverages.
* Prices are free of VAT.
* No parking is included in the price.
* Education is not included in the NLT membership fee.

Goals

This course will prepare you to:

• Install and update a SAP HANA database in version SPS12.
• Perform the daily tasks for a SAP HANA system administrator.
• Start and stop, change the configuration, backup and troubleshoot a SAP HANA SPS12 system.
• Backup and recover a SAP HANA SPS12 database.

Audience

• Database Administrator
• Help Desk/CoE Support
• System Administrator
• Technology Consultant

Course based on software release

• The course is conducted on the latest available version. Check the version at registration if you need precise information.

Content

Preparing Installation

• Sizing of SAP HANA
• Requirements

Installation

• Introduction SAP HANA Lifecycle Management Tools
• Advanced installation options
• SAP HANA Studio installation
• Performing a Distributed System Installation

Post Installation

• Post-Installation Steps
• Updating SAP HANA
• Revision strategy of SAP HANA

Architecture and Scenar

• SAP HANA Memory Management and Data Persistence
• Software Packaging
• SAP HANA Roadmap and Scenarios
• Deployment Options

Admin Tools for SAP HANA

• Administration Tool Overview
• SAP HANA Studio and SAP HANA Cockpit
• SHINE - SAP HANA Interactive Education
• DBA Cockpit
• HDBSQL Command Line Tool

Operations and Troubleshooting

• Starting and Stopping SAP HANA
• Configuring SAP HANA
• SAP HANA Table Administration
• Periodic Tasks
• Configuring Traces
• Working with Diagnosis Information and Diagnosis Files
• SQL Console
• Transporting Changes

Backup and Recovery

• Concept of Backup and Recovery
• Data Area Backup
• Log Area Backup
• Additional Backup Topics
• Recovery
• Backup and Recovery using Storage Snapshot
• Database Copy

Security

• Security Overview
• Authentication and Authorization
• Encryption
• Auditing

Maintaining Users and Authorization

• User Management
• Types of Privileges
• Roles
• Administrative Tasks
• Information Sources for Administrators
• SAP HANA Live Authorization Assistant

High Availability and Disaster Tolerance

• High Availability
• SAP HANA Scale Out
• Disaster Recovery

Multitenant Database Containers

• Architecture and Technology
• Administration of Multitenant Database Containers
• Backup and Recovery of Multitenant Database Containers

Essential

• HA100

Recommended

• Some experience in SAP system administration
• Some experience in database administration

Tilesh Maharaj
CISSP, CISA, CSSM, CEH, SSCP.
Cyber Security Evangelist. Ethical Hacker. ECC Council.
Platinum Consultant in SAP Technology,
Platinum SAP Trainer