Key Features

Hands-on projects execution

Expert Assistant

24/7 Server access

Project explanations and placements

Instructor led Training

High Quality e-learning

Resume preparation guidance

SAP HANA Administration

What is this course about?

SAP HANA Admin training from Ripples Info is designed to ensure that you clear the SAP HANA exam in the first attempt. Our hands-on training approach, entrusted by 80,000+ learners, will help you to imbibe the workings SAP HANA.

Prerequisites: None

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…SPS01
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
  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
  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
SAP HANA Direct Extractor Configuration
  1. Introduction to SAP HANA Direct Extractor Connection (DXC)
  2. Limitations of DXC
  3. Architecture and building Blocks
  4. Set-up of LT replication server
  5. Enabling Services
  6. HTTP connection
  7. Test Connection
Introduction to New Technologies
  1. Introduction to SAP S/4 HANA
  2. Introduction to SAP BW/4 HANA
  3. Future Road Map