For Demo & New Batches, Please Contact      :  +91 9951 6666 90   |       :  (+44)2086772323   |       :  info@innomatics.in

SAP HANA

SAP HANA

Ratings (0)

About SAP HANA Certification training Course

This SAP HANA online training from Innomatics will ensure you get a good grasp of SAP HANA fundamentals, learn and deploy real-time analytics. HANA is an on-premise application that is used for gathering real-time insights. In this SAP HANA training you will learn about SAP HANA Studio, Modeling, Security features and various other aspects. You will understand why SAP HANA is a fundamentally different database engine.

What you will learn in Online SAP HANA Training Course?

  1. Learn SAP HANA basics,features,architecture and terminology involved
  2. Work on HANA Studio Modelers and gain expertise in modeling
  3. Master SAP HANA Interface, client and connectivity
  4. Auto documentation process and SAP BO Analysis
  5. Learn SAP HANA administration activities like managing users, storage and security
  6. Master System Replication, data provisioning and ABAP Data flow
  7. Configuring, reporting, monitoring & dashboard creation using SAP HANA
  8. Work on real time and complex HANA projects
  9. Writing SAP HANA queries and performance tuning
  10. Prepare for  SAP Certified Application Associate Exam

In SAP Hana online training sessions, you will get familiarized with SAP HANA and its components.

  • What is SAP HANA?
  • SAP HANA Environment & Components
  • Replications Methods in SAP HANA
  • SAP In-Memory Strategy
  • HANA Comparison to BWA
  • Look & Feel of HANA
  • In-Memory Computing Studio
  • Administration
  • view Navigator
  • View System Monitor
  • Information Modeler
interactive training 24 Hrs
Instructor Interaction Yes
Course material from DevOps Institute  Yes
Live Support Post Training 1 Year
Simulated Project 1
Real Time Project 2
Kovid DevOps Foundation Certificate  Yes
DevOps Institute Exam voucher valid for an year.  Yes

Getting started with SAP HANA:

Introduction to SAP HANA, HANA compared to BWA, HANA: the best of OLAP and OLTP in one tool, Row oriented storage, Column oriented storage, What is Extraction, Transformation and Loading (ETL)

Architecture of SAP HANA:

Explore the SAP HANA landscape, Interfaces for administrators and developers, Learn about the in-memory database, Join Engine, OLAP Engines, Calculation Engine

SAP HANA Versions and Studio overview:

Version & Service pack details, In-Memory SAP HANA Computing Studio, Connection and session management, Studio Perspectives : Modeler, Development, Debug, Administration Console Catalog and Content in Studio, Hierarchies, Views, Decision Table, Attributes, Variables

HANA Studio Modeler and Modeling:

Importance of Data Modeling, SAP HANA General Modeling Principles, ER Model, Multi-Dimensional Model, Star Schema, Levels of Modeling in SAP HANA : Attribute Views, Analytic Views, Calculation Views

Hands-on Exercise – Create ER Model, Create Multi-Dimensional Model, Create a Star Schema

Attribute Views:

Time, Derived, Shared and Hidden views, Hierarchies (Parent-Child), Filters

Hands-on Exercise – create different type of Views, Create parent-child hierarchy, Apply Filters

Analytic Views:

Multi-Dimensional Model with Analytic Views, Calculated Measures and Attributes, Restricted Measure, Variable Types (Concept, Input).

Hands-on Exercise – Open Analytic View in a Multi-Dimensional Model, Use calculated Measures and Attributes, Use Restricted Measure, Use Variables

Calculation Views:

Calculation Views (Graphical, Scripted), Union, Join (Inner, Left Outer, Right Outer, Full Outer, Text, Referential), Projection, Aggregation, Choosing Views for Information Model, Connecting tables.

Hands-on Exercise – Check graphical calculation view, Perform full outer join and other types of join operations, Choose Views for Information Model, Connect with tables

HANA SQL:

Introduce SQL and SQLScript, HANA SQL (DDL, DML, DCL), SAP HANA Referential Join, Table Functions and Procedures, Calling Procedures, Using the SQL Debug Tools.

Hands-on Exercise – Write HANA SQL DDL query, Write HANA SQL DML query, Write HANA SQL DCL query, Perform a referential join, Create Table Functions and Procedures, Call Procedures, Use the SQL Debug Tools

Using CE-Functions:

Control Statements, CE_COLUMN_TABLE, CE_JOIN_VIEW, CE_OLAP_VIEW, CE_CALC_VIEW and others

Hands-on Exercise – Use CE_COLUMN_TABLE, Use CE_JOIN_VIEW, Use CE_OLAP_VIEW, Use CE_CALC_VIEW

Data Provisioning Services:

What is Data Provisioning, Data Provisioning Scenarios, Overview of SAP HANA Vora, Loading Data to HANA Database Table From Excel File, Flat File, Oracle Database, SAP ECC, SAP BW Data Provisioning Using BODS, Data Provisioning Using SLT (SAP Landscape Transformation Replication Server)

Hands-on Exercise – Load data to HANA, Database Table from an excel file, Make data Provisioning Using BODS, Make data Provisioning Using SLT (SAP Landscape Transformation Replication Server)

Transformations in SAP HANA:

Data transformation in SAP HANA, The process of data integration, data cleansing and consolidation, The process of loading data from one BI object to another, Various types of transformation (Merge, History Preservation, Row Generator, Table Comparison, Slowly Changing Dimensions)

Hands-on Exercise – Load data from one BI object to another, Perform transformation using Merge technique, Perform transformation using Slowly Changing Dimensions

User Management, Provisioning and Security:

Understand the Key Concepts of SAP HANA Security, Define Data Access Security, User Creation, Role Creation, Assigning role to user, Assigning Analytical privileges to role

Hands-on Exercise – Create a user account, Create roles Assign roles to user, Assign Analytical privileges to role

Transport Management

Introduction to Transport Connection, Overview on SAP Transport Connection, HANA Transports

Hands-on Exercise – Connect with Transport feature

SAP HANA Project:

Project –Develop reports using SAP HANA

Dataset – Sales

This project is involved with creation of reports using SAP HANA. You will get in-depth understanding of creating SAP HANA reports with SAP Business Objects explorer, learning to deploy different SAP HANA views like attribute, analytic and calculation views, understanding how to create SAP HANA Crystal Report, deploying MDX Provider for connecting HANA system to Excel data, data modeling techniques. Upon completion of the project you will gain expertise to develop reports from multiple data sources and view it to glean valuable insights.

Course Reviews


CONTACT US

#206 A, 2nd Floor, Fortune Signature,
Adj: JNTU METRO Station, Above: Pista House , KPHB, Hyd – 85

Phone : 9951 6666 90 / 70 / 71
Email: info@innomatics.in