SAP HANA Cloud & Database Development

Master SAP HANA Cloud in this 3-day hands-on training. Learn to provision and manage HANA Cloud instances, build CDS-based data models, create calculation views for analytics, optimize query performance, and integrate with SAP BTP applications.

Training Details


Duration	3 days (24 hours)
Level	Intermediate
Delivery	In-person, Live online, Hybrid

Who Is This For?

Database developers working with SAP HANA Cloud
Application developers who need to model and query HANA databases
Data engineers building analytics on SAP HANA
Architects designing data models for SAP BTP applications
Teams migrating from on-premise HANA to HANA Cloud

Learning Outcomes

After completing this training, you’ll be able to:

Provision and manage SAP HANA Cloud instances
Design CDS-based database schemas and data models
Build calculation views for analytical reporting
Optimize query performance with indexes, partitions, and execution plans
Implement data replication and integration patterns
Monitor and troubleshoot HANA Cloud instances

Detailed Agenda

Day 1: HANA Cloud Fundamentals and CDS Modeling

Module 1: SAP HANA Cloud Overview

HANA Cloud architecture and capabilities
Provisioning and instance management
HANA Cloud Central and administration tools
Connection management and security
Hands-on: Provision a HANA Cloud instance and connect

Module 2: CDS Data Modeling

Core Data Services (CDS) syntax and concepts
Entity definitions, types, and associations
Aspects, annotations, and projections
Namespace management and file organization
Hands-on: Build a complete CDS data model

Module 3: HDI Container Development

HDI (HANA Deployment Infrastructure) architecture
Database artifact types (tables, views, procedures)
Deployment with hdi-deploy
Schema evolution and versioning
Hands-on: Deploy CDS models to HDI containers

Day 2: Calculation Views and Analytics

Module 4: Calculation Views

Calculation view types (dimension, cube)
Node types (aggregation, projection, join, union, rank)
Input parameters and variables
Calculated columns and restricted measures
Hands-on: Build multi-level calculation views

Module 5: Advanced Analytics

Hierarchies (level-based and parent-child)
Currency and unit conversion
Temporal tables and time-travel queries
Window functions and analytics
Hands-on: Create analytic models with hierarchies

Module 6: Stored Procedures and Functions

SQLScript fundamentals
Table functions and scalar functions
Imperative vs declarative logic
Error handling patterns
Hands-on: Write stored procedures for business logic

Day 3: Performance, Integration, and Operations

Module 7: Performance Optimization

Query execution plans and analysis
Index strategies (B-tree, inverted, full-text)
Table partitioning (hash, range, round-robin)
Memory management and column store optimization
Hands-on: Analyze and optimize slow queries

Module 8: Data Integration

SAP HANA Cloud data lake
Smart Data Integration (SDI) and Smart Data Access (SDA)
Replication from on-premise systems
Data federation and virtual tables
Hands-on: Set up data replication and federation

Module 9: Monitoring and Administration

HANA Cloud monitoring views
Memory and CPU usage analysis
Connection and session management
Backup and recovery options
Hands-on: Monitor and troubleshoot HANA Cloud instances

Prerequisites

SAP BTP Fundamentals training or equivalent experience
Basic SQL knowledge (SELECT, JOIN, GROUP BY)
Understanding of relational database concepts
Familiarity with SAP Business Application Studio

Delivery Formats

Format	Description
In-Person	On-site at your company’s location, hands-on with direct interaction
Live Online	Interactive virtual sessions with screen sharing and real-time labs
Hybrid	Combination of on-site and remote sessions, flexible scheduling

All formats include hands-on labs, course materials, and post-training support.