SEMINARS

SAP HANA S2.0 SPS00

Course announcements

  • This course is built to be suitable for HANA 2.0 SPS00 audiences only. Hint: If you are interested in HANA 1.0 SPS12, please check for solution release SAP HANA SPS12 in the selection window. Please check the SAP HANA release for each planned event listed on the right, and ensure you choose a course date for the appropriate SAP HANA release before adding to the basket.
  • In this course the participants will install, update and operate a SAP HANA 2.0 SPS00 database using SAP HANA Cockpit. The course covers the most important database administration tasks of a SAP HANA system administrator. Furthermore, it provides details about starting and stopping, changing the configuration, troubleshooting, multitenant configuration and high-availability setup of a SAP HANA 2.0 SPS00 system.

Goals

  • This course will prepare you to:
    • Install and update a SAP HANA 2.0 SPS00 database.
    • Installation and configure the SAP HANA cockpit.
    • Perform the SAP HANA system administration tasks using SAP HANA cockpit.
    • Start and stop, change the configuration, backup and troubleshoot a SAP HANA 2.0 SPS00 database.
    • Backup and recover a SAP HANA 2.0 SPS00 database.

Audience

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

Prerequisites

Essential

  • HA100

Recommended

  • Some experience with the Linux operating system
  • Some experience in database administration

Course based on software release

  • SAP HANA 2.0 SPS00

Content

  • This course is the best starting point to learn about SAP HANA installation, update, configuration and system administration.
  • The course is independent from the SAP NetWeaver administration world, as it teaches how to perform system administration on the SAP HANA platform. The system administration tools used are native to the SAP HANA platform.
  • Throughout the course, you will learn about the following SAP HANA too for installation, update, configuration and system administration.
    • SAP HANA database lifecycle manager (HDBLCM)
    • SAP HANA cockpit 2.0
    • SAP HANA studio
    • SAP HANA HDBSQL command line
  • At the end, you will be able to perform all the required daily system administration tasks on the SAP HANA database platform. Contents:
    • SAP HANA introduction
    • Installation preparations
    • SAP HANA installation
    • SAP HANA architecture and deployment options
    • SAP HANA cockpit installation
    • Administration tools
    • Post installation steps
    • Database administration tasks
    • Backup and recovery
    • Security
    • User and authorizations
    • High availability and disaster tolerance
    • Multitenant database containers

Notes

  • In case you need to “deep-dive” on specific subjects, this course can be coherently combined with the other courses in the SAP HANA Curriculum, for example HA240 for Security and HA250 for database migration.

 

SAP HANA Installation & Operations SPS12

Course announcements

  • This course is built to be suitable for HANA 1.0 SPS12 audiences. Hint: If you are interested in HANA 2.0 SPS00, please check for solution release SAP HANA 2.0 SPS00 in the selection window. Please check the SAP HANA release for each planned event listed on the right, and ensure you choose a course date for the appropriate SAP HANA release before adding to the basket.
  • 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.

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

  • HA100

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