• phone icon +44 7836 212635 email message icon info@uplatz.com
  • Register
Job Meter = High


40 Hours
Online Instructor-led Training
USD 560 (USD 1120)
Save 50% Offer ends on 22-Jul-2020
SAP HANA Course online course and certification
248 Learners

About this Course

SAP HANA or High Performance Analytic Appliance is an In-Memory computing combines with a revolutionary platform to perform real time analytics and deploying and developing real time applications. It is also combined with pre tuned server, networking hardware and storage.

HANA includes In-Memory Database to store the data and analyze larger volumes of transactional data in real time, an embedded web server and a control repository for application development. Some of the real time cases and uses of SAP HANA include

  • Telecom Networks Monitoring and Optimization
  • Fraud Detection and Security
  • Forecast and Profitability Reports
  • Retail and Supply Chain Optimization
  • Energy Usage Monitoring and Optimization

Pre-Requisites to Learn SAP HANA:

·         A basic knowledge and understanding of database & SQL

·         Fair perceptive on IT environment


Course Details & Curriculum

SAP HANA Introduction and Architecture


·        SAP HANA Overview

·        SAP In-Memory Computing Overview

·        SAP HANA Features

·        Look and Feel of SAP HANA

·        SAP HANA Architecture

·        SAP HANA Landscape

·        Structure of SAP in-memory computing studio

·        Row Store and Column Store Architecture

·        Multi Version Concurrency Control (MVCC)

·        Persistence Layer in In-memory Computing Engine

·        Back-up & Recovery

·        High-Availability

·        Distributed System

·        Data Provisioning Options in SAP HANA

·        Reporting Options on SAP HANA

·        Security Options in HANA

·        SAP HANA Appliance Model

·        How SAP HANA Appliance is delivered

·        Sizing Considerations

·        SAP HANA – Licensing Options

·        SAP HANA Project Implementation

·        Overview: Key Activities

·        Key Roles

·        Key points to keep in mind

·        Administration

·        Modeling


Basic Modeling


·        Modeling Overview

·        Terminology

·        SAP HANA Studio Features

·        Information Modeler: Overview

·        Installation and Configuration of HANA Studio

·        Prerequisites for Modeling

·        Modeling Considerations

·        Levels of Modeling

·        Attribute Views

·        Analytic Views

·        Calculation Views

·        Modeling Considerations

·        Joins: Different types and when to use what.

·        Where Clause Vs Constraint Filters

·        HANA Studio Preview (use with caution)

·        Impact of Query Execution

·        Demo

·        Modeling Suggestions

·        Troubleshooting Modeling Issues

·        Export and Import Models


Analytics Option on HANA


·        HANA, Reporting Layer & Connectivity Options

·        Reporting on HANA Clients.

·        Reporting on HANA Open Interfaces

·        Prerequisites for reporting on SAP HANA

·        IMDB client installation

·        Setting up new connection

·        SAP Business Objects BI 4.0 - Overview & tool comparison

·        Analytical Reporting on HANA

·        Relational Reporting on HANA

·        Reporting on HANA: (Demo Included)

·        Native Excel Interface via ODBO

·        SAP Business Object Analysis (Office Edition)

·        SAP Business Object Explorer

·        Semantic Layer Approach

·        IDT Vs Universe Designer

·        SAP BOBJ WebI

·        SAP BOBJ Xcelsius

·        SAP Crystal Reports

·        Enterprise Vs 2011

·        Front end tool reporting considerations on top of HANA

·        Troubleshooting common reporting issues


Advanced Data Modeling with SQL Script


·        Modeling Overview

·        Calculation View: Overview & Types

·        SQL Script: Motivation

·        SQL Script: Overview

·        SQL Script Processing

·        Data Type Extensions

·        Scalar Data type

·        Table type

·        Functional Extension

·        Concept

·        Procedure

·        Procedure Calls

·        Implementing Functional logic

·        Operators

·        SQL Script/Built in Function

·        Debugging and troubleshooting SQL Script

·        Restrictions for SQL Statements


Data Provisioning: Data Services and Sybase Replication


·        Data Provisioning: Overview

·        Data Provision Options

·        Trigger Based Replication

·        ETL-Based Replication

·        Log-Based Replication

·        SAP Business Objects Data Services 4.0 and HANA

·        ODP enabled Extractor Support in Data Services 4.0

·        HANA and Data Service Process flow for SAP and non-SAP data

·        How it works for SAP System

·        How it works for Non-SAP System

·        Advanced Data Service Options

·        column tables creation

·        Bulk Loader Options & Config

·        Bulk extracting Options & Config

·        Log Based Replication Overview

·        Technical System Landscape

·        User Administration

·        Authorization

·        Installing Log Based Replication

·        Updating the SAP Host Agent on Source System

·        Installing Sybase Components

·        Deploying the SAP HANA Load Controller and Related Components

·        Configuring Log Based Replication

·        Configuring Sybase Components

·        Sybase Replication Server

·        Enterprise Connect Data Access (ECDA)

·        Sybase Replication Agent

·        Test Sybase Components

·        Configure SAP HANA Load Controller on SAP HANA System

·        Initializing Replication using SAP HANA Load Controller




·        Data Provisioning Overview

·        SAP Landscape Transformation Set-up

·        Options for SLT Landscape Installation

·        Post Installation Step

·        Concept of SLT Replication

·        Architecture and Key Building Block

·        Technical Requirement and System Set-up Information for LT Replication Server

·        Key Benefits of LT Replicating Server

·        Transformational Capabilities

·        Operations


Security and User Management in HANA


·Creation of Users

·Creation of Roles

·Assignment Privileges to Roles

·Assignment of Users to roles

Interested to learn? Get in touch with us

               Phone: +44 7836 212635

               WhatsApp: + 44 7836 212635

               Email: info@uplatz.com

               Website: training.uplatz.com

Browse https://training.uplatz.com to see more courses.


Uplatz.com is a Learning Marketplace for SAP Training and IT & Certification courses

Will this course help me clear the certification exam? +
Which is better - Self-paced training or Instructor-led training? +
Who are the trainers? +
What if I miss a class? +
How will I execute the practical? +
Is the course material accessible after completion of the course? +
Is there any offer/discount that I can avail? +
Will I get a refund if I cancel my enrollment? +
What if I have queries after completion of the course? +

Didn't find what you are looking for?  Contact Us