Course Objectives:
By the end of the programme, participants will learn:
HA100
- Understand the key concepts of SAP HANA and in-memory computing
- Create a data model with SAP HANA modeling tools
- Provision and enrich data into SAP HANA
- Run analytics on SAP HANA HA300
- 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 HA301
- Understand and put into practice the main advanced modeling capabilities of
- SAP HANA 2.0 SPS03 in the areas of text search and analysis, graph
- modeling, spatial analysis and predictive modeling.
- Promote these advanced modeling capabilities to extend the core SAP HANA
- Modeling features.
- Broaden your experience with the modern SAP HANA tooling in XS Advanced
- (SAP Web IDE for SAP HANA)
Who Should Attend?
- Business application consultant
- Data Consultant / Manager
- Database Administrator
- Application developer
- BI specialist
Pre-requisite
HA100
- None
HA300
- HA100 – SAP HANA Introduction
HA301
- HA100 – SAP HANA Introduction
- HA300 – SAP HANA Modeling
Course Outlines
HA100
- Describing SAP HANA
- Understanding the Need for a Modern Digital Platform
- Describing how SAP HANA Powers a Digital Platform
- Architecture of SAP HANA
- Outlining Components of SAP HANA
- Working with SAP HANA interfaces
- Understanding Key Features of SAP HANA Database
- Describing High Availability
- Analytical Processing with SAP HANA
- Understanding Core Modeling with SAP HANA
- Understanding SAP Supplied Data Models
- Advanced Modeling with SAP HANA
- Data Management with SAP HANA
- Describing Data Management
- Describing Data Acquisition Tools
- SAP HANA Data Management Suite
HA300
- 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
- SAP HANA Studio Modeling
- 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
- CDS in SAP HANA Modeling
- Defining the Persistence Layer Using CDS
- Creating Views with CDS
- SAP Supplied Virtual Data Models
- SAP HANA Live
- Embedded Analytics and CDS
- Optimization of Models
- Using Tools to Check Model Performance
- Implementing Good Modeling Practices
HA301
- Introduction to Advanced Modeling
- SAP HANA Predictive Analysis Library (PAL)
- Describing SAP HANA PAL
- Using PAL in Flowgraphs
- Calling PAL Functions in Calculation Views
- Calling PAL Procedures in SQL Scripts
- Exploring the PAL Library
- SAP HANA Spatial
- Introducing SAP HANA Spatial
- Working with Spatial Data Types
- Importing and Exporting Spatial Data
- Accessing and Manipulating Spatial Data
- Using Spatial Clustering
- SAP HANA Graph
- Defining SAP HANA Graph Workspace
- Describing the Different Graph Algorithms
- Using the Graph Node in Calculation Views
- Using GraphScript Procedures
- SAP HANA Text
- Understanding Full Text Search
- Understanding Text Analysis
- Understanding Text Mining
- SAP HANA Series Data
- Getting Started with SAP HANA Series Data
