Got a question? Call 1800 853 276   |   

HA300 – SAP HANA Modeling

  • Length 5 days
  • Price $6600 inc GST
  • Version HANA 2.0 SPS04
Course overview
View dates &
book now
  • Register interest

Why study this course

This five-day instructor-led course teaches the core capabilities of SAP HANA for modeling, and covers mainly graphical modeling, as well as SQL-based modeling, mainly table functions and procedures, with a focus on performance. It also introduces Core Data Services as a flexible method to model a persistence layer.

The participants will gain knowledge about the management of modeling content in the SAP Web IDE for SAP HANA, and the key principles of object and data access security in a modeling context.

We also provide an overview of advanced data processing in the areas of text, spatial, predictive and graph modeling.

This course is based on software release:

  • SAP HANA 2.0 SPS04

Request Course Information

By submitting an enquiry, you agree to our privacy policy and receiving email and other forms of communication from us. You can opt-out at any time.


What you’ll learn

This course will prepare you to:

  • Develop information models following SAP best practices for maximum performance and flexibility

  • Get started with SQL and SQLScript based modeling

  • Manage projects and modeling content in the Web IDE

  • Implement security and data access controls around SAP HANA data models

  • Get a quick overview of advanced data processing such as text, spatial, predictive and graph


SAP at DDLS

Develop your SAP empowered employees with DDLS. Getting the right skills in place maximises the chance of project success and removes risk. DDLS provides a select range of SAP training courses for SAP S/4HANA, SAP HANA, SAP BusinessObjects and more. DDLS can work with you to navigate the curriculum and help you create a learning plan that will ultimately boost technology proficiency across your organisation.


Stay ahead of the technology curve

Don’t let your tech outpace the skills of your people

Quality instructors and content

Expert instructors with real world experience and the latest vendor- approved in-depth course content.

Partner-Preferred Supplier

Chosen and awarded by the world’s leading vendors as preferred training partner.

Ahead of the technology curve

No matter your chosen technologies or platforms, we can help you stay one step ahead.

Who is the course for?

  • Business application consultant

  • Data Consultant / Manager

  • Database Administrator

  • Application developer

  • BI specialist


Course subjects

Information Views

  • Introducing Information Views

  • Understanding the Different Types of Views

  • Working with Common View Design Features

Using Nodes in Calculation Views

  • Using Projection Nodes

  • Using Join Nodes

  • Working with Data Sets

  • Aggregating Data

  • Creating Cubes with Star Join Calculation Views

  • Extracting Top Values with Rank Nodes

Modeling Functions

  • Create Restricted and Calculated Columns

  • Filter Data

  • Use Variables and Input Parameters

  • Create Hierarchies

  • Implement Currency Conversion

Using SQL in Models

  • Introducing SAP HANA SQL

  • Working with SQLScript

  • Query a Modeled Hierarchy Using SQLScript

  • Creating and Using Functions

  • Creating and Using Procedures

Core Data Services (CDS) in SAP HANA Modeling

  • Defining the Persistence Layer Using CDS

  • Creating Views with CDS

Optimisation of Models

  • Using Tools to Check Model Performance

  • Implementing Good Modeling Practices

Management and Administration of Models

  • Working with Modeling Content in a Project

  • Creating and Managing Projects

  • Enabling Access to External Data

  • Working with GIT within the SAP Web IDE

  • Migrating Modeling Content

Security in SAP HANA Modeling

  • Understanding Roles and Privileges

  • Defining Analytic Privileges

  • Defining Roles

  • Masking Sensitive Data

  • Anonymising Data

Introduction to Advanced Modeling


Prerequisites

Essential

Recommended


THIRD PARTY REGISTRATION

DDLS offers certification and training through our partnership with SAP Inc. This arrangement requires DDLS to provide your details to SAP Inc for course and exam registration purposes.


Terms & Conditions

The supply of this course by DDLS is governed by the booking terms and conditions. Please read the terms and conditions carefully before enrolling in this course, as enrolment in the course is conditional on acceptance of these terms and conditions.



Request Course Information

By submitting an enquiry, you agree to our privacy policy and receiving email and other forms of communication from us. You can opt-out at any time.