SAP HANA is an in-memory data platform that is deployable as an on-premise appliance, or in the cloud. It is a revolutionary platform that’s best suited for performing real-time analytics, and developing and deploying real-time applications.

HANA is a realization of Hasso Plattner’s idea of a single in-memory columnar database for OLTP and OLAP workloads. He believed that if a database could be built with a Zero response time, so that business applications would be written fundamentally differently – and IT landscapes could be simplified.

SAP HANA supports an X86 Architecture,compatible with SAP product suites and  also supports other database applications as well.

SAP HANA transforms application services. Quickly prototype, validate, build, and deliver smart and modern applications using flexible development and deployment tools – in the cloud or on premise.SAP HANA transforms analytic intelligence. Use advanced data processing for business, text, spatial, graph, and series data in one system to gain unprecedented insight and deliver deeper insights using powerful Machine Learning and Predictive Analytics capabilities.

About the Course

This SAP HANA online training will ensure you get a good grasp of SAP HANA fundamentals, learn and deploy real-time analytics. HANA is an on-premise application that is used for gathering real-time insights. In this SAP HANA training, you will learn about SAP HANA Studio, Modeling, Security features and various other aspects. You will understand why SAP HANA is a fundamentally different database engine upon completion of this SAP HANA course.

Why takes this Course?

SAP HANA is one of those platforms that will find much demand form enterprises around the world due to its result- oriented approach to getting work done. This SAP HANA training certification course gives you hands-on experience and knowledge in one of the most sought-after technologies in the cloud, Big Data, and analytics environment. This SAP HANA training is your road to getting high paying jobs in the technology industry.

  • The basic database product, SAP HANA, currently has more than 6,400 customers
  • SAP HANA consultant in the United States can earn $115,000 –
  • 33 Hrs of highly interactive instructor led training OR
  • 20 Hrs of Self-Paced sessions with Lifetime access
  • 30 Hrs of real-time projects after every module
  • Lifetime access
  • Lifetime 24*7 technical support and query resolution
  • Get global industry recognized certifications
  • Job assistance through 50+ corporate tie-ups

Course Curriculum

Approaching SAP HANA
Introduction to In-Memory Computing – Fundamentals of SAP HANA 00:00:00
What SAP HANA Can do, What SAP HANA Can’t do. 00:00:00
High Performance functionalities in SAP HANA – In- Memory computing 00:00:00
Columnar store database 00:00:00
Massive Parallel Processing 00:00:00
Data Compression 00:00:00
SAP HANA for Non-SAP Use Cases – SAP HANA for Non – SAP Analytics 00:00:00
SAP HANA for Non-SAP Applications 00:00:00
SAP HANA Database Architecture 00:00:00
SAP HANA Landscapes and Scenarios 00:00:00
Introduction to HANA Studio
Add SAP HANA System – Perspectives, Administration, Modeling, Development Plan Viz. Folders- Catalog, Content, Provisioning, Security 00:00:00
SAP HANA Database SQL Script – HANA Database SQL Basics 00:00:00
Types of statements, data types, operators, expressions, basic query execution, Sub-query, Joins, Expressions, Loops, Sub-queries 00:00:00
Catalog – Schema, Table, Views, Functions, Stored Procedures, Index, Synonyms, Sequences, Triggers 00:00:00
Provisioning – SDA [Smart Data Access] 00:00:00
Security – Users, Roles 00:00:00
SAP HANA Modeling
Introduction 00:00:00
Types of Models 00:00:00
Attribute Views 00:00:00
Joins Using Filter Operations 00:00:00
Creating Restricted & Calculated Columns Using Hierarchies 00:00:00
Analytic Views 00:00:00
Star Schema design 00:00:00
Multi-Dimensional modeling Using Variables 00:00:00
Input parameters 00:00:00
Advantages & Limitations 00:00:00
Calculation Views (GUI)
Dimension Calculation View 00:00:00
Star Join Calculation view 00:00:00
OLTP Calculation view Using Projection 00:00:00
OLTP Calculation view Using Join 00:00:00
OLTP Calculation view Using Aggregation 00:00:00
OLTP Calculation view Using Union 00:00:00
OLTP Calculation view Using Rank 00:00:00
Calculation Views (Scripted) 00:00:00
CE functions Introduction 00:00:00
Creating Content Procedure 00:00:00
Analytic Privileges
Classical Analytic Privileges 00:00:00
SQL Analytic Privileges 00:00:00
Dynamic analytic Privileges 00:00:00
Turning Business Rules into Decision tables 00:00:00
Table Functions 00:00:00
In-Depth Modeling
Union Pruning 00:00:00
Refactoring information models 00:00:00
Schema Mapping 00:00:00
Propagate to schematics 00:00:00
Show Lineage 00:00:00
Find Where used Schema Mapping 00:00:00
Generating Time Data 00:00:00
Using Time Travel 00:00:00
Migrating deprecated Information models 00:00:00
Using Currency Conversion. Web-based Modeling 00:00:00
Advanced HANA SQL script -Temporary tables, Triggers, Exceptions Handling. 00:00:00
Full-Text Search
Overview, Datatypes & full-text Indexes 00:00:00
Using the Full-text search 00:00:00
Application Life Cycle Management – Transport Using Developer mode 00:00:00
Transport Using Delivery Unit mode 00:00:00
Change management 00:00:00
Analyzing Query Performance- Explain Plan, Visualize plan, Performance trace 00:00:00
Data Provisioning
Data Provisioning – Data provisioning using SLT 00:00:00
Data Acquisition with BODS 00:00:00
Data Provisioning with Flat File upload 00:00:00
Extractor Connection 00:00:00
Security and Authorizations 00:00:00
Introduction to Lumira, Using Lumira Prepare, Visualize compose data 00:00:00
Advanced Topics Overview
SAP HANA Dynamic tiring, Delta Merge 00:00:00
SDI [Smart Data Integration] 00:00:00
SAP HANA has Application Platform 00:00:00
SAP HANA cloud 00:00:00
L Procedures 00:00:00
R Procedures 00:00:00
Partitioning of tables 00:00:00
Introduction to AFL, PAL, BFL 00:00:00
Project Work
Project 1: Develop reports using SAP HANA 00:00:00
Project 2: Using HANA Studio to improve manufacturing 00:00:00
Project 3: Aerospace Company needs to streamline aircraft design 00:00:00
Project 4: Telecommunications Company wants to optimize revenue per user 00:00:00

Course Reviews


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

No Reviews found for this course.

  • $499
  • 10 Days

    Get a Free Consultation

    Related Courses

    Copyright © 2019 Certybox All Rights Reserved