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