• LOGIN
  • No products in the cart.

COURSE DESCRIPTION

Approaching SAP HANA
Introduction to In-Memory Computing – Fundamentals of SAP HANA
What SAP HANA Can do, What SAP HANA Can’t do. High-Performance functionalities in SAP HANA – In-Memory computing
Columnar store database
Massive Parallel Processing
Data Compression. SAP HANA for Non-SAP Use Cases – SAP HANA for Non – SAP Analytics
SAP HANA for Non-SAP Applications. SAP HANA Database Architecture
SAP HANA Landscapes and Scenarios.
Introduction to HANA Studio
Add SAP HANA System – Perspectives
Administration
Modeling
Development Plan Viz. Folders- Catalog
Content
Provisioning
Security. SAP HANA Database SQL Script – HANA Database SQL Basics
Types of statements
Data types
Operators
Expressions
Basic query execution
Sub-query
Joins
Expressions
Loops
Sub-queries. Catalog – Schema
Table
Views
Functions
Stored Procedures
Index
Synonyms
Sequences
Triggers. Provisioning – SDA [Smart Data Access]. Security – Users
Roles.
SAP HANA Modelling
Introduction – Types of Models
Attribute Views
Joins
Using Filter Operations
Creating Restricted & Calculated Columns
Using Hierarchies. Analytic Views – Star Schema design
Multi-Dimensional modeling
Using Variables
Using Input parameters
Advantages & Limitations.
Calculation Views (GUI)
Dimension Calculation View – Star Join Calculation view
OLTP Calculation view
Using Projection
Using Join
Using Aggregation
Using Union
Using Rank. Calculation Views (Scripted) – CE functions Introduction
Creating Content Procedure.
Analytic Privileges
Classical Analytic Privileges
SQL Analytic Privileges
Dynamic analytic Privileges. Turning Business Rules into Decision tables. Table Functions.
In-depth Modeling
Union Pruning
Refactoring information models
Schema Mapping
propagate to schematics
Show Lineage
Find Where used
Schema Mapping
Generating Time Data
Modeling (Cont.)
Using Time Travel
migrating deprecated Information models
Using Currency Conversion. Web based Modeling Work bench. Advanced HANA SQL script -Temporary tables
Triggers, Exceptions Handling.
Full Text Search
Overview
Datatypes & full text Indexes
Using Full text search. Application Life Cycle Management – Transport Using Developer mode
Transport Using Delivery Unit mode
Change management. Analyzing Query Performance- Explain Plan
Visualize plan
Performance trace
Data Provisioning
Data Provisioning – Data provisioning using SLT
Data Acquisition with BODS
Data Provisioning with Flat File upload
Data Provisioning using Direct
Extractor Connection
Security and Authorizations
Introduction to Lumira
Using Lumira Prepare
visualize compose data.
ABAP programming for SAP HANA
How SAP HANA affects the ABAP development process
Introducing the ABAP development tools (ABAP in Eclipse)
How to take ABAP to HANA
Using SAP HANA as a secondary database
The various issues in performance and functional aspects encountered in SAP HANA migration
Understanding the ABAP Test Cockpit
Code Inspector
Profiler
Trace and SQL Trace
Improving the performance with SQL performance tuning and monitoring
Guidelines and rules when deploying ABAP for SAP HANA.
Accessing data stored in SAP HANA
What is New Open SQL
Definition of advanced views by deploying Core Data Services in ABAP
Creating CDS associations
How to implement authorization checks using CDS with ABAP
SAP HANA Objects in ABAP
How to consume SAP HANA views using ADBC (ABAP Database Connectivity) and native SQL in ABAP
Using the ADBC and native SQL to consume SAP HANA database procedures.
Advanced Topics Overview
SAP HANA Dynamic tiring
Delta Merge
SDI [Smart Data Integration]
SAP HANA has Application Platform
SAP HANA cloud
L Procedures
R Procedures
Partitioning of tables
Introduction to AFL, PAL, BFL.

Interested in learning SAP HANA?

0 responses on "SAP HANA"

Leave a Message

Your email address will not be published. Required fields are marked *

Course Reviews

4

4
1 ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

© 2018 Schoolfortraining.Powered By Embtelsolutions.com
Note: School for Training is a vocational school. We promise quality education. We do not promise a job.
WhatsApp