Vendors

Course Overview

Course

This course will prepare you to:

  • Develop information models following SAP best practices for maximum performance and flexibility
  • Get started with advanced data processing such as text, spatial, predictive and graph
  • Get started with SQL and SQLScript based modeling
  • Implement security and data access controls around SAP HANA data models
img-course-overview.jpg

What You'll Learn

Course Objectives

Who Should Attend

Who Should Attend

  • Business application consultant
  • Data Consultant / Manager
  • Database Administrator
  • Application developer
  • BI specialist
img-who-should-learn.png

Prerequisites

Prerequisites

Essential

  • HA100 – SAP HANA Introduction

Recommended

  • None

Learning Journey

Coming Soon...

Course Content

Information Views

  • Connect Tables
  • Create Dimension and Cube Calculation Views

Modeling Functions

  • Create Hierarchies
  • Create Calculated and Restricted Columns
  • Filter Data
  • Use Variables and Input Parameters
  • Implement Currency Conversion
  • Create Decision Tables

SQL Script and Procedures

  • Introduce SQL and SQLScript
  • Create Table Functions and Procedures
  • Use the SQL Debug Tools

Virtual Data Models in SAP HANA

  • Use SAP HANA Live
  • Overview of Virtual Data Models built with Core Data Services (CDS)
  • Text, Spatial, Predictive and Graph Modeling

Management and administration of Models

  • Validate Information Models
  • Transport Information Models
  • Rename, copy move models
  • Define schema mapping
  • Convert Deprecated Modeling artifacts using migration tools

Security in SAP HANA Modeling

  • Understand the Key Concepts of SAP HANA Security
  • Define Data Access Security

Optimization of Models

  • Apply Best Practices to Model Design
  • Introduction to Plan Visualizer and Explain Plan tools

Frequently Asked Questions (FAQs)

None

Keep Exploring

Course Curriculum

Course Curriculum

Training Schedule

Training Schedule

Exam & Certification

Exam & Certification

FAQs

Frequently Asked Questions

img-improve-career.jpg

Improve yourself and your career by taking this course.

img-get-info.jpg

Ready to Take Your Business from Great to Awesome?

Level-up by partnering with Trainocate. Get in touch today.

Name
Email
Phone
I'm inquiring for
Inquiry Details

By submitting this form, you consent to Trainocate processing your data to respond to your inquiry and provide you with relevant information about our training programs, including occasional emails with the latest news, exclusive events, and special offers.

You can unsubscribe from our marketing emails at any time. Our data handling practices are in accordance with our Privacy Policy.