52.1 SAP HANA SQL Stored Procedure

52 Elements of a Stored Procedure

WITH ENCRYPTION (HANA 2.0 New feature)

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

SEARCH Operator for Table Variables

BETWEEN operator and BOOLEAN Type in HANA 2.0

Cleanup procedure using Cursor and Dynamic SQL

SAP HANA SQL Triggers

Common records between two tables

Casting to decimal issue

Transforming NULLs into meaning full

Identify missing values (popular interview question)

HANA Time travel Query

HANA History Table

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

Data Cleansing with REPLACE REGEXPR

Connecting to HDI container from HANA Studio

Create new workspace in Web IDE

Web IDE Overview

First Project in HANA 2 0

Connecting to Web IDE

Fetching Random Records from a Table

Practice exercise – 21

Practice exercise – 24

Practice exercise – 27