Session Video - Data insert with Flat file update, Window functions,

SAP Native HANA Training

Follow our LinkedIn SAP Learner Community for a lot of Free Content

SAP Learner Community of LinkedIn

Session 1 - Introduction to HANA Architecture

Session Video - Introduction to HANA Architecture (83:46)
Assessment - Introduction to HANA Architecture
Quiz

Session 2 - Using different nodes in calculation view

Session Video - Using different nodes in calculation view (90:52)
Assessment - Using different nodes in calculation view
Quiz

Session 3 - Create restricted and calculated columns, filtering data

Session VIideo - Create restricted and calculated columns, filtering data (106:14)
Assessment - Create restricted and calculated columns, filtering data
Quiz

Session 4 - Implementing Hierarchies, Introducing SAP HANA SQL

Session Video - Implementing Hierarchies, Introducing SAP HANA SQL (90:47)
Assessment - Implementing Hierarchies, Introducing SAP HANA SQL
Quiz

Session 5 - Implementing Hierarchies, Introducing SAP HANA SQL (Hands On)

Session Video - Implementing Hierarchies, Introducing SAP HANA SQL (Hands On) (95:07)
Assessment - Implementing Hierarchies, Introducing SAP HANA SQL (Hands On)
Quiz

Session 6 - W3School, Creating & Using Scalar function, Virtual Table creation

Session Video - W3School, Creating & Using Scalar function, Virtual Table creation (90:51)
Assessment - W3School, Creating & Using Scalar function, Virtual Table creation
Quiz

Session 7 - Creating and Using Procedures & Debugging of Stored procedures, Declarative Logic & Imperative Logic

Session Video - Creating and Using Procedures & Debugging of Stored procedures, Declarative Logic & Imperative Logic (99:29)
Assessment - Creating and Using Procedures & Debugging of Stored procedures, Declara
Quiz

Session 8 - Data load: Flat file data update, SQL practice, Table function creation

Session Video - Data load: Flat file data update, SQL practice, Table function creation (149:54)
Assessment - Data load Flat file data update, SQL practice, Table function creation
Quiz

Session 9 - Data insert with Flat file update, Window functions, start of table function, SQL COALESCE function

Session Video - Data insert with Flat file update, Window functions, start of table function, SQL COALESCE function (95:14)
Assessment - Data insert with Flat file update, Window functions, start of table function, SQL COALESCE function
Quiz

Session 10 - User-defined libraries

Session Video - User-defined libraries (32:49)
Assessment - User-defined libraries
Quiz

Session 11 - Lab activity calling Procedure & table function, introduction to planViz

Session Video - Lab activity calling Procedure & table function, introduction to planViz (88:30)
Assessment - Lab activity calling Procedure & table function, introduction to planV
Quiz

Session 12 - Performance analysis and best practices of SAP HANA, Implementing static cache

Session Video - Performance analysis and best practices of SAP HANA, Implementing static cache (101:57)
Assessment - Performance analysis and best practices of SAP HANA, Implementing stat
Quiz

Session 13 - Lab activities on union pruning and Different scenarios

Session Video - Lab activities on union pruning and Different scenarios (87:43)
Assessment - Lab activities on union pruning and Different scenarios
Quiz

Session 14 - Scheduling of procedures and Troubleshooting, Defining Analytical Privileges and roles

Session Video - Scheduling of procedures and Troubleshooting, Defining Analytical Privileges and roles (94:53)
Assessment - Scheduling of procedures and Troubleshooting, Defining Analytical Priv
Quiz

Session 15 - Recap

Session Video - Recap (82:27)
Session Video - Recap (67:13)
Session Video - Recap (95:30)
Session Video - Recap (81:39)
Session Video - Recap (88:12)

Assignments

Assignments - Calculation View - Star Join
Assignments - Creating Input Parameters
Assignments - Procedures
Assignments - Table Functions
Assignments - Using different Nodes in Calculation Views

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

Interview Questions - Set 1

Prepare your Linkedin profile

Linkedin Cheat Sheet

Prepare your Resume

Resume Cheat Sheet

Quiz

Test Your Knowledge

Teach online with

Session Video - Data insert with Flat file update, Window functions, start of table function, SQL COALESCE function

Lesson content locked

If you're already enrolled, you'll need to login.

Enroll in Course to Unlock