Sap Hana Course Outline

Sap Hana Course Outline

Introduction

SAP HANA [High-Performance Analytic Appliance] 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 the best suited for performing a real-time analytics, developing and deploying real-time applications. At the core of this real-time data platform is the SAPHANA database which is fundamentally different than any other database engine in the market today (figure) SAP HANA Training

Whenever companies have to go deep within their data sets to ask interactive questions, and have to go broad (which means working with big data sets that are of different types and from different sources) at the same time, SAP HANA is well-suited. Increasingly there is a need for this data to be recent and preferably in real-time. Add to that the need for high speed (very fast response time and true interactivity) and the need to do all this without any pre-fabrication (no data preparation, no pre-aggregates, no-tuning) and you have a unique combination of requirements that only SAP HANA can address effectively. So we can say SAP HANA is thePlatform for Next-Generation Applications and Analytics.

Content

HANA 100 & HANA 300 Course Content:

SAP HANA 100 Certification Syllabus

Introduction

• Introduction to SAP HANA
• SAP HANA In-Memory Strategy
• HANA Compared to BWA

Look and feel

• In memory Computing Studio
• Administration views
• Navigator View
• System View
• Information Modeler
• -Architecture
• Architecture Overview
• IMCE and surroundings
• Row Store
• Column Store
• Loading data into HANA
• Data Modelling
• Reporting
• Persistent Layer
• Back & Recovery

Data Provisioning

• Replication Server
• Replication process
• Replication Architecture
• Data services
• SAP BODS and HANA.
• Basic Data service connection types
• New to Data Services 4.0
• Full Extractor through ODP.
• Configure Import server
• Create and execute a Data service job to populate HANA.

Modelling

• Purpose of information Modeler.
• Levels of modelling in SAP HANA.
• Attribute Views
• Calculation Views
• Export & Import

Reporting

• HANA Reporting Layer.
• Connectivity options.
• Business Objects BI 4.0
• Business Objects BI 4.0 Explorer
• Business Objects BI 4.0 Enterprise
• Crystal reports via ODBC/JDBC Connections
• Others & MS Excel

User Management

• Creation of Users
• Creation of Roles
• Creation of Role Hierarchy
• Assignment of users to roles
• Authentications
• IMCE Authorizations

SAP HANA 300 Certification Syllabus

DATA PROVISIONING USING SLT

• Positioning and key concepts
• Overview on configuration Aspects
• Data Replication at a glance.
• SLT based transformation concepts.
• Selective Data Replication.
• Transformation of Data.
• Extension of (target) table structure.
• Specific Considerations.

Approaching SAP HANA Modeling

• Persistency Considerations
• SAP HANA Engine Overview
• Choosing views for the information Model.

Connecting Tables

• How to connect tables Using:
• Inner Join
• Left Outer Join
• Right Outer Join
• Full Outer Join
• Text Outer Join
• Referential Join
• Union

Advanced Modelling

• Creating Attribute Views.
• Using Hierarchies.
• Creating Restricted & calculated Measures.
• Using Filter Operations
• Using Variables
• SAP HANA SQL – Introduction.
• SQL Script and Procedures
• Using Currency Conversion.

Processing Information Models

• Validating Models
• Comparing Versions of Information Objects
• Checking Model References
• Generating: Auto Documentation.

Managing Modelling Concepts

• Schemas
• Import & Export
• Copying Objects

Security and Authorizations

• User Management & Security
• Types of Privileges
• Template Roles
• Administrative

For SAP ERP Training or SAP  HANA Module Training please visit the links.