Approaching SAP HANA

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.

Introduction to HANA Studio

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

SAP HANA Modelling

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.

Calculation Views (GUI)

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.

Analytic Privileges

1
Classical Analytic Privileges
2
SQL Analytic Privileges
3
Dynamic analytic Privileges. Turning Business Rules into Decision tables. Table Functions.

In-depth Modeling

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

Modeling (Cont.)

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.

Full-Text Search

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

Data Provisioning

1
Data Provisioning – Data provisioning using SLT
2
Data Acquisition with BODS
3
Data Provisioning with Flat File upload
4
Data Provisioning using Direct
5
Extractor Connection
6
Security and Authorizations
7
Introduction to Lumira
8
Using Lumira Prepare
9
visualize compose data.

ABAP programming for SAP HANA

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.

Accessing data stored in 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.

Advanced Topics Overview

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.

Be the first to add a review.

Please, login to leave a review
SAP HANA training in Fremont Ca
30-Day Money-Back Guarantee

Includes

Full lifetime access
Access on mobile and TV

Working hours

Monday 9:30 am - 9:30 pm
Tuesday 9:30 am - 9:30 pm
Wednesday 9:30 am - 9:30 pm
Thursday 9:30 am - 9:30 pm
Friday 9:30 am - 9:30 pm
Saturday 9:30 am - 9:30 pm
Sunday 9:30 am - 9:30 pm