SAP HANA

                                SAP HANA  TRAINING

Are you worried about  your career ?  Want a hike in your salary ? Study this industry  demanding course SAP HANA and get hired fast and get highly paid. SHIVI provides the hands-on ONLINE  TRAINING in SAP HANA -100 % practical and job based training by real time experts . We provide  step by step coaching  and prepare you for the job.

Find  the course contents and details  below:

COURSE FEE : USD 350

 

HIGHLIGHTS OF TRAINING

  •  Real time Industry Experienced Trainer
  • 60 days of free remote server access
  •  Interactive Training session using web conferencing tool
  •  Normal track, weekend and fast track classes
  •  Join our weekday batch and finish course in 15 days
  •  Certification Material, Training Material, Exercises and Real time examples with case studies.

 

COURSE CONTENTS

SAP HANA INTRODUCTION

  • Introduction,Overview and Architecture of SAP HANA(Discussing below topics in detail)
  • Importance of In-memory studio,Row store vs column store, Reporting, Session Mngt, Relational Engine,Request processing/Execution Control, Persistence Layer, Disk Storage, Load Controller, Replication Agent,BOBI
  • Difference between native hana and S4HANA.

HANA STUDIO

  • Look and feel
  • What is PERCEPTIVES
  • How to add systems
  • What is schema & How to create Schema
  • What is Catalog,Content,Data provisioning
  • How to create Package, Project
  • Database tables -How to create a table /fill data
  • Sequences
  • Synonyms
  • Create Trigger
  • Scalar functions
  • Table functions

 SAP HANA SQL/ SQL Script

  • HANA SQL DDL,DML,DCL
  • Data Type & Identifiers,Operator
  • SQL Function
  • SQL Expression
  • SAP HANA Join,Union,Union all,except,intersect
  • SQL EXAMPLES
  • SQL Stored Procedure

DATA MODELLING

  • Views
  • Master data Vs Transactional data
  • Star schema
  • How to create Attribute View
  • Importance of Description Mapping
  • Importance of Text Join
  • How to create Hierarchies
  • How to create Analytical View
  • Importance of Data Foundation
  • Importance of Save & Activate, Data Preview
  • How to create Calculation View
  • What is Calculation View
  • Importance of Save, Attributes, Measures, Variables
  • Importance of Find Column
  • Importance of UNION/JOIN & PROJECTION
  • Using Input Parameters and Variables
  • Importance of Analytical Privileges

IMPLEMENTATION SCENARIOS

  • Loading Data from Excel File to HANA Database Table
  • Loading Data from Flat File to HANA Database Table
  • Using Template Tables
  • Loading Data from SQL  to HANA Database
  • Loading Data from SAP ECC to HANA Database
  • Loading Data from SAP BW to HANA Database
  • Loading metadata from SAP ECC to HANA Database

DATA PROVISIONING USING BODS

  • Data services-One stop solution
  • Data Integration ,Data Quality ,Data Profiling
  • Working with BODS Data Designer
  • BODS Server
  • Repository
  • Job Server
  • Creating Datastore,Workflow and Dataflows
  • Creating Connection to HANA DB
  • Extraction from flatfile to HANA using BODS
  • Extraction from SQL to HANA using BODS
  • Extraction from SAP  to HANA using BODS

DATA PROVISIONING USING SLT

  • SAP Landscape Replication server for HANA
  • Key benefits of SLT Replication server
  • Key benefits of Trigger-Based Approach
  • Architecture for SAP source Replication
  • Architecture for Non-SAP source Replication
  • Creating new Configuration for SAP Sources
  • Creating new Configuration for Non-SAP Sources
  • Result of Creating new Configuration
  • Start Load/Replication
  • Stop/Suspend Replication
  • Status Monitoring in HANA Studio
  •  SLT based transformation Concept
  •  Advanced Replication Settings
  • Change of table Structuring and Partitioning
  •  Filtering and Selective data replication

REPORTING

  • MS-Excel based reporting
  • Defining business layer on IDT(Information Design Tool) Environment
  • Webi Reporting on HANA DB
  • Crystal reporting on HANA DB
  • SAP HANA Database Connectivity Options
  • Lumira(Visual Intelligence)
  • SAP BO Analysis for office
  • Dashboards

AUTHORIZATIONS

  • User Creation
  • Role Creation
  • How to assign role to user
  • Assigning Privileges Users & Roles
  • How to assign Analytical privileges to role

TRANSPORT MANAGEMENT

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

Course Highlights

  • Project Overview
  • HANA-Functional, Technical, Documentation
  •  ECC with SLT Configuration
  •  BODS with HANA Integration
  •  HANA with BO Reporting