SAP HANA Certification Online Training India

SAP HANA Certification Online Training India

Module – 1
Getting started with SAP HANA and SAP HANA Architecture

Contents

  • Introduction to SAP HANA
  • Introduction to In-Memory Computing
  • HANA: the best of OLAP and OLTP in one tool
  • Fundamentals of SAP HANA
  • What SAP HANA Can do
  • What SAP HANA Can’t do
  • High Performance functionalities in SAP HANA
  • In-Memory computing
  • Columnar store database
  • Massive Parallel Processing
  • Data Compression
  • Version & Service pack details
  • SAP HANA Architecture
  • SAP HANA Used Case Scenarios
  • Explore the SAP HANA landscape”

Module – 1
Introduction to HANA Studio IDE & HANA Database SQL Basics

Contents

  • Introduction to In-Memory Computing Studio
  • Role of Hana Studio
  • Role of Hana Client
  • Add SAP HANA System Perspectives Administration
  • Modelling Development Plan Viz Folders Catalog Content
  • Provisioning Security””.
  • Introduction to SAP HANA Database SQL Script
  • HANA DATABASE SQL BASICS TYPES OF STATEMENTS DATA TYPES OPERATORS EXPRESSIONS
  • BASIC QUERY EXECUTION SUB-QUERY JOINS
  • Expressions Loops CATALOG SCHEMA TABLE
  • Database VIEWS+E3 FUNCTIONS STORED
  • PROCEDURES INDEX SYNONYMS SEQUENCES TRIGGERS-PROVISIONING SDA [Smart Data Access]SECURITY USERS ROLES”

Hands On;

  • Create a Catalog Schema
  • Create a Package
  • Create Column Table
  • Create Row Table
  • Insert Data into tables
  • Create Database View
  • Create UDF [User define functions]
  • Create Stored Procedures
  • Create Public Synonyms
  • Create Sequences
  • Create Indexes
  • Create Triggers”

Module – 3
SAP HANA Modelling

Contents

Introduction Types of Models Attribute Views Joins
Using Filter Operations Creating Restricted & Calculated Columns Using Hierarchies Analytic Views Star Schema design Muti-Dimensional modelling Using Variables Using Input parameters Advantages & Limitations

Hands On;

  • Create Un-Structured Package
  • Edit Package to make Structured
  • Create Attribute View
  • Create Analytic View
  • Apply Static filter
  • Create Variable
  • Create Input Parameter
  • Create Calculated objects
  • Create Restricted Measures
  • Create Hierarchies”

Module – 4
Calculation Views

Contents

Calculation Views (GUI) Dimension Calculation View Star Join Calculation view OLTP Calculation view Using Projection Using Join Using Aggregation Using Union Using RankCalculation Views (Scripted) CE functions Introduction Creating Content Procedure

Hands On;

  • Create GUI Calculation view – Dimension
  • Create GUI Calculation View – Star Join Cube
  • Create GUI Calculation View – Cube
  • Use Projection Node
  • Use Aggrigation Node
  • Use Join Node
  • Use Union Node
  • Use Rank Node
  • Create Scripted Calculation View – Cube
  • Use CE functions
  • Use SQL Script
  • Create Procedure and use it in Scripted Calculation view”

Module – 5
Analytic Privileges & Decision Tables

Contents
Analytic Privileges Classical Analytic Privileges SQL Analytic Privileges Dynamic analytic Privileges Turning Business Rules into Decision tables Table Functions

Hands On;

  • Create Analytic Privileges
  • Classical Analytic Previliges
  • SQL Analytic Previliges
  • Dynamic Analytic Previliges
    Assign Analytic Previliges to User or role
  • Create Update Decesion Table
  • Create Return Decesion Table
  • Call Decision tables as procedures in catalog
  • Create Table Function
  • Use Table Function in GUI Calculation view”

Module – 6
Advance Modelling Topics

Contents
Advance Modelling Union Pruning Refactoring information models Schema Mapping Propagate to schematics Show Lineage Find Where used Schema Mapping Generating Time Data Using Time Travel Migrating deprecated Information models Using Currency ConversionWeb Based Modelling Workbench Advance HANA Database Objects Temporary tables Triggers Exceptions Handling”

Hands On;

  • Create Union Pruning Configuration table
  • Insert conditions as rows into pruning configuration table
  • Assign configuration table to Union GUI calculation view
  • Refactoring Information Views
  • Configure Schema Mapping
  • Generating Time Data
  • Enable Time Travel Queries for catalog Tables
  • Migrating Depreciated views to GUI Calculation views
  • Migrating Classical Analytic Previliges to SQL Analytic Previliges
  • Migrating Scripted Calculation Views to GUI Calculation Views with Table Functions
  • Enabling currency conversion for Calculation view measure objects
  • Working with Web based modelling workbench
  • Creating temporary tables
  • Using Exception Handling in SQL Script Procedures”

Module – 7
Application Life Cycle Management

Contents
Application Life Cycle Management Transport Using Developer mode Transport Using Delivery Unit modeChange management Analyzing Query Performance with Explain Plan Visualize plan Performance traceFull Text Search Overview Datatypes & full text Indexes Using Full text search

Hands On;

  • Transporting Content objects
  • Using Developer mode
  • Creating Delivery unit
  • Transporting Content objects
  • Using Delivery unit mode
  • Creating change requests
  • Creating full text search queries”

Module – 8
Data Provisioning Services

Contents
What is Data ProvisioningData Provisioning Scenarios Loading Data to HANA Database Table 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;

  • Configuration SLT on SLT Server
  • Loading/Replicating Tables using above configuration
  • Loading data using file import mechanism
  • Creating PROJECT/JOB/WORKFLOW/DATAFLOW/MAPPING In
  • BODS
  • Executing Job to transfer data from various source to Target
  • 1. ECC-HANA
  • 2. RDBMS – HANA
  • 3. File – HANA”

Module – 9
User Management, Provisioning and Security

Contents
Understand the Key Concepts of SAP HANA Security Define Data Access Security User Creation Role Creation Assigning role to user Analytical privileges to role” Object Previleges Package Previleges

Hands On;

  • Create a user account
  • Create roles
  • Assign roles to user
  • Assign Analytical privileges to role”

Module – 10
SAP Reporting

Contents

  • SAP Reporting/Dashboard creation
  • Introduction to Lumira
  • Using Lumira Prepare, Visualize compose data
  • SAP HANA Dynamic tiring
  • Delta Merge
  • Partitioning of tables
  • SAP HANA cloud Platform overview

Hands On;

  • Creating Live Connection to HANA source
  • Create New document using above connection
  • Prepare, Visualize and compose objects from Calculation Views
  • Create Partitioning of Column tables
  • Create Cloud account for using Hana instance.”

Module – 12 Project;

Share this post