MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

SAP HANA Certification Training

Course Summary

Intellipaat SAP HANA certification training course lets you master SAP HANA. We provide the best online classes to help you learn in-memory database, HANA Studio, Modeling, real time analytics. Work on real world projects.


  • +

    Course Syllabus

    SAP HANA Course Content

    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 (Cont.)
    Data Provisioning using Direct, Extractor Connection, Security and Authorizations, Introduction to Lumira, Using Lumira Prepare, Visualize compose data.
    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.
    SAP HANA Project
    Project –Develop reports using SAP HANADataset – SalesThis project is involved with creation of reports using SAP HANA. You will get in-depth understanding of creating SAP HANA reports with SAP Business Objects explorer, learning to deploy different SAP HANA views like attribute, analytic and calculation views, understanding how to create SAP HANA Crystal Report, deploying MDX Provider for connecting HANA system to Excel data, data modeling techniques. Upon completion of the project you will gain expertise to develop reports from multiple data sources and view it to glean valuable insights.


Course Fee:
USD 172

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

Attended this course?

Back to Top

 
Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url