info@vtechsoft.in +91 9542934555

SAP HANA Online Training

SAP HANA Online Training

SAP HANA (High-Performance Analytic Appliance) is an In-memory Database delivered from SAP to stock data and analyzes the huge volumes of non-aggregated data in Live Atmosphere with unparalleled performance and is ideal for decision support and prophetic analysis.

SAP FICO Online SAP HANA Training provides step-by-step directions to exploit all the likely aspects of the SAP HANA database, allowing users to yoke the complete potential of this technology and its related features. You will definitely gain an understanding of real-time repetitions, active data loading from numerous sources, how to load data, and how to make re-usable objects like models and reports. If you are scheduling to manage the SAP HANA Solutions, then should go through the SAP HANA Training.

SAP HANA Online Training Pre-requisites:

  • A basic knowledge and understanding of database
  • Fair perceptive on IT environment

Why We?

Vtech Soft Solutions provides the finest Software’s training for several Computer IT courses through Gotomeeting, Webex. We provide professional SAP HANA Online Training based on explicit needs of the learners which have great openings in the present IT market. Students can hold the subject from our extremely experienced and certified trainers who will be serving the students to work in real time ventures. Students can select regular course, weekend batches or fast track classes.

Being the leading SAP HANA online training provider in Hyderabad, we constantly work to deliver the best. We are into this training field with great passion and dedication from many years. Our crew of well experienced SAP HANA trainers with huge real time IT experience is dedicated towards providing quality training.

Highlights of our SAP HANA training:

  • Focus on Hands on training with more number of assignments, practice exercises and quizzes
  • Regular Assignments after each Module
  • Quality Study materials
  • SQL Concepts will be covered for better understanding of SQL Scripting.
  • Data Replication Techniques like SAP BODS, SAP LT and DXC will be covered.
  • Numerous reporting Tools on SAP HANA Information Views.
  • Case Studies based on Real-time project Scenarios
  • Certification Guidance

SAP HANA Online Training Course These are the main topics we cover:

  SAP HANA Introduction

1. In-Memory Computing
2. Evolution of In-Memory computing at SAP
3. History HANA
4. HANA Hardware Sizing
5. Product Avai labi lity Matrix
6. HANA compare to BWA

  SAP HANA Overview

1. Architectural overview
2. Row Store
3. Column Store
4. Persistency Layer

  SAP HANA Versions and Studio overview

1. SAP HANA Version
2. History of Service pack detai ls
3. Studio Overview
4. HANA Studio Preferences
5. HANA Studio Prospective

  SAP HANA Engines

1. Column Store Engine
2. Row Store Engine
3. Join Engine
4. OLAP Engines
5. Calculation Engine

  SAP HANA Modeling Attribute View

1. How to connect tables using
2. Inner Join
3. Left Outer Join
4. Right Outer Join
5. Full Outer Join
6. Text Join
7. Referential Join
8. Union
9. Filter
10. Calculated Column

  Analytic View

1. Left Outer Join – Attribute View
2. Inner Join – Analytical View
3. Right Outer Join – Analytical View
4. Referential Join – Analytical View
5. Calculated Attribute
6. Calculated Measure

  Tables in HANA

1. Column Store Table
2. Row Store Table
3. Table Type

  SQL in HANA

1. Basic SQL Knowledge
2. Select Statement
3. From Clause
4. Where Clause
5. Group By clause
6. Having Clause
7. Order by Clause
8. Top N clause

  SQL Procedure in HANA

1. How to create Procedure
2. Elements of the Procedure
3. Procedures using Column Store Views
4. IF-ELSE Logic
5. For Loop Logic
6. Cursor in HANA
7. Dynamic Filter

  CE based Script in HANA

1. CE_COLUMN_TABLE
2. CE_JOIN_VIEW
3. CE_OLAP_VIEW
4. CE_CALC_VIEW
5. CE_JOIN
6. CE_LEFT_OUTER_JOIN
7. CE_RIGHT_OUTER_JOIN
8. CE_FULL_OUTER_JOIN
9. CE_PROJECTION
10. CE_CALC
11. CE_AGGREGATION
12. CE_UNION_ALL

  Calculation View

1. Calculation View Graphical Method
2. Calculation SQL Script method
3. How to call Calculation view using SQL into Calculation Views

  Miscellaneous

1. Delivery Units
2. Transport Individual HANA Models
3. How to load Excel data into HANA using Studio
4. Export/Import
5. How to create Sequence
6. How to create Synonym
7. How to create Trigger
8. How to create View

  Tuning

1. Index creation
2. Partitioning
3. Hash Partition
4. Merge Partition
5. Round Robin Partition
6. Multi-Level Partition
7. Table Redistribution

  Security & User Management

1. Creating Users
2. Creating Roles
3. Privileges
4. Authorization challenges
5. User Administration
6. Backup & Recovery
7. Collecting traces

  Data Provisioning

1. SAP Data Services extraction
2. SAP SLT Replication
3. Smart Data Access
4. SAP HANA-Direct Extractor Connection (DXC)

  SAP Data Services Overview

1. What is SAP Data Services
2. SAP Data Services Architecture
3. SAP Data Services objects (Job, Data Flow, Work Flow, Transformations)

  SAP Data Services Extraction

1. Loading Data from SAP ECC to SAP HANA DB
2. Loading Data from SAP BW to SAP HANA DB
3. Loading Data from MSSQL Server DB to SAP HANA DB
4. Loading Data from Excel to SAP HANA DB
5. How to load data from HANA Information Models to MSSQL DB

  SAP SLT Data provisioning overview

1. What is SAP SLT
2. SAP SLT License options
3. SAP SLT system sizing
4. SAP SLT system landscape preparation

  SAP SLT Schema configuration

1. How to configure SLT Schema for SAP Source system
2. How to configure SLT Schema for Non-SAP Source system
3. No.of Data transfer Jobs configuration
4. How to improve Initial data loading
5. Tables configuration in SLT using Data Provisioning

  SAP SLT Performance tuning technics

1. Monitoring Replication in SLT
2. Access Plan
3. Reading Types
4. Adding Entry in the table IUUC_PRECALC_OBJ
5. Adding Entry in the table IUUC_PERF_OPTION
6. MWBMON
7. How to do Partition in SLT
8. How to restrict the tables that are allowed for replication
9. HANA Supported Data Types
10. How to change the standard mapping

  Advanced Replication Setting

1. How to Edit target table structure
2. How to Import and Export transformations
3. How to set Reading Types to handle large data tables loads

  SAP HANA-Direct Extractor Connection (DXC)

1. Create DXC user
2. Create DXC Schema
3. Setting up DXC connection for SAP Source system
4. Loading Data from Excel to SAP HANA DB
5. How to load data from HANA Information Models to MSSQL DB

  HANA Advanced Analytics

  HANA Reporting BO Tools

1. How to Connect with IDT
2. How to create Universe using HANA Tables
3. How to create Webi Reports
4. Webi Functions
5. How to schedule Webi reports
6. How to assign the WebI reports to the End users

  HANA Reporting with Crystal Reports 2013

1. Report Designer
2. Report creation wizard
3. Sections
4. Sorting and Grouping
5. Chart expert
6. Formulas
7. Sub reports

  HANA Reporting with Crystal Reports for Enterprise

1. How to Connect HANA with Crystal Reports for Enterprise
2. How to create reports

  HANA Reporting with SAP Dashboards

1. How to Connect HANA with Dashboards
2. How to create Dashboard Reports

  HANA Reporting with SAP Lumira

1. How to Connect HANA with SAP Lumira
2. How to Explore HANA Data with Lumira
3. Publish Lumira report

  HANA Reporting with SAP Design Studio

1. SAP Design Studio Overview
2. How to create reports

  HANA Reporting with SAP Predictive Analysis

1. SAP Predictive Analysis Overview
2. How to Explore data with Predictive Analysis

  BW 7.3 powered by HANA Overview

1. BW 7.3 powered by HANA Overview
2. BW7.30-HANA Optimized Info Cube
3. BW7.30-HANA Optimized Info DSO
4. Importing SAP BW7.30 Models into HANA Modeling environment
5. Publish Standalone HANA Models into SAP BW 7.30 on HANA
6. BW on HANA Migration activities

  SAP HANA End to End Mock Implementation Project

1. How configure SAP 150 ECC tables using SLT Replication
2. How to configure Data loads using SAP Data Services from Oracle DB
3. How Create HANA Information models based on Business Requirement
4. Creating HANA Models using Combination of multiple Sources
5. How to generate SAP BO reports and Assign to End User
6. Creating 3 HANA Implementation projects Proof of Concepts

Cloud Tags:

  • SAP HANA Online Training Institutes
  • Best SAP HANA Online Training
  • SAP HANA Online Training
  • Top SAP HANA Online Training Institutes in Ameerpet
  • SAP HANA Online Training Institutes in Hyderabad
  • SAP HANA



Scroll to Top