• +91 95429 34555

  • +91 96429 81112

  • 07:30 AM - 08:30 PM

  • Monday to Saturday

SAP HANA Training :

Vtech Soft Solutions is a brand and providing quality online and offline trainings for students in world wide. Vtech Soft Solutions providing Best SAP Hana training in Hyderabad.

Vtech Soft Solutions provides real time and placement focused SAP HANA Training in Ameerpet, Hyderabad. Our SAP HANA Course includes basic level to advanced level and our sap hana course is designed to get the placed in good MNC companie’s in Hyderabad as quickly as once you complete the SAP Hana training course. Our SAP HANA Trainers are professionals and experienced working professional with hands on real-time multiple SAP HANA projects knowledge. We have designed our SAP HANA Course content and course outline base on student’s requirement to get everyone's profession goal. In our SAP HANA Training program, you will be trained.

  • SAP HANA Introduction and Architecture
  • SAP HANA Appliance Model, SAP HANA Studio Features
  • Reporting on HANA with BI 4.0
  • Advanced Data Modeling with SQL Script
  • Data Provisioning in HANA
  • Security and user management in HANA
  • SAP HANA real time project and sap hana placement assistance training.

Vtech Soft Solutions offers SAP HANA Training with option of training in multiple locations across Ameerpet, Hyderabad. Our SAP HANA Classroom Training Centers are prepared with lab facilities and excellent infrastructure. Vtech Soft Solutions in Hyderabad conducted on day time classes, weekend training classes, evening batch classes and fast track training classes.

SAP HANA 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

SAP HANA Training Faq's :

SAP HANA Training Batch Timing's :

Enquiry Now..!!


Contact Vtech Soft Solutions :

Contact Details :

  • #301, S S Chambers, SAP Street, Gayatri Nagar, Behind Huda Mytrivanam, Ameerpet, Hyderabad, Telangana, Pin: 500018.
  • (040) 4026 9386
  • (+91) 9542934555, (+91) 9642981112
  • info@vtechsoft.in


Vtech Soft Students Testimonials :


Our Students Placed in...

Address

#301, S S Chambers, SAP Street, Gayatri Nagar, Behind Huda Mytrivanam, Ameerpet, Hyderabad, Telangana, Pin: 500018.

Call Us Now

(+91) 9542934555
(+91) 9642981112