SAP Certified Application Associate – SAP HANA 2.0 (SPS04)

SAP HANA Introduction

  • Course Code: HA100 (SAP HANA 2.0 SPS04)
  • Duration: 2 Days

Course Information

  • 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 the SAP HANA Database
    • Describing High Availability
  • Analytical Processing with SAP HANA
    • Understanding Core Modeling with SAP HANA
    • Advanced Analytics with SAP HANA
  • Data Management with SAP HANA
    • Data Tiering
    • Describing Data Acquisition Tools
  • Developing and Running Applications on SAP HANA
    • Running SAP Enterprise Suites on SAP HANA
    • Connecting SAP Business Intelligence Tools to SAP HANA
    • Outlining SAP Business Warehouse on SAP HANA
    • Developing SQL Data Warehouses with SAP HANA
    • Building Native HANA Applications
  • This course will enable you to:
    • Understand the key concepts of SAP HANA
    • Work with the various SAP HANA interfaces used by developers and administrators
    • Create a data model using SAP HANA modeling tools
    • Acquire and enrich data and load to SAP HANA
    • Build a report that runs on an SAP HANA data model
    • Get started with the application development environment
  • Application Consultant
  • Change Manager
  • Business Analyst
  • Application Developer
  • BI / BW consultant
  • Data Scientist
  • Database Administrator
  • SAP HANA Project Manager
  • SAP HANA Support Staff

Essential

  • None

Recommended

  • Basic understanding of business IT

SAP HANA 2.0 SPS04 – Modeling

  • Course Code: HA300 (SAP HANA 2.0 SPS04)
  • Duration: 5 Days

Course Information

  • 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
  • CDS in SAP HANA Modeling
    • Defining the Persistence Layer Using CDS
    • Creating Views with CDS
  • Optimization 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 Manage 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
    • Anonymizing Data
  • Introduction to Advanced Modeling
  • 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
  • Business application consultant
  • Data Consultant / Manager
  • Database Administrator
  • Application developer
  • BI specialist

Essential

  • HA100 – SAP HANA Introduction

Recommended

  • HA150 – SQL and SQLScript for SAP HANA

SAP HANA 2.0 SPS04 Advanced Modeling

  • Course Code: HA301 (SAP HANA 2.0 SPS04)
  • Duration: 3 Days

Course Information

  • 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
  • This course will prepare you to:
    • Understand and put into practice the main advanced modeling capabilities of SAP HANA 2.0 SPS04 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)
  • Business application consultant
  • Data Consultant / Manager
  • Database Administrator
  • Application developer
  • BI specialist

Essential

  • HA100 – SAP HANA Introduction

  • HA300 – SAP HANA Modeling

Recommended

  • HA150 – SQL and SQL Script Basics for SAP HANA

SAP Learning Hub Solution Edition includes:

  • This edition offers 12 months access to:
    • Visual Learning Journey guides illustrating recommended paths to solution competency.
    • Self-paced digital learning content for digital platforms in various formats and languages, including e-learning courses, e-books, knowledge assessments.
    • SAP expert-led live sessions and peer-to-peer learning experiences in solution specific SAP Learning Rooms.
    • 60 hours of access to SAP training systems for hands-on practice in SAP Live Access.
    • Two online exam attempts for SAP Global Certification.
    • Access to solution-specific stay current learning content and assessments to keep learners’ skills up-to-date and SAP Global Certifications valid with every release of the respective cloud solution.
    • 1 day overview + 2 days coaching

Course Details

  • Course Title: SAP Certified Application Associate – SAP HANA 2.0 (SPS04)
  • Module: HANA
  • Course Code:
    • HA100 (SAP HANA 2.0 SPS04)
    • HA300 (SAP HANA 2.0 SPS04)
    • HA301 (SAP HANA 2.0 SPS04)
  • Exam Code: C_HANAIMP_16
  • Method: Classroom, Virtual or On-Demand
  • Certification Body: SAP