SAP HANA course for Intermediate trainees by Red Coin Technologies

Introduction
History and Fundamentals of Data-warehousing in Depth.
Star Schema And Extended Star Schema Techniques.
Clear picture on OLTP and OLAP systems

Introduction to SAP HANA
SAP In-Memory Strategy
HANA compare to BW
Architecture
Architecture Overview
IMCE and Surroundings (In memory Computing Engine)
Row Store & Column Store
Installation and deployment scenarios

Navigation
Introduction to HANA Studio
HANA Administration Prospective
Modeler Prospective
System monitoring.

LT (Landscape Transformation) OR Trigger Based Replication
Remote Function Calls
Creating RFC Destinations in SAP ABAP
Replicating SAP tables from OLTP Server using Trigger based Replication
Real time Replication
Job Scheduling and monitoring.
Parallel and Multi-Thread processing.

SQL Scripts
Data Types
Table Creation, Modification, Updating and Deletion operations.
SQL Select Statements
Joins and Unions
String Operations
Stored procedures
Table Functions
CE (Calculation Engine) Functions.
Aggregations and lot more.

Modelling
Applying star schema technique in SAP HANA
Attribute Views
Calculated Columns
Hierarchies
Time Data Generation
Analytic Views
Variables & Input Parameters
Calculated & Restricted Columns
Currency & Quantity Conversions
Calculation Views
Star Joins, Cubes & Dimensions
SQL Script based Views
Calculation Engine Functions Depth.

HANA -ETL Replication Methodology
BODS (Business Object Data services)
HANA As a Central Repository
JDBC & ODBC connectivity.
Replicating data from SAP OLTP Server Using BODS
Replicating data from Flat File Source systems
Replicating data from BI System
Backward replication technique.
Bulk Load & Scheduling
Extracting ECC data using BW Extractors
Scheduling Stored Procedures

Transformations using BODS
Merge Transform
Pivot & Reverse Pivot Transformations
SQL Transformation
Key Generation Transform
Validation Transform
Case Transform

Real time scenarios
Project development in SAP HANA Development perspective
Capturing the changes in Delivery unit
Basics of XSJS and ODATA service to expose the data to front end
Real time issues which you can come across during actual project development
Newly supported features with HANA SP10