Time4 HANA

60 Scripted Calculation View Input Parameter

63 Import Data with CDS Table Import

SAP HANA Stored Procedure WITH ENCRYPTION

Practice exercise – 22

Aggregate before calculate

Connecting to HDI container from HANA Studio

19 Aggregate Functions

47 Design Time Object Scalar UDF

Common records between two tables

Cleanup procedure using Cursor and Dynamic SQL

[NEW] - CREATE or REPLACE procedure SYNTAX with HANA 2.0

54 Table Type

33 SAP HANA SQL Create schema

Data Cleansing with REPLACE REGEXPR

HANA History Table

Casting to decimal issue

WITH ENCRYPTION (HANA 2.0 New feature)

62 Create Table with CDS

Practice exercise – 19

Create a table with same structure of other table in SAP HANA

Practice exercise – 14

Identify missing values (popular interview question)

58 Data generator application (Solution)

Web IDE Overview

Transforming NULLs into meaning full

HANA Time travel Query

Practice exercise – 24

Complex data sorting using HANA SQL

Practice exercise – 21

Practice exercise – 27

SAP HANA SQL Common Table Expression (HANA CTE)

Temporary Tables

SAP HANA SQL Triggers

Practice exercise – 13

Intro: SAP HANA SQL & SQL Scripting - Step 1 course

53 Table Variables

SQL Query Order of Execution

61Create Table using Design Time

42 Load Data from File

Create new workspace in Web IDE

Practice exercise – 20

Referencing an Aliased Column in the WHERE Clause

18 SAP HANA SQL Functions

46 Scalar Functions

SLT Introduction

SAP HANA SQL Query Order of Execution

Important Transaction codes in SLT

4. Delta Merge

50 Table Functions

SLT for HANA

52.1 SAP HANA SQL Stored Procedure