Home > Vendors > SAP > ha200

HA200 - SAP HANA Installation & Operations SPS12


Duration: 5 days
  • 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.




Preparing Installation

  • Sizing of SAP HANA
  • Requirements


  • 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 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


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



  • HA100


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


This course is part of the following Certifications:

C_HANATEC_16 - SAP Certified Technology Associate - SAP HANA 2.0 SPS04


Show Schedule for: