SAP HANA ADMINISTRATION TRAINING  IN CHANDIGARH

Module 1:

• SAP HANA Technology Overview
• SAP HANA Introduction
• Understanding the need of In Memory Technologies
• Understanding High performance Analytics
• In-Memory Computing
• SAP HANA row store vs Columnar store

Module 2:

• SAP HANA Editions
• Software Packaging
• SAP HANA Platform Edition
• SAP HANA Enterprise Edition

Module 3:

• SAP HANA Deployment Scenarios
• HANA as DataMart
• Non-Native HANA Applications
• Native HANA Applications

Module 4:

• SAP HANA Architecture
• Simplified Architecture of SAP HANA
• SAP HANA Memory Management and Data Persistence

Module 5:

• Preparing Installation
• Sizing of SAP HANA
• Sizing KPI's (Memory, CPU, HDD, Network)
• Quick sizer
• Sizing Requirements and assumptions
• Experiencing HANA Appliance Models

Module 6:

• Operating Systems
• Operating Systems Supported (SLES&RHEL)
• Linux Operating System Requirements
• File System Preparation

Module 7:

• Operating Systems
• Installation
• Introduction SAP HANA Lifecycle Management Tools
• Install a Single-Host SAP HANA System
• Advanced installation options

Module 8:

• Post Installation
• Post-Installation Steps
• SAP HANA Studio installation
• SAP HANA Client Installation

Module 9:

• Admin Tools for SAP HANA
• SAP HANA Studio and SAP HANA Cockpit
• Connect to the SAP HANA Database Using SAP HANA Studio
• DBA Cockpit
• HDBSQL Command Line Tool

Module 10:

• Database Administration Tasks
• Starting and Stopping SAP HANA
• Use Different Methods to Start and Stop the SAP HANA Database
• HANA database services and their significance
• Understanding Service Instances
• Understanding the Run level parameter
• Configuring the SAP HANA Database
• Change SAP HANA Configuration Parameters

Module 11:

• Backup and Recovery
• Concept of Backup and Recovery
• Need of Backup
• Data Area Backup
• Understanding Backup Destinations
• Understanding BACKINT
• Performing Data backup using HANA Studio, Sql Commands, DBA
• Cockpit, HANA Cockpit
• Scheduling backups using DBA Cockpit, HANA Cockpit, Backup script
• Log Area Backup
• Understanding the concept of Log area backup
• Handling LOGFULL situations
• Additional Backup Topics
• Taking backup of Configuration Files
• Performing Storage SNAPSHOT backup

Module 12:

• Recovery
• Performing Database recovery
• Recovery options
• Recovery using Storage SNAPSHOT
• Database Copy / Database refresh
• Recovery Using HANA Cockpit 2.0

Module 13:

• Security
• Security Overview
• Understanding levels of security
• Understanding security in different scenarios
• Authentication and Authorization
• Encryption
• Auditing and audit policy

Module 14:

• Maintaining Users and Authorization
• User Management
• Creating users using HANA Studio and Web IDE
• Types of Privileges
• Working with Analytic privileges
• Roles
• Creating runtime Roles
• Creating Repository Roles using Web IDE
• Administrative Tasks
• Information Sources for Administrators

Module 15:

• HANA Application Life Cycle Management
• Concept of HANA Development
• Understanding Catalog and Content objects
• Transporting using Export and Import
• Concept of Deliver Unit
• Setting up Transportation landscape
• Configuring Transport Routes
• Understanding the Import logs
• Concept of CTS in SAP HANA

Module 16:

• Multi tenant Database Containers
• Architecture and Technology
• Comparing Deployment options
• Installing MDC
• Creating and Configuring Tenant Databases
• Administration of Multi tenant Database Containers
• Backup and Recovery of Multi tenant Database Containers
• Convert a Single container to a multitenant System

Module 17:

• High Availability and Disaster Tolerance
• Need of Scalability
• SAP HANA Scale up and Scale Out
• Understanding Distributed database
• High availability concept
• Disaster Recovery
• Configuring system replication

Module 18:

• Database Operations
• SAP HANA Table Administration
• Periodic Tasks
• Housekeeping activities
• Delta Merge
• SQL Console

Module 19:

• Monitor and Administration of SAP HANA using SAP HANA Cockpit 2.0
• Installing SAP HANA Cockpit 2.0
• Working with Cockpit Manager
• Creating Resource Groups and adding Resources
• Monitoring activities using Cockpit 2.0
• Understanding new features of Cockpit 2.0