SAP HANA Course

Lesson 1 • SAP HANA System Architecture Overview

Examines the multi-tier HANA architecture including index server, name server, and statistics server. Connects component roles to overall system performance and reliability.

Lesson 2 • HANA Deployment Models

Compares on-premise, cloud, and hybrid HANA deployments and their infrastructure requirements. Helps learners select the appropriate model for given business scenarios.

Lesson 3 • Data Persistence and Storage Layers

Explains how HANA balances in-memory speed with disk-based persistence through savepoints and logs. Grounds learners in data durability concepts critical for production systems.

Lesson 1 • SAP HANA Cockpit Essentials

Covers the web-based Cockpit interface for system monitoring, alerts, and configuration. Complements Studio knowledge with browser-accessible administration capabilities.

Lesson 2 • SAP HANA Studio Perspectives

Introduces the Administration, Modeler, and Development perspectives and their toolbars. Learners map each perspective to specific job roles and daily tasks.

Lesson 3 • SQL Console and Basic Queries

Teaches use of the SQL console within Studio to execute queries and inspect results. Provides the query foundation needed for all data modeling and administration chapters.

Lesson 1 • Patch Management and Upgrades

Outlines the HANA revision and support package lifecycle and the steps for safe upgrades. Learners plan and execute upgrades while minimizing downtime risk.

Lesson 2 • Monitoring and Performance Alerting

Introduces built-in monitoring views, alert channels, and the Statistics Service for proactive management. Prepares learners to detect and escalate system health issues early.

Lesson 3 • Backup and Recovery Strategies

Covers full, incremental, and differential backup types and their scheduling best practices. Connects backup strategy to recovery time and recovery point objectives.

Lesson 4 • System Configuration and Parameters

Teaches modification of ini-file parameters through Studio, Cockpit, and SQL commands. Learners understand parameter layers and how changes propagate across the system.

Lesson 1 • Data Encryption at Rest and in Transit

Teaches volume encryption, log encryption, and TLS configuration for client-server communication. Connects encryption controls to data protection regulatory requirements.

Lesson 2 • Authentication Methods and User Management

Covers database users, LDAP integration, SAML, and Kerberos authentication options. Establishes identity management as the first line of HANA security.

Lesson 3 • Roles, Privileges, and Authorization

Explains system privileges, object privileges, analytic privileges, and role hierarchies. Learners apply least-privilege principles to protect sensitive data objects.

Lesson 1 • Input Parameters and Variables

Covers static and dynamic input parameters and filter variables to make views context-sensitive. Enables learners to build flexible models that adapt to user-driven queries.

Lesson 2 • Building Graphical Calculation Views

Walks through creating projection, join, union, and aggregation nodes in the graphical editor. Learners assemble multi-source models that reflect real business logic.

Lesson 3 • Scripted Calculation Views with SQLScript

Teaches writing SQLScript-based calculation views for logic that cannot be expressed graphically. Bridges graphical modeling skills with programmatic data transformation.

Lesson 4 • View Performance and Optimization

Applies explain plan analysis, partition pruning, and column pruning to improve view execution. Directly prepares learners for production-grade model deployment.

Lesson 1 • Table Functions and Scalar Functions

Teaches creation of table user-defined functions and scalar functions for use in SQL queries. Extends learners' ability to embed custom logic directly within SELECT statements.

Lesson 2 • SQLScript Language Fundamentals

Introduces SQLScript syntax, data types, variable declarations, and control flow constructs. Establishes the programming foundation required for all procedure development topics.

Lesson 3 • Debugging and Testing SQLScript

Uses the HANA Studio debugger and test scripts to validate procedure correctness and performance. Builds quality assurance habits essential for production deployments.

Lesson 1 • Application Deployment and Lifecycle

Guides packaging, deploying, and updating multi-target applications on the XSA platform. Prepares learners for continuous delivery workflows in enterprise projects.

Lesson 2 • OData Services with CDS and XSOData

Teaches defining OData v2 and v4 services over HANA data using CDS annotations and XSOData files. Connects data models to consumable REST APIs for front-end applications.

Lesson 3 • HDI Containers and Deployment Artifacts

Covers the HANA Deployment Infrastructure container model and its artifact types for schema management. Learners automate schema deployment using HDI plugins and build files.

Lesson 4 • XS Advanced Runtime Architecture

Explains the XS Advanced application server, its microservice model, and the role of the UAA service. Provides the platform context needed before writing any XSA application code.

Lesson 1 • Partitioning and Table Distribution

Explains range, hash, and round-robin partitioning strategies and their impact on parallel query execution. Learners design partition schemes that align with query access patterns.

Lesson 2 • Predictive Analytics with PAL and APL

Introduces the Predictive Analysis Library and Automated Predictive Library for in-database machine learning. Learners execute classification, regression, and clustering algorithms on HANA data.

Lesson 3 • Memory Management and Workload Classes

Covers memory pool configuration, workload class assignment, and resource group management. Learners balance competing workloads to maintain consistent system throughput.

Lesson 4 • Query Optimization and Execution Plans

Teaches systematic use of explain plans, plan visualizer, and SQL analyzer to diagnose slow queries. Learners apply targeted rewrites and hints to achieve measurable speed improvements.