Follow our LinkedIn SAP Learner Community for a lot of Free Content
Session 1 - Introduction to HANA Architecture
Session 2 - Using different nodes in calculation view
Session 3 - Create restricted and calculated columns, filtering data
Session 4 - Implementing Hierarchies, Introducing SAP HANA SQL
Session 5 - Implementing Hierarchies, Introducing SAP HANA SQL (Hands On)
Session 6 - W3School, Creating & Using Scalar function, Virtual Table creation
Session 7 - Creating and Using Procedures & Debugging of Stored procedures, Declarative Logic & Imperative Logic
Session 8 - Data load: Flat file data update, SQL practice, Table function creation
Session 9 - Data insert with Flat file update, Window functions, start of table function, SQL COALESCE function
Session 10 - User-defined libraries
Session 11 - Lab activity calling Procedure & table function, introduction to planViz
Session 12 - Performance analysis and best practices of SAP HANA, Implementing static cache
Session 13 - Lab activities on union pruning and Different scenarios
Session 14 - Scheduling of procedures and Troubleshooting, Defining Analytical Privileges and roles
Session 15 - Recap
Assignments
Lab Activity
-
Lab Activity - Exercise - Access a Calculation View in Performance Analysis Mode
-
Lab Activity - Exercise - Audit Information Models and their Dependencies
-
Lab Activity - Exercise - Cascade User Prompts
-
Lab Activity - Exercise - Clone the SAP HANA Interactive Education (SHINE) Application from GitHub
-
Lab Activity - Exercise - Combine Two Data Sources with a Union Nod
-
Lab Activity - Exercise - Control Parallelization in a Data Flow
-
Lab Activity - Exercise - Control the Behavior of the Aggregation Node
-
Lab Activity - Exercise - Create a CUBE with Star Join Calculation View
-
Lab Activity - Exercise - Create a DIMENSION Calculation View
-
Lab Activity - Exercise - Create a Level Hierarchy
-
Lab Activity - Exercise - Create a New Project and an HDB Module
-
Lab Activity - Exercise - Create a Parent-Child Hierarchy
-
Lab Activity - Exercise - Create a Procedure that is Consumed by an Input Parameter
-
Lab Activity - Exercise - Create and Assign an Analytic Privilege
-
Lab Activity - Exercise - Create Restricted and Calculated Measures
-
Lab Activity - Exercise - Define a Data Source using a Table Function
-
Lab Activity - Exercise - Define a Persistence Layer
-
Lab Activity - Exercise - Define and Use Filters
-
Lab Activity - Exercise - Define Column Masking in a Calculation View
-
Lab Activity - Exercise - Implement a Hierarchical Value Help
-
Lab Activity - Exercise - Implement Currency Conversion in a Calculation View.docx
-
Lab Activity - Exercise - Implement External View for Value Help
-
Lab Activity - Exercise - Implement Union Pruning in a Calculation View
-
Lab Activity - Exercise - Import, Rename and Copy Models
-
Lab Activity - Exercise - Join Three Tables in a Single Join Node
-
Lab Activity - Exercise - Prepare Your SAP HANA System
-
Lab Activity - Exercise - Read a Hierarchy Structure with SQL
-
Lab Activity - Exercise - SAP Create a Cube Calculation View
-
Lab Activity - Exercise - Set Up a Project to Access an External Schema
-
Lab Activity - Exercise - Use a Minus Node in a Calculation View
-
Lab Activity - Exercise - Use Debug Query Mode
-
Lab Activity - Exercise - Use Git for Version Control in Your Local Workspace
-
Lab Activity - Exercise - Use Rank Nodes to Partition, Order, and Extract Values from a Data Set
-
Lab Activity - Exercise - Use Variables and Input Parameters
-
Lab Activity - Exercise - Work with SQL Statements
Configuration Guides (Downloaded from the Internet as it is available for Public Use)
-
Configuration Guide - Hana Native Reporting on BW Data
-
Configuration Guide - Native HANA
-
Configuration Guide - P2047 Sherkat
-
Configuration Guide - SAP Agent Deployment Guide - 1
-
Configuration Guide - SAP Agent Deployment Guide - 2
-
Configuration Guide - SAP Native HANA Best Practices
-
Configuration Guide - SAP Native HANA Modelling
Capstone Projects / Case Studies
-
Capstone Project - SAP Native HANA - Integrated Financial Analytics Platform for GlobalCorp Inc.
-
Capstone Project - SAP Native HANA - Intelligent Building Management Platform for SmartCity Inc.
-
Capstone Project - SAP Native HANA - Intelligent Supply Chain Management Solution for ManufacturingCorp
-
Capstone Project - SAP Native HANA - Omnichannel Sales Analytics Solution for RetailGiant
Interview Questions
Prepare your Linkedin profile
Prepare your Resume
Quiz
