1

Introduction to In-Memory Computing – Fundamentals of SAP HANA

2

What SAP HANA Can do – What SAP HANA Can’t do. High-Performance functionalities in SAP HANA – In-Memory computing

3

Columnar store database

4

Massive Parallel Processing

5

Data Compression. SAP HANA for Non-SAP Use Cases – SAP HANA for Non – SAP Analytics

6

SAP HANA for Non-SAP Applications. SAP HANA Database Architecture

7

SAP HANA Landscapes and Scenarios.

1

Add SAP HANA System – Perspectives

2

Administration

3

Modeling

4

Development Plan Viz. Folders- Catalog

5

Content

6

Provisioning

7

Security. SAP HANA Database SQL Script – HANA Database SQL Basics

8

Types of statements

9

Data types

10

Operators

11

Expressions

12

Basic query execution

13

Sub-query

14

Joins

15

Expressions

16

Loops

17

Sub-queries. Catalog – Schema

18

Table

19

Views

20

Functions

21

Stored Procedures

22

Index

23

Synonyms

24

Sequences

25

Triggers. Provisioning – SDA [Smart Data Access]. Security – Users Roles

1

Introduction – Types of Models

2

Attribute Views

3

Joins

4

Using Filter Operations

5

Creating Restricted and Calculated Columns

6

Using Hierarchies. Analytic Views – Star Schema design

7

Multi-Dimensional modeling

8

Using Variables

9

Using Input parameters

10

Advantages and Limitations.

1

Dimension Calculation View – Star Join Calculation view

2

OLTP Calculation view

3

Using Projection

4

Using Join

5

Using Aggregation

6

Using Union

7

Using Rank. Calculation Views (Scripted) – CE functions Introduction

8

Creating Content Procedure.

1

Classical Analytic Privileges

2

SQL Analytic Privileges

3

Dynamic analytic Privileges. Turning Business Rules into Decision tables. Table Functions.

1

Union Pruning

2

Refactoring information models

3

Schema Mapping

4

propagate to schematics

5

Show Lineage

6

Find Where used

7

Schema Mapping

8

Generating Time Data

1

Using Time Travel

2

migrating deprecated Information models

3

Using Currency Conversion. Web-based Modeling Workbench. Advanced HANA SQL script -Temporary tables

4

Triggers, Exceptions Handling.

1

Overview

2

Datatypes and full-text Indexes

3

Using Full-text search. Application Life Cycle Management – Transport Using Developer mode

4

Transport Using Delivery Unit mode

5

Change management. Analyzing Query Performance- Explain Plan

6

Visualize plan

7

Performance trace

1

How SAP HANA affects the ABAP development process

2

Introducing the ABAP development tools (ABAP in Eclipse)

3

How to take ABAP to HANA

4

Using SAP HANA as a secondary database

5

The various issues in performance and functional aspects encountered in SAP HANA migration

6

Understanding the ABAP Test Cockpit

7

Code Inspector

8

Profiler

9

Trace and SQL Trace

10

Improving the performance with SQL performance tuning and monitoring

11

Guidelines and rules when deploying ABAP for SAP HANA.

1

What is New Open SQL

2

Definition of advanced views by deploying Core Data Services in ABAP

3

Creating CDS associations

4

How to implement authorization checks using CDS with ABAP

5

SAP HANA Objects in ABAP

6

How to consume SAP HANA views using ADBC (ABAP Database Connectivity) and native SQL in ABAP

7

Using the ADBC and native SQL to consume SAP HANA database procedures.

1

SAP HANA Dynamic tiring

2

Delta Merge

3

SDI [Smart Data Integration]

4

SAP HANA has Application Platform

5

SAP HANA cloud

6

L Procedures

7

R Procedures

8

Partitioning of tables

9

Introduction to AFL – PAL – BFL.