SAP HANA Technology Overview

1. SAP HANA Introduction
2. Understanding the need of In Memory Technologies
3. Understanding High performance Analytics
4. In-Memory Computing
5. Hardware-Innovations
6. Software –Innovations
7. HANA Columnar Store
8. SAP HANA row store vs Columnar store
9. Understanding Columnar Storage
10. Finding SAP HANA Information Sources

SAP HANA Versions

1. HANA 1.0 SPS03…..SPS12
2. HANA 2.0 SPS00…SPS04
3. Hana 2.0 sps 06
4. Hana 2.0 sps 07

SAP HANA Editions

1. Software Packaging
2. SAP HANA Platform Edition
3. Software components offered
4. SAP HANA Enterprise Edition
5. Software components offered

SAP HANA Deployment Scenarios

1. HANA as DataMart
2. Non-Native HANA Applications
3. Native HANA Applications
4. HANA Accelerator
5. HANA Big Data Solutions
6. HANA Edition Applications
7. Describing SAP HANA Roadmap and Scenarios

SAP HANA Architecture

1. Simplified Architecture of SAP HANA
2. SAP HANA Memory Management and Data Persistence

Preparing Installation

1. Sizing of SAP HANA
2. Sizing KPI's (Memory, CPU, HDD, Network)
3. Risks in Sizing
4. Quick sizer
5. Sizing Requirements and assumptions
6. Experiencing HANA Appliance Models
7. Cloud Options

Operating Systems

1. Operating Systems Supported (SLES&RHEL)
2. Linux Operating System Requirements
3. File System Preparation

Installation

1. Introduction SAP HANA Lifecycle Management Tools
2. Install a Single-Host SAP HANA System
3. Advanced installation options

Post Installation

1. Post-Installation Steps
2. SAP HANA Studio installation
3. SAP HANA Client Installation

Admin Tools for SAP HANA

1. Outlining Administration Tools
2. SAP HANA Studio and SAP HANA Cockpit
3. Connect to the SAP HANA Database Using SAP HANA Studio
4. DBA Cockpit
5. HDBSQL Command Line Tool

Database Administration Tasks

1. Starting and Stopping SAP HANA
2. Use Different Methods to Start and Stop the SAP HANA Database
3. HANA database services and their significance
4. Understanding Service Instances
5. Understanding the Run level parameter
6. Configuring the SAP HANA Database
7. Change SAP HANA Configuration Parameters

Backup and Recovery

1. Concept of Backup and Recovery
2. Need of Backup
3. Data Area Backup
4. Understanding Backup Destinations
5. Understanding BACKINT
6. Performing Data backup using HANA Studio, Sql Commands, DBA
7. Cockpit, HANA Cockpit
8. Scheduling backups using DBA Cockpit, HANA Cockpit, Backup script
9. Log Area Backup
10. Understanding the concept of Log area backup
11. Handling LOGFULL situations
12. Additional Backup Topics
13. Taking backup of Configuration Files
14. Performing Storage SNAPSHOT backup
15. Recovery
16. Performing Database recovery
17. Recovery options
18. Resuming Recovery
19. Recovery using Storage SNAPSHOT
20. Database Copy / Database refresh
21. Recovery Using HANA Cockpit 2.0

Security

1. Security Overview
2. Understanding levels of security
3. Understanding security in different scenarios
4. Authentication and Authorization
5. Encryption
6. Auditing and audit policy

Maintaining Users and Authorization

1. User Management
2. Creating users using HANA Studio and Web IDE
3. Types of Privileges
4. Working with Analytic privileges
5. Roles
6. Creating runtime Roles
7. Creating Repository Roles using Web IDE
8. Administrative Tasks
9. Information Sources for Administrators

HANA Application Life Cycle Management

1. Concept of HANA Development
2. Understanding Catalog and Content objects
3. Transporting using Export and Import
4. Concept of Deliver Unit
5. Transport using Native HANA Transport
6. Setting up Transportation landscape
7. Working with Change List (Create, Approve, Release, Import)
8. Configuring Transport Routes
9. Understanding the Import logs
10. Concept of CTS in SAP HANA

Multi tenant Database Containers

1. Architecture and Technology
2. Comparing Deployment options
3. Installing MDC
4. Creating and Configuring Tenant Databases
5. Administration of Multi tenant Database Containers
6. Backup and Recovery of Multi tenant Database Containers
7. Convert a Single container to a multi tenant System

Updating SAP HANA

1. Updating SAP HANA
2. Using HDBLCM in Media
3. Using Resident HDBLCM
4. Using Platform Life Cycle Management
5. Revision strategy of SAP HANA
6. Data Centre Service Points
7. Zero down time Maintenance

High Availability and Disaster Tolerance

1. Need of Scalability
2. SAP HANA Scale up and Scale Out
3. Post scale out activities
4. Understanding Distributed database
5. High availability concept
6. Disaster Recovery
7. Configuring system replication

Database Operations

1. SAP HANA Table Administration
2. Periodic Tasks
3. Housekeeping activities
4. Defragmentation and Delta Merge
5. SQL Console

SAP HANA Migrations

1. Concept of Migration
2. Sizing approach in Migration Projects
3. Migration paths
4. Migration procedure by using DMO
5. Information source for Migration

Monitoring and Trouble shooting

1. Memory Monitoring
2. Understanding the Processing
3. Analyzing Queries
4. Working with Plan Visualizer
5. Load Monitoring
6. Alert Configuration
7. Configuring Traces
8. Working with Diagnosis Information and Diagnosis Files
9. Trouble shooting unresponsive system

Monitor and Administration of SAP HANA using SAP HANA Cockpit 2.0

1. Installing SAP HANA Cockpit 2.0
2. Working with Cockpit Manager
3. Creating Resource Groups and adding Resources
4. Monitoring activities using Cockpit 2.0
5. Understanding new features of Cockpit 2.0

Additional Topics

Configuring Data Replications using SLT

1. Positioning and benefits of SLT for SAP HANA
2. Key benefits of Trigger-Based Approach
3. Architecture and building Blocks
4. Set-up of LT replication server
5. Configuration Steps for SLT replication server
6. Setup Data Replication
7. Landscape strategy of SLT replication server
8. SLT replication server Installation Options
9. Technical Requirements and system setup Information
10. Creating RFC Connections
11. Configuring and Monitoring Dashboard
12. Monitoring of Replication

Introduction to New Technologies

1. Introduction to SAP S/4 HANA
2. Introduction to SAP BW/4 HANA
3. Future Road Map