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.
    • Succeed in certification C_TADM55_74, SAP Certified Technology Associate – System Administration (SAP HANA as a database) with SAP NetWeaver 7.4.

Audience

  • Technology Consultant
  • Database Administrator
  • System Administrator

Prerequisites

Essential

Recommended

  • HA100
  • Knowledge in database administration

Course based on software release

  • SAP HANA SPS12

Content

  • SAP HANA Introduction
    • SAP HANA – A Short Introduction
    • SAP HANA Information Sources
  • 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 Scenarios
    • 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