2.x - Course Structure and Guidance for best Outcome (MUST)
  • Welcome to the New SAP HANA 2.x Course structure
  • Accessing resources and planning your learning journey
  • SAP HANA 2.0 50,000 feet Summary
  • Additional Study Materials and Documentation
2.x - Setting up your own SAP HANA Instance
  • Introduction to the section
  • Register and Download SAP HANA express edition
  • System Requirements
  • Setup Virtual box and Import VM image
  • Configure and Start the Database
  • Host Mapping and Test WebIde
  • Mount DB on WebIDE
  • Selecting the Target tenant for persistence
  • Section Quiz GCP
2.x - Building SAP HANA Models for Purchase Insights ( Level: Beginner)
  • Section Introduction
  • Modelling Fundamental Idea (Over simplified)
  • WebIDE Walkthrough (getting ready for the project)
  • Project Data Model and Model Design
  • Importing Data and do your own modeling
  • Import the whole project with Data and Models
  • Introduction to SAP HANA Joins(Regular) - Theory
  • Inner Join 1-1 (Theory and Hands-on)
  • Inner Join 1-n (Theory and Hands-on)
  • Left Outer Join (Theory and Hands-on)
  • Right Outer Join (Theory and Hands-on)
  • Full Outer Join (Theory and Hands-on)
  • Referential Join (Theory and Hands-on)
  • Build Employee Dimension Calculation View
  • Build Partner Dimension Calculation View
  • Build Product Dimension Calculation View
  • Build Purchase Insights Cube Calculation View
  • A closer look at the Semantic Layer
  • Introduction to SAP HANA Nodes (Part 1)
  • Implement Restricted Column
  • Section Quiz P1
2.x - Smart Data Integration and Access (SDI/A) (Level: Beginner, Intermediate)
  • Section Introduction
  • Install SDI Components on the Hana Server
  • Importing Data and Build your own models
  • Create Remote Connection
  • Create MTA Project
  • UAA Setup (Access between Tenant and HDI)
  • Updating YAML file and Creating a .hdbgrants file
  • Create Virtual Table
  • Test an empty SDI FlowGraph
  • Import the Data Flows
  • Project Base cube design - Walkthrough
  • Create projection 1
  • Create projection 2
  • Use a Case Transform to Split the Data
  • Use a Union Transform to combine similar datasets
  • Use a Join Transform
  • Use a Aggregate Transform to Roll up the measures
  • Project CDC(Change Data Capture) Design - Walkthrough
  • Current Source Table Analysis
  • Setup Source table for the project
  • Create Virtual Table for CDC
  • Setup Namespace
  • Setup Capture Table for CDC
  • Build Surrogate Key
  • Use Table Comparison for CDC
  • Use History Preserving for CDC
2.x - Build SAP HANA Models for Sales Insights (Level: Intermediate)
  • Section Introduction
  • Section Intro - Project Data Model and Model Design
  • Importing Data and do your own modeling
  • Import the whole Project with Data and Models
  • Build Partner Dimension Calculation View
  • Build Cube Calculation view for 2014 Data
  • Build Cube Calculation view for 2015 Data
  • Union 2014 and 2015 datasets
  • Implement a filter to restrict data
  • Implement an Input Parameter to collect user selection
  • Create an extra column for Currency Conversion
  • Implement Currency Conversion
  • Rank Feature Introduction
  • Implement Rank Functionality (Absolute)
  • Implement Rank Functionality (Percentage)
  • Implement a Temporal Join to make a time bound selection
  • Implement Spatial Join to operate on Geo data
  • Implement Hierarchies
  • Documentation
  • Section Quiz
2.x - Model Optimization and Accuracy
  • Section Introduction
  • Fundamentals
  • Performance Analysis - Test Features
  • Debug Mode - Test Features
  • Explain Plan - Test Features
  • Visualize Plan - Test Features
  • Performance Improvement by reducing data vertically and horizontally
  • Performance Improvement by Avoiding Join when not required
  • Performance Improvement by Union Pruning(avoiding a sub set when not required)
  • Maintaining Accuracy
  • Data Lineage
  • Section Quiz
2.x - Model and Data Security
  • Section Introduction