Email: info@maxsoftsolutions.com Phone:+91 953 383 7156
SAPHANA Training
Maxsoftsolutions.com SAP HANA online training course will provide the candidates to become familiar with SAP HANA overview and SAP In-Memory Strategy ,IN-Memory sizing Look & Feel of SAP HANA, Administration view, Navigator View, SAP HANA architecture, IMCE and Surroundings, Data Provision and Replication, Loading data into HANA , Modeling-Creating and executing a Data Service Job to Populate HANA, generating Crystal Reports via ODBC/JDBC Connections and User Management by Creation of Role Hierarchy and Assignment of Users to Roles mainly.
About Course
Maxsoftsolutions.com is a popular Online Training centers offering classes to students located at different locations like US, UK, Canada etc by our Real time experts. Join SAP HANA Online Corporate training. You can request for a Demo on SAP HANA Course.
SAP HANA (High- Performance Analytic Appliance) is SAP’s In-memory Database used in order to accumulate data and evaluate the huge quantities of non-aggregated transactional data in practical conditions with unprecedented execution best for making decision support and predictive analysis.
Why learn SAP HANA?
With the advent of SAP HANA, you have the opportunity to build applications that combine business logic and the data base layer with unprecedented performance. SAP HANA is an innovative in-memory relational database management system that increases the application performance, lessen cost of ownership and facilitate to manage huge volumes with much speed and agility. In fact, it adds value to the legacy investments with its real-time interactions surrounding the world’s largest business value chains. All the above factors show that SAP HANA has more benefits when compared to regular relational databases like SQL Server and Oracle.
The Key Objectives of the Course
Upon completion of the SAP HANA course at Maxsoft, you will be able to:
- 1. Understand SAP HANA overview concepts
- 2. Learn SAP In-Memory Strategy
- 3. Analyze In-Memory Computing Studio
- 4. Know about IMCE and Surroundings
- 5. Implement and execute Loading data into HANA
- 6. Learn Automation Levels of Modeling in SAP HANA
Analyze Crystal Reports via ODBC/JDBC Connections
Highlights/ benefits of the Course
We provide lot of benefits to the candidates throughout the course. They comprise:
- Maximum candidate communication with Live –instructor led training facility
- Main to higher level of concept description in an organized and simple manner
- Practical experience with real time case studies and projects
- A 24 * 7 live support to resolve the queries online
- Help in preparation of resume and mock interviews
- Recorded sessions of the training facilitating the candidates to have a straightforward check
SAP HANA Introduction
- In-Memory Computing
- Evolution of In-Memory computing at SAP
- History HANA
- HANA Hardware Sizing
- Product Availability Matrix
- HANA compare to BWA
SAP HANA Overview
- Architectural overview
- Row Store
- Column Store
- Persistency Layer
SAP HANA Versions and Studio overview
- SAP HANA Version
- History of Service packdetails
- Studio Overview
- HANA Studio Preferences
- HANA Studio Prospective
SAP HANA Engines
- Column Store Engine
- Row Store Engine
- Join Engine
- OLAP Engines
- Calculation Engine
SAP HANA Modeling Attribute View
- How to connect tables using
- Inner Join
- Left Outer Join
- Right Outer Join
- Full Outer Join
- Text Join
- Referential Join
- Union
- Filter
- Calculated Column
Analytic View
- Left Outer Join – Attribute View
- Inner Join – Analytical View
- Right Outer Join – Analytical View
- Referential Join – Analytical View
- Calculated Attribute
- Calculated Measure
Tables in HANA
- Column Store Table
- Row Store Table
- Table Type
SQL in HANA
- Basic SQL Knowledge
- Select Statement
- From Clause
- Where Clause
- Group By clause
- Having Clause
- Order by Clause
- Top N clause
SQL Procedure in HANA
- How to create Procedure
- Elements of the Procedure
- Procedures using Column Store Views
- IF-ELSE Logic
- For Loop Logic
- Cursor in HANA
- Dynamic Filter
CE based Script in HANA
- CE_COLUMN_TABLE
- CE_JOIN_VIEW
- CE_OLAP_VIEW
- CE_CALC_VIEW
- CE_JOIN
- CE_LEFT_OUTER_JOIN
- CE_RIGHT_OUTER_JOIN
- CE_FULL_OUTER_JOIN
- CE_PROJECTION
- CE_CALC
- CE_AGGREGATION
- CE_UNION_ALL
Calculation View
- Calculation View Graphical Method
- Calculation SQL Script method
- How to call Calculation view using SQL into Calculation Views
Miscellaneous
- Delivery Units
- Transport Individual HANA Models
- How to load Excel data into HANA using Studio
- Export/Import
- How to create Sequence
- How to create Synonym
- How to create Trigger
- How to create View
Tuning
- Index creation
- Partitioning
- Hash Partition
- Merge Partition
- Round Robin Partition
- Multi-Level Partition
- Table Redistribution
Security & User Management
- Creating Users
- Creating Roles
- Privileges
- Authorization challenges
- User Administration
- Backup & Recovery
- Collecting traces
Data Provisioning
- SAP Data Services extraction
- SAP SLT Replication
- Smart Data Access
- SAP HANA-Direct Extractor Connection (DXC)
SAP Data Services Overview
- What is SAP Data Services
- SAP Data Services Architecture
- SAP Data Services objects (Job, Data Flow, Work Flow, Transformations)
SAP Data Services Extraction
- Loading Data from SAP ECC to SAP HANA DB
- Loading Data from SAP BW to SAP HANA DB
- Loading Data from MSSQL Server DB to SAP HANA DB
- Loading Data from Excel to SAP HANA DB
- How to load data from HANA Information Models to MSSQL DB
SAP SLT Data provisioning overview
- What is SAP SLT
- SAP SLT License options
- SAP SLT system sizing
- SAP SLT system landscape preparation
SAP SLT Schema configuration
- How to configure SLT Schema for SAP Source system
- How to configure SLT Schema for Non-SAP Source system
- No.of Data transfer Jobs configuration
- How to improve Initial data loading
- Tables configuration in SLT using Data Provisioning
SAP SLT Performance tuning technics
- Monitoring Replication in SLT
- Access Plan
- Reading Types
- Adding Entry in the table IUUC_PRECALC_OBJ
- Adding Entry in the table IUUC_PERF_OPTION
- MWBMON
- How to do Partition in SLT
- How to restrict the tables that are allowed for replication
- HANA Supported Data Types
- How to change the standard mapping
Advanced Replication Setting
- How to Edit target table structure
- How to Import and Export transformations
- How to set Reading Types to handle large data tables loads
SAP HANA-Direct Extractor Connection (DXC)
- Create DXC user
- Create DXC Schema
- Setting up DXC connection for SAP Source system
- Loading Data from Excel to SAP HANA DB
- How to load data from HANA Information Models to MSSQL DB
HANA Advanced Analytics
HANA Reporting BO Tools
- How to Connect with IDT
- How to create Universe using HANA Tables
- How to create Webi Reports
- Webi Functions
- How to schedule Webi reports
- How to assign the WebI reports to the End users
HANA Reporting with Crystal Reports 2013
- Report Designer
- Report creation wizard
- Sections
- Sorting and Grouping
- Chart expert
- Formulas
- Sub reports
HANA Reporting with Crystal Reports for Enterprise
- How to Connect HANA with Crystal Reports for Enterprise
- How to create reports
HANA Reporting with SAP Dashboards
- How to Connect HANA with Dashboards
- How to create Dashboard Reports
HANA Reporting with SAP Lumira
- How to Connect HANA with SAP Lumira
- How to Explore HANA Data with Lumira
- Publish Lumira report
HANA Reporting with SAP Design Studio
- SAP Design Studio Overview
- How to create reports
HANA Reporting with SAP Predictive Analysis
- SAP Predictive Analysis Overview
- How to Explore data with Predictive Analysis
BW 7.3 powered by HANA Overview
- BW 7.3 powered by HANA Overview
- BW7.30-HANA Optimized Info Cube
- BW7.30-HANA Optimized Info DSO
- Importing SAP BW7.30 Models into HANA Modeling environment
- Publish Standalone HANA Models into SAP BW 7.30 on HANA
- BW on HANA Migration activities
SAP HANA End to End Mock Implementation Project
- How configure SAP 150 ECC tables using SLT Replication
- How to configure Data loads using SAP Data Services from Oracle DB
- How Create HANA Information models based on Business Requirement
- Creating HANA Models using Combination of multiple Sources
- How to generate SAP BO reports and Assign to End User
- Creating 3 HANA Implementation projects Proof of Concepts
1. Which Case-Studies will be a part of the Course?
We will assist you to work on a real time project case studies on the topics covered to perform data analytics after course completion. Our instructors will assist you in assigning two projects depending on the concepts covered during the course. All the projects will be practical case studies along with corporate training materials, best online training software, and online software training videos which help you to gain experience - become senior SAP HANA consultants ahead.
2. How will I execute the practicals?
We will assist you to set the desired environment for executing the practicals of our classes. We also offer set –up documents in our LMS as per your need. If you have any doubts, 24*7 support will always be available in order to solve your queries online.
3. What if I miss a class?
There is no possibility of skipping or losing our training sessions. If it happens, you can simply select one of the following options given below:
- Learn the recorded sessions of the skipped class through your LMS
- Live batches, access your skipped sessions of any one from the live batches
4. What if I have queries after I complete this course?
We offer 24*7 Support Team all the time for your access. Also, the team will assist you in answering your queries whenever needed i.e. between and after the batch.
5. How soon after Signing up would I get access to the Learning Content?
We will help you to get access to our LMS immediately after your enrolment. Moreover, you will be provided with an absolute record of our earlier training sessions, presentations, PDFs, assignments. You can begin your learning process consequently by accessing our 24*7 support team as well.
6. Is the course material accessible to the students even after the course training is over?
Yes, it is possible. Once your enrolment is done into the respective course category, you can easily access to the course materials, which are available for a period of time.
7. Who is the Instructor?
Our group of instructors are all working experts from the business with 10-13 years of experience associated to different domains. All of them are subject matter experts (SMEs) and are highly trained by Maxsoft to provide a great learning experience to the candidates successfully.
8. Do you provide placement assistance?
Maxsoft is one of the popular online instructor led and corporate training centre operating successfully. Because of our global presence, number of recruitment firms approaches us for student profiles from time to time. We assist our certified students to prepare their resumes, gain real-time experience and offer assistance for preparing interviews as there is a huge opportunities for SAP HANA. However, we can’t promise you with placements but we deliver our course carefully and finish the project so that you will attain very good hands on knowledge to work on a live project.
9. I have recently enrolled but I am unable to continue in the same batch. Can I reschedule it to a future date?
Yes, we will provide privileges for you to register at this instant and postpone your classes in future date as well. However, you can access our website to get detailed information about the upcoming batches.
10. Can I enrol now and take LIVE classes after a month or later?
Yes, you can register in the early bird batches first and may connect the classes shortly.
11.Can I get the recorded sessions of a class from some other batches before attending a live class?
Yes, it is possible. We provide recorded sessions assuring that the concepts highlighted in our classes will be absolutely familiar to you when you will join with your batch. Also, we believe that you will reach to a position to ask the right questions and acquire the information about the course as you would have already completed some homework from your end.
12. When are the classes held and when I will do practicals?
We will help you with your live classes to be conducted on Weekends. Also, we provide practical coursework covering each module which you can perform at your own schedule with the assistance of our 24* 7 proficient support group besides live classes. You will experience a real time project at the end of course completion.
13. What are the system requirements for this course?
The entry level system requirements for this course involve:
- 4GB RAM
- 10 GB Disk space with dual core CPU
14. How much internet speed is required to attend the LIVE classes?
About 1 Mbps of internet speed is needed to continue the LIVE classes. According to our observation, we have come across some candidates continuing the classes even with a very lesser internet speed as well.
15. What are the payment options?
You can pay online by using your Debit Card, Credit Card, or Net Banking service from the outstanding banks. You can use a CCAvenue Payment Gateway to make the payments. You can pay by PayPal for USD payment. Moreover, you can use our existing EMI options depending on your convenience.
16. What if I have more queries?
We will provide you with support Team who will be available online 24*7 for a specific time period. Also, the Team will assist you in answering the issues between and after the batch.