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

Prerequisites

Essential

Recommended

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

Course based on software release

  • SAP HANA SPS12

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