SAP HANA Administration

SAP HANA is a game-changing, real-time platform for analytics and applications. While simplifying the IT stack, HANA provides powerful features like: significant processing speed, the ability to handle big data, predictive capabilities and text mining capabilities. SAP HANA in-memory database can help applications zero-in on the information they need – without wasting time sifting through irrelevant data. As a result it delivers instant answers to complex queries – and better decision making across the enterprise.

By the end of this training you will:
- Acquire the relevant knowledge required to clear the SAP certification exam.
- Understand the core concepts of SAP’s HANA ADMIN module.
- Be able to apply the knowledge learned to progress in your career as an associate level SAP HANA ADMIN Technical consultant.

Essential:
A good Bachelors degree in any field is required.
Recommended/Additional:
Awareness to database technologies and basic software knowledge is advantageous but not a must.

Classroom Training: An Instructor led training in our dynamic learning environment based in our office at West London. The classroom is fitted with all the essential amenities needed to ensure a comfortable training experience and with this training you will have an opportunity to build a Networking with other learners, share experiences and develop social interaction.

Online: Unlike most organisations our online based training is a tutor led training system similar to the classroom based training in every given aspect making it more convenient to the students from any location around the world and also cost effective.

Onsite: This training is specifically made for the Corporate clients who wish to train their staff in different technologies. The clients are given an opportunity where they can tailor the duration of course according to their requirements and the training can be delivered in house/ at your location of choice or online.

Customised one to one: A tailored course for students looking for undeterred attention from the tutor at all the times. The duration of course and contents of the course are specifically customised to suite the students requirements. In addition to it the timings of the trainings can also be customised based on the availability of both the tutor as well as the student.

Functional or Technical Certification - £350 (excluding VAT)

Contractors can expect to earn between £300 and £500 per day depending on the experience. Permanent roles on average offer a salary of between £30 and £60k per annum, again depending on the experience required for the job. Permanent Lead roles requiring substantial experience can offer around the £100k per annum mark.

Although there is no guarantee of a job on course completion we are almost certain that you should be able to find a suitable position within a few weeks after successful completion of the course. As a part of Placement service, we offer CV reviewing in which your CV would be reviewed by our experts and essential modifications to be made would be recommended so that your CV suits perfectly to the kind of training you have taken.

Course Preview

- In-Memory Computing
- Hardware-Innovations
- Software –Innovations
- SAP HANA simplified Architecture
- SAP HANA Extended Architecture
- Business Intelligence Clients with HANA
- HANA Columnar Store
- SAP HANA row store VS Columnar store
- Understanding Columnar Storage

- SAP HANA Enterprise Edition
- SAP HANA Enterprise Extended Edition (As of SPS03)
- SAP HANA Platform Edition

- SAP HANA In-Memory Database Sizing elements
- RAM, Disk, CPU
- Memory Sizing
- Disk Sizing
- CPU sizing

- HANA 1.0 SPS03
- HANA 1.0 SPS04—New Features
- HANA 1.0 SPS05—New Features
- HANA 1.0 SPS06—New Features

- Certified Hardware
- SLES 11 Sp1
- Preparing file system & directories
- Prepare Installation parameters
- Users created during Installation
- Required Installation media
- Prepare Installer configuration file

- SAP HANA unified Installer Tool
- Running Unified Installer to install the SAP HANA SERVER
- Components installed by Installer

- Available Clients on Linux
- Available Clients on windows
- Install SAP HANA Client on LINUX Host
- Install SAP HANA Client on Windows Host

- System Requirements
- Supported Platforms
- Install SAP HANA Studio on LINUX Host
- Install SAP HANA Studio on Windows Host

- Starting and Stopping SAP HANA System
- Displaying Process List
- Logging on to HANA system using HANA studio
- User Security
- Configuring SUM for HANA
- Automatic Start of HANA
- Applying Support packages and Updates
- Monitoring HANA Landscape

- Concept of HANA high- availability
- Disaster Tolerance
- Redundant Hardware
- Distributed System
- Standby Host
- Installation Planning for Distributed System
- Install HANA distributed system
- Monitoring and Configuring Standby Hosts

Positioning and benefits of SLT for SAP HANA
Key benefits of Trigger-Based Approach
Architecture and building Blocks
Architecture for SAP Source Replication
Architecture for Non-SAP source Replication
Set-up of SAP LT replication server
Installation Aspects
Configuration Steps for SLT replication server
Setup Data Replication
Database-Supportability
Landscape strategy of SLT replication server
SLT replication server Installation Options
Technical Requirements and system setup Information
DMIS2010 and relevant Support packs
SAP Kernel and DBSL Installation
Creating RFC Connections
Creating DB Connections
Configuring and Monitoring Dashboard
Creating New Configuration for SAP source
- Creating New Configuration for NON-SAP source
- Monitoring of Replication
- Mass Transfer IDS
- IUUC Synchronisation Cockpit
- Data Transfer Monitor
- Backup and Recovery Strategy
- Data Volume Management

- Introduction to SAP HANA Direct Extractor Connection (DXC)
- Limitations of DXC
- Setup and Configurations
- Enabling Services
- HTTP connection
- Test Connection

- SAP BODS 4.0 and SAP HANA
- SAP BODS 4.0 Architecture
- Configuring BO Data services
- Installing HANA ODBC Driver
- Creating SAP HANA Datastore in Data Services
- Creating SAP ERP Data store in Data Services
- Configuring HANA Studio for Importing Metadata
- Import Metadata
- Mass Import
- Selective Import
- Load Data via Data services into SAP HANA

- Starting & Stopping SAP HANA
- Starting SAP HANA Database
- Stopping SAP HANA Database
- Displaying Process List
- Monitoring HANA landscape

- System Configuration Parameters
- Monitoring and system state Parameters

- Need of Backup
- Backup Types
- Data Backup
- Log Backup
- Recovery Options
- Recovery in Replication Scenarios
- Backup to External Backup Destinations
- Recovery scenarios
- Power Failure
- Disk Failure
- High Availability for SAP HANA

- Create Users
- User and Role Concept
- Creating Roles
- Assigning Privileges to Roles
- Privileges
- SQL privileges
- System Privileges
- Analytic Privileges
- Reporting and Privileges
- Modelling required privileges

- Configuring Remote Support
- Solution Manage Integration
- Remote Service Connection
- EWA for HANA
- Availability Monitoring
- Setting up Monitoring
- System Monitoring Setup
- Status Overview
- Services Overview
- System Load History
- Disk usage Details
- Checking System Configuration Alerts

- Regular administration tasks
- Troubleshooting
- Analysing performance

- Transporting Changes
- CTS/CTS+
- SAP HANA with CTS+
- Exporting and Importing
- Developer Mode
- Delivery Unit
- SAP support Mode
- Exporting Tables
- Updating SAP HANA
- SAP HANA Update and Patching
- SP stack Update

- SAP HANA Native Applications
- Non-Native SAP HANA Applications

- Access to HANA systems in cloud
- SAP HANA Developer Edition Environment