SAP HANA Training (Modelling & Administration)

Understand why HANA is fast and what that means for how you design against it.

• Column store versus row store and when each is used
• Compression, dictionary encoding and delta merge
• The index server and other HANA processes
• System database and tenant databases
• Persistence layer: data volumes, log volumes, savepoints
• HANA on-premise versus HANA Cloud
• Sizing basics: memory, disk and CPU
• How S/4HANA uses HANA differently from a data warehouse

Write database code that performs, since pushdown is only an advantage if the SQL is good.

• HANA SQL essentials and data types
• Joins, unions and window functions
• SQLScript: scalar and table variables
• Procedures, functions and their differences
• Imperative versus declarative logic
• Control structures and cursors, and why to avoid cursors
• Error handling in SQLScript
• Debugging and testing SQLScript

Build the reusable models that reporting and applications consume.

• Calculation view types: dimension, cube, cube with star join
• Projection, join, aggregation, union and rank nodes
• Calculated and restricted columns
• Input parameters and variables
• Hierarchies: level and parent child
• Currency and unit conversion
• Model validation and best practice checks
• Migration from attribute and analytic views

Connect HANA models to the S/4HANA world and to the tools that consume them.

• The S/4HANA virtual data model explained
• CDS views versus calculation views: when to use which
• Consuming HANA views from ABAP
• Smart Data Access and virtual tables
• Exposing models to analytics tools
• OData and REST consumption
• Replication basics: SLT and Smart Data Integration
• Data provisioning options compared

Control who sees what, at row level as well as object level.

• Users, roles and the role hierarchy
• System, object, analytic and package privileges
• Analytic privileges for row-level security
• Repository roles versus catalog roles
• Authentication options and single sign-on
• Auditing and audit policies
• Encryption at rest and in transit
• Separation of duties for HANA administrators

Run the database day to day using the tools an administrator lives in.

• SAP HANA cockpit and database explorer
• Starting, stopping and configuring the system
• Configuration parameters and .ini files
• Managing memory, allocation limits and the resident memory
• Workload management and admission control
• Table partitioning and distribution
• Licence management and system replication basics
• Housekeeping: traces, dumps and log volumes

Be the person who can prove the system can be restored, which is the whole point of the role.

• Backup types: complete, delta, differential, log
• Backup catalog and backup destinations
• Recovery scenarios and point-in-time recovery
• Testing a restore properly
• System replication: sync, syncmem and async
• Takeover and failback procedures
• Disaster recovery design considerations
• Backint and third-party backup integration

Find and fix the slow thing, which is what you will be asked to do under pressure.

• Expensive statements trace and SQL plan cache
• Explain plan and plan visualisation
• Common modelling anti-patterns that kill performance
• Delta merge tuning and table load behaviour
• Memory analysis: heap, column store, out-of-memory dumps
• CPU and thread analysis
• Alerts, thresholds and proactive monitoring
• Building a repeatable troubleshooting method