The SAP HA300 Course is delivered by SAP Subject Matter Experts. Talk to the trainers for course fees and duration

Date/Time: Monday, December 19th, 2016, 4:00pm

Cost:

• Dec 21, 2016 - Jan 13, 2017 - $0.00
• Feb 8, 2017 - April 21, 2017 - $0.00
• Jun 5, 2017 - July 30, 2017 - $0.00

This Course is Based on SAP Software Releases SAP HANA SPS12

New York
Houston
New Jersey

Course Delivery Availability

Check with the Subject Matter Experts
Classroom Training
Live Online Training
Video Stream (Self-Paced)
On-site / On-Job Training
Live Access
Free Live Webinar / Demo

Learning Objectives

HA300 SAP HANA Modelling is prepared to

Develop information models for maximum performance and flexibility

Getting started with

Advanced Data Processing

SQL and SQL Script based modelling

Implement Security and data access controls around SAP HANA Models

What are the Prerequisites?

HA100 SAP HANA Introduction

Target Audience

Application Consultant
Data Consultant
Database Administrator

HA300 SAP HANA Modelling Course Content

1.Information Views1.1. Connect Tables
1.2. Create Dimension and Cube Calculation Views

2. Modelling Functions

2.1. Create Hierarchies
2.2. Create Calculated and Restricted Columns
2.3. Filter Data
2.4. Use Variables and Input Parameters
2.5. Implement Currency Conversion
2.6. Create Decision Tables

3. SQL Script and Procedures

3.1. Introduce SQL and SQL Script
3.2. Create Table Functions and Procedures
3.3. Use the SQL Debug Tools

4. Virtual Data Models in SAP HANA

4.1. Use SAP HANA Live4.2. Overview of Virtual Data Models built with Core Data Services

5. Text, Spatial, Predictive and Graph Modelling

6. Management and administration of Models

6.1. Validate Information Models
6.2. Transport Information Models
6.3. Rename, Copy move model
6.4. Define Schema Mapping
6.5. Convert Deprecated Modelling artifacts using migration tools

7. Security in SAP HANA Modelling

7.1. Understand the Key concepts of SAP HANA Security
7.2. Define Data Access Security

8. Optimization of Models

8.1. Apply Best Practices to Model Design
8.2. Introduction to Plan Visualizer and Explain Plan Tools.

This Course is based on following SAP software Releases

SAP HANA SPS12