Sap Hana 2.0 Modelling Masterclass |Hands On Training

Calc View | Join & Union | Hierarchy | SDI| Functions | Rank | Optimization | Security | Auth | Graph | Spatial | GitHub

What you'll learn
All HANA Modelling features
All types of Calculation Views
All types of Join and Union
Analytical Privilege, Synonymous, Hierarchies
Rank, Optimization, Best Practices, Github
Advance Analytics with Graph and Spatial Data
Requirements
Basic understanding of any database is enough
however if you want to install HANA edition, then you need PC with 12-16GB of RAM and 128GB of HDD
Description
If you want to understand the latest features of SAP HANA modeling then this course is for you. This course is completely hands-on.We will start from scratch and cover the below topics as hands-on lectures:Introductions- HANA Overview- XSA Overview- Installation of HANA express- Why modeling is needed- Create your first table and load dataViews - Create your first calculation view- Use Input parameter, variable and fuzzy search- Learn all types of calculation joins ( Dim, Cube, Star)Hierarchy-Learn and create the hierarchy- Level and PC hierrachy - Hierarchy FunctionJoins- learn all kinds of joins and Unions- Inner, outer, minus, intersect, referential, non-equiFunction- Scalar function- Table Function- ProcedureRank- Learn how to Rank- All new features of RankOptimization & Best Practices- Learn Optimization options - Learn Best practices- Union pruning: Explicit and Implicit- Parallelization- Handling of multiple filterManagement- Impact & Linage Analaysis- Copy, paste, delete and refactor- Use of NamepaceSecurity & Authoriation- Analytical Privileges- Masking- K-Anonymity- Differential PrivacySynonymous- Learn how to use SynonymousAdvance Analytics- Learn how Graph Analytics works- Learn Spatial data handlingSmart Data Integration (SDI)- Learn what is SDI- Install and Config your own DP agent- Activate adapter and load file- Create virtual table and use FlowgraphGithub- How GitHub works- Github @ local and @remoteAnd more details on various topics.

Overview

Section 1: Introduction

Lecture 1 Course Introduction

Lecture 2 SAP HANA Overview

Lecture 3 How to Use This Course

Lecture 4 Special Gift

Lecture 5 XSA Overview

Lecture 6 Install HANA Express Edition

Lecture 7 Login detail

Lecture 8 Web IDE Walkthrough and mounting of DB

Lecture 9 Why data Model is needed?

Lecture 10 First CDS Object

Lecture 11 Code for the Project

Lecture 12 Create Table I

Lecture 13 Files used in Next section

Lecture 14 Create Table and Load data

Section 2: Views

Lecture 15 Views in HANA

Lecture 16 Create first calc view

Lecture 17 Theory on Input Parameter and Variable

Lecture 18 Use of Input Parameter in calc view

Lecture 19 Use of Variables

Lecture 20 Fuzzy Search

Section 3: Hierarchy

Lecture 21 What is Hierarchy

Lecture 22 Level Hierarchy

Section 4: Joins

Lecture 23 Various Joins

Lecture 24 Files for Next lecture

Lecture 25 Joins & Cardinality

Section 5: More Views

Lecture 26 Files used in next lecture

Lecture 27 Calculation View : Cube

Lecture 28 Exercise : Business Partner

Lecture 29 Files for exercise

Lecture 30 Solution : Business Partner

Lecture 31 File for next section

Lecture 32 Star Join

Lecture 33 Calculated Column, Restricted Column & Counter

Lecture 34 Currency Files for next lesson

Lecture 35 Currency Conversion

Section 6: More Options in Join

Lecture 36 File for Join tables

Lecture 37 Joins in System

Lecture 38 Referential Join

Lecture 39 Non Equi Join

Lecture 40 Minus Node

Lecture 41 Intersect Node

Section 7: Union

Lecture 42 Union

Lecture 43 Union Behaviour

Lecture 44 Multijoin

Section 8: Scalar, Table Function & Procedure

Lecture 45 Theory

Lecture 46 Scalar Function

Lecture 47 Code used in next lesson

Lecture 48 Table Function

Lecture 49 Code for next lesson

Lecture 50 Procedure

Section 9: Rank

Lecture 51 Rank Part I

Lecture 52 Rank Part II

Section 10: Optimization and Best practices for Modelling

Lecture 53 Best Practices

Lecture 54 Optimization : Performance Analysis

Lecture 55 Optimization : Explain & Analyze Plan

Lecture 56 Optimization : Debugging

Section 11: Managament

Lecture 57 Impact & Linage Analysis

Lecture 58 Copy,Paste, Refactoring and more

Lecture 59 Namespace

Section 12: Security & Authorization

Lecture 60 Security theory

Lecture 61 Analytic Privilages

Lecture 62 Masking

Lecture 63 Files for next lesson

Lecture 64 K-Anonymity

Lecture 65 Diff Privacy

Section 13: Connection to HDI

Lecture 66 Code used in next session

Lecture 67 Synonyms for HDI Container

Lecture 68 Code for next lesson

Lecture 69 Synonyms for Classic Schema

Section 14: Advance Analytics

Lecture 70 Code in next lesson

Lecture 71 Graph Analytics I

Lecture 72 Graph Analytics II

Lecture 73 Graph Analytics III

Lecture 74 Code in next lesson

Lecture 75 Graph Analytics IV

Lecture 76 Code in next lesson

Lecture 77 Spatial Data

Section 15: Hierarchy Advance

Lecture 78 Code in next lesson

Lecture 79 Hierarchy Parent-Child

Lecture 80 Hierarchy Function I

Lecture 81 Hierarchy Function II

Section 16: SDI

Lecture 82 SDI Overview

Lecture 83 SDI Agent Install

Lecture 84 SDI Agent Config

Lecture 85 SDI Remote Connection

Lecture 86 SDI Virtual Table

Section 17: FlowGraph

Lecture 87 Flowgraph

Section 18: GitHub Connection

Lecture 88 GitHub Overview

Lecture 89 GitHub Local

Lecture 90 GitHub Remote

Section 19: More Performance improvement option

Lecture 91 Multiple filter ignore

Lecture 92 Files for next section

Lecture 93 Union Pruning Implicit

Lecture 94 Parallelization

Lecture 95 Adhoc

Anyone curious about SAP HANA Modelling,SAP Developers,Tech Architect,Solution Architect