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
