Course Introduction
Watch this video to checkout the details and the benefits you get from this training.
Course Description & Objectives
SAP HANA (High-Performance Analytic Appliance) is an in-memory, column-oriented, relational database management system developed and marketed by SAP. Its primary function as a database server is to store and retrieve data as requested by the applications. In addition to the database management capabilities, it also provides advanced analytics processing, data integration, and application development.
- In-Memory Computing: SAP HANA stores data in RAM instead of traditional disk storage, greatly speeding up data processing times and allowing real-time analytics and applications.
- Columnar Data Storage: Data is stored in columns rather than rows, making it faster to retrieve and aggregate data, which is particularly advantageous for analytical and reporting applications.
- Data Compression: Uses high ratios of data compression to reduce the memory footprint of stored data.
- Advanced Analytics Processing: Supports text, predictive, spatial, graph, and streaming analytics within the database, eliminating the need to move data to separate analytics systems.
-
Multi-model Data Processing: Can handle different models of data within the database, such as relational, graph, and time-series data.
Meet Our Instructor
- SAP Certified Technology Associate - SAP HANA
- SAP Certified Development Specialist - ABAP for SAP HANA (if applicable)
- Additional certifications in related SAP technologies or data management disciplines
- Proficient in SAP HANA SQL and SQLScript, HANA XS Advanced, and HANA Cloud integration.
- Skilled in the design and optimization of HANA information models, including calculation views and stored procedures.
- Expertise in deploying SAP HANA in various environments, including on-premise and cloud platforms.
- Developed and curated comprehensive training programs tailored to various skill levels, from introductory courses on HANA basics to advanced modules on HANA administration and custom development.
- Renowned for a dynamic and engaging teaching style that effectively communicates complex concepts and encourages interactive learning and problem-solving.
- Consistently receives high satisfaction ratings from participants for clarity of instruction, depth of knowledge, and practical application of teaching material.
Course Curriculum
- Lab Activity - Exercise - Access a Calculation View in Performance Analysis Mode
- Lab Activity - Exercise - Audit Information Models and their Dependencies
- Lab Activity - Exercise - Cascade User Prompts
- Lab Activity - Exercise - Clone the SAP HANA Interactive Education (SHINE) Application from GitHub
- Lab Activity - Exercise - Combine Two Data Sources with a Union Nod
- Lab Activity - Exercise - Control Parallelization in a Data Flow
- Lab Activity - Exercise - Control the Behavior of the Aggregation Node
- Lab Activity - Exercise - Create a CUBE with Star Join Calculation View
- Lab Activity - Exercise - Create a DIMENSION Calculation View
- Lab Activity - Exercise - Create a Level Hierarchy
- Lab Activity - Exercise - Create a New Project and an HDB Module
- Lab Activity - Exercise - Create a Parent-Child Hierarchy
- Lab Activity - Exercise - Create a Procedure that is Consumed by an Input Parameter
- Lab Activity - Exercise - Create and Assign an Analytic Privilege
- Lab Activity - Exercise - Create Restricted and Calculated Measures
- Lab Activity - Exercise - Define a Data Source using a Table Function
- Lab Activity - Exercise - Define a Persistence Layer
- Lab Activity - Exercise - Define and Use Filters
- Lab Activity - Exercise - Define Column Masking in a Calculation View
- Lab Activity - Exercise - Implement a Hierarchical Value Help
- Lab Activity - Exercise - Implement Currency Conversion in a Calculation View.docx
- Lab Activity - Exercise - Implement External View for Value Help
- Lab Activity - Exercise - Implement Union Pruning in a Calculation View
- Lab Activity - Exercise - Import, Rename and Copy Models
- Lab Activity - Exercise - Join Three Tables in a Single Join Node
- Lab Activity - Exercise - Prepare Your SAP HANA System
- Lab Activity - Exercise - Read a Hierarchy Structure with SQL
- Lab Activity - Exercise - SAP Create a Cube Calculation View
- Lab Activity - Exercise - Set Up a Project to Access an External Schema
- Lab Activity - Exercise - Use a Minus Node in a Calculation View
- Lab Activity - Exercise - Use Debug Query Mode
- Lab Activity - Exercise - Use Git for Version Control in Your Local Workspace
- Lab Activity - Exercise - Use Rank Nodes to Partition, Order, and Extract Values from a Data Set
- Lab Activity - Exercise - Use Variables and Input Parameters
- Lab Activity - Exercise - Work with SQL Statements
- Configuration Guide - Hana Native Reporting on BW Data
- Configuration Guide - Native HANA
- Configuration Guide - P2047 Sherkat
- Configuration Guide - SAP Agent Deployment Guide - 1
- Configuration Guide - SAP Agent Deployment Guide - 2
- Configuration Guide - SAP Native HANA Best Practices
- Configuration Guide - SAP Native HANA Modelling
- Capstone Project - SAP Native HANA - Integrated Financial Analytics Platform for GlobalCorp Inc.
- Capstone Project - SAP Native HANA - Intelligent Building Management Platform for SmartCity Inc.
- Capstone Project - SAP Native HANA - Intelligent Supply Chain Management Solution for ManufacturingCorp
- Capstone Project - SAP Native HANA - Omnichannel Sales Analytics Solution for RetailGiant
Frequently Asked Questions
When does the course start and finish?
The course is entirely self-paced. You decide when you start and when you finish.
How long do I have access to the course?
That depends on the type of Subscription you bought - Monthly or Yearly. After enrolling, you have unlimited access to this course and materials across any devices you own.
What do I get after I signup?
After you signup and make the payment, you will have full access to the course which includes,
1. Session Videos (these videos are from actual live sessions from the past)
2. Assignments
3. Assessments
4. Lab documents
5. Other pdfs (configuration documents, ebooks, pdfs, interview and certification faqs)
How do I get access to practice on the Server?
Reach out to your Support team and send an email to [email protected] and they will send you the details and the monthly cost for the Server (if available)
Are the videos or materials downloadable?
No, they are not. But you have unlimited access to view them from any device and on this platform depending on your Subscription type. Everything on this platform is the intellectual property of ZaranTech
How soon after I enroll and make payment would get access to the course?
Immediately
What if I have doubts, whom do I ask?
These are pre-recorded videos from the actual Live Training program. Most of the doubts were cleared in the session videos itself. But if you still have any questions, please raise a ticket, and our support team will help you https://bit.ly/support-Ticket
What if I have an issue accessing the course?
You can Raise a ticket by clicking the link below and selecting the appropriate ticket - https://bit.ly/support-Ticket
How will I get my course completion certificate?
Once you have successfully completed the training and the Final Quiz/Assessment, you can avail of your
Certificate of Completion from ZaranTech which you can then showcase on LinkedIn and other Social Media portals
Do you provide Instructor-led Live training for Individuals?
Yes, we do. Email us at [email protected] and we will send you all the details
How we deliver Live training (video) - https://bit.ly/How-we-deliver-training
Do you provide Corporate/group training?
Yes, we do. We have trained more than 200 SAP customers with over 4000 participants in the USA, Canada, Europe, Asia, and South America. We offer corporate training for all SAP modules.
Course Catalog - https://bit.ly/SAP-course-catalog
How we Deliver Corporate Training (video) - https://bit.ly/sap-corp-training
How do I get certified in SAP?
SAP certification (https://training.sap.com/certification/) validates that you possess fundamental knowledge and verified skills.
List of Valid and soon to Expire SAP certifications - https://training.sap.com/certification/validity
What if I am unhappy with the course?
We would never want you to be unhappy! If you are unsatisfied with your purchase, contact us in the first 7 days and we will give you a full refund.
What is your Refund Policy and Terms of Use?
To know more about canceling the enrollment, refund, and rescheduling policy, visit:
Refund and Rescheduling Policy – https://www.zarantech.com/Refund-policy/
Terms of Service – https://www.zarantech.com/terms-of-use/
What other Resources do you provide?
Youtube (Free Videos) - https://www.youtube.com/@zarantechdotcom
LinkedIn (Free materials) - https://www.linkedin.com/showcase/sap-learner-community/
Quora (Ask any Questions) - https://saplearnercommunity.quora.com/
SAP Corporate Course Catalog - https://bit.ly/SAP-course-catalog
What other official Resources from SAP?
Official SAP Training - https://training.sap.com/
Official SAP Certification Programs - https://training.sap.com/certification/
OpenSAP (Open Online Courses (MOOCs) for SAP learning) - https://open.sap.com/
SAP Community blogs with updates and insights - https://blogs.sap.com/
SCN (SAP Community Network) - Discussions and articles - https://community.sap.com/
SAP Conferences and Workshops - https://www.sap.com/products/teched.html