1. Information Views
   • Connect Tables
   • Create Dimension and Cube Calculation Views
2. Modeling Functions
   • Create Hierarchies
   • Create Calculated and Restricted Columns
   • Filter Data
   • Use Variables and Input Parameters
   • Implement Currency Conversion
3. SAP HANA Studio Modeling
4. Virtual Data Models in SAP HANA
   • Use SAP HANA Live
   • Overview of Virtual Data Models built with Core Data Services (CDS)
5. SQL Script and Procedures
   • Introduce SQL and SQLScript
   • Create a Persistence Layer Using CDS
   • Create Table Functions and Procedures
6. Management and administration of Models
   • Work with Modeling Content
   • Create and Manage Projects
   • Overview of classical models migration to Web IDE
7. Security in SAP HANA Modeling
   • Understand the Key Concepts of SAP HANA Security
   • Define Data Access Security
   • Define Roles
8. Optimization of Models
   • Apply Best Practices to Model Design
   • Introduction to Performance and Analysis Tools
9. Overview of Text, Spatial, Predictive and Graph Modeling

Course based on software release: SAP HANA 2.0 SPS 01