Full program description

NICF - SAP HANA Installation & Operations

What's In It For Me

  • Be trained in using SAP HANA.
  • Prepare yourself to be an SAP HANA system administrator.
  • Learn to maintain, configure and troubleshoot SAP HANA SPS12 system.

Course Overview

NTUC LearningHub Course Code: NICF135

Skillsconnect Code: CRS-Q-0030256-IT

SAP Course Code: HA200

Software Release: SPS12

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.

Who Should Attend

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

Course Duration

5 Days / 35.5 Hours

Course Outline

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

Mode of Assessment

Students must complete a paper-based NICF assessment during class.

Certification Obtained and Conferred by

Awarded NICF Statement of Attainments (SOAs)

Upon completion of the course, students will also be awarded with SOAs from SSG.

Course Objectives

After completing this course, students will be able 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.

Pre-requisites

Essential Prerequisites

Completed NICF SAP HANA Introduction (HA100)

Recommended Prerequisites

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

Funding Information

  • SSG Funding

This course is aligned to the National Infocomm Competency Framework (NICF) and accredited by SSG with Cat-B Funding (PME Level).

  • Eligible Singapore Citizens can use their SkillsFuture credit to offset the course fee.

Price

Course Fee with SSG Cat-B funding

Individual Sponsored Company Sponsored
w/o GST w GST Non-SME SME
w/o GST w GST w/o GST w GST
Original Course Fee $4,500.00 $4,815.00 $4,500.00
$4,815.00
$4,500.00
$4,815.00
Singapore Citizens & PRs aged 21 years and above $3,967.50 $4,282.50 $3,967.50
$4,282.50
$2,725.00
$3,040.00
Singapore Citizens aged 40 years and above $2,725.00 $3,040.00 $2,725.00
$3,040.00
$2,725.00
$3,040.00
Singapore Citizens aged 35 years and above who are not earning more than $2,000 per month (WTS Scheme) $225.00 $540.00 $225.00
$540.00
$225.00
$540.00

Remarks:

  • Individual Sponsored
    • Eligible Singapore Citizens can use their SkillsFuture Credit to offset course fee payable after funding.
    • Eligible Singapore Citizens can use their PSEA funds to offset course fee payable after funding.
  • Company Sponsored
    • Absentee Payroll claimable by SMEs: Up to 80%of hourly basic salary capped at $7.50/hr
    • Absentee Payroll claimable by Non-SMEs: Up to 80% of hourly basic salary capped at $4.50/hr
    • Absentee payroll claimable by companies (SMEs and Non-SMEs) sponsoring candidates under WTS Scheme: Up to 95% of hourly basic salary (no dollar cap)

Terms and conditions apply. NTUC LearningHub reserve the right to make changes or improvements to any of the products described in this document without prior notice.

Prices are subject to other LHUB miscellaneous fees

NICF135