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
