Facebook Recommendations

Student Certifications

Training Details

Course Duration: 45-50 hours Training + Assignments + Actual POC’s

Training Materials: All attendees will receive,

  • Assignment after each module, Video recording of every session
  • Notes and study material for examples covered.
  • Access to the Training Blog & Repository of Materials


  • Any person with SAP BASIS prior experience or any DBA has experience working as database administrator on any database.

Who Should Join this Training:

  • Someone who is looking for a career in SAP HANA ADMIN
  • Someone who is a SAP Consultant and wants to add SAP HANA ADMIN skills.

Training Format:

This course is delivered as a highly interactive session, with extensive live examples. This course is Live Instructor led Online training delivered using Cisco Webex Meeting center Web and Audio Conferencing tool.

Timing: Weekdays and Weekends after work hours.

Training Highlights

  • Data Provisioning using SAP Landscape Transformation (SLT)
  • SAP HANA Pre & Post Installation
  • Monitoring and Troubleshooting
  • Backup & Recovery
  • Software Lifecycle Management
  • SP9 new Features Overview
  • SAP HANA Admin Certification Guidance
  • Administration and Operations in SAP HANA

ZaranTech SAP HANA Training Roadmap

How are we Different from other Training Institutes?

Role-specific training instead of Product-based training – We are the leaders in providing **Role-Specific training and e-learning solutions for individuals and corporations. Our curriculum are based on real-time job functions as opposed to being product-based. Real-time scenarios and troubleshooting techniques shown in class.
(**Role based training – Here our trainers share their real-time implementation experience in the class. The trainer will work with participant on several Case Studies based on a actual projects. This gives the participant an understanding of how things are accomplished in real-time environment. The idea is to get the participant familiar of the process, real-time.)

Longer Course Durations – We provide students with more detailed training with Assignments based on the real-time scenarios as well as case studies so that the students take away relevant experience in their respective platform.

We offer Training Blogs using Google Site – The Training Blogs are a common platform for both the trainer as well as the trainees to interact with, discuss queries with the trainers, upload assignments and referring assignments. Training Blogs helps the student to attend the sessions anywhere, anytime, using laptop, desktop or tabs/palmtops.

We provide study materials using Google Drive –We provide access to a Repository of materials for training using Google Drive Cloud. The students are given access to their respective modules using Google Drive for which they have access for lifetime and can be accessed anywhere any time.

For our SAP Trainings –We offer the longest duration of Courses in SAP as compared to any other training institute out there. Our SAP training programs are very detailed. Integration with other SAP modules is covered as a part of our training programs.

Never miss a session – We video record every online training sessions and post the Video recording on the training Blog after the session. So if a students misses a Live Online session, the Video is always available on the Blog. Other students can always go back to these video recordings for review purpose or just to go over.

Highly Qualified and Well Experienced Trainers – Our Trainers are highly qualified and are well experienced in their respective domains. We have trainers from USA, Canada, Australia, Singapore and many other countries.

Case Studies and Assignments Based on Real Scenarios – The Case Studies and Assignments assigned to the students are based on real-time scenarios out the Trainers Past Projects they were involved in.

Certification Assistance – During and at the end of training, the Sr. trainer will provide Certification questions and answers to help you clear the Certification (if required). They will guide each student the required Certification program as well as they themselves are Certified. Every student also receives a ZaranTech Training Completion Certificate as well.

Career Counseling – If you are New to IT and want career counseling to help you decide which stream to go into, please click the link, and fill out the Career Counseling form and one of our counselors will get in touch.

Placement Assistance – Our “After the training” team can also help you with Resume prep guidance, Interviews questions and Mock interviews after your training is complete.

Modules Covered in this Training

In this training, attendees learn:
Module 1. SAP HANA Landscape
Module 2. SAP HANA Architecture
Module 3. SAP HANA Tools Overview
Module 4. SAP HANA Pre & Post Installation
Module 5. Renaming HANA DB using HDBRENAME Tool
Module 6. Administration and Operations in SAP HANA
Module 7. Backup & Recovery
Module 8. HANA Security
Module 9. Data Provisioning using SAP Landscape Transformation (SLT)
Module 10. Configure data replication with SAP Data Services
Module 11. Configure Direct Extraction Connector (DXC)
Module 12. Monitoring and Troubleshooting
Module 13. Software Lifecycle Management
Module 14. SAP HANA SP9 Overview and Updates

Attendees also learn:
1. Resume Preparation Guidelines and Tips
2. Mock Interviews and Interview Preparation Tips

Topics Covered

SAP HANA Landscape

  1. Introduction to SAP HANA
  2. SAP HANA Components
  3. SAP HANA Scenarios
  4. Rapid Deployment Solutions RDS
  5. SAP HANA Information Sources

SAP HANA Architecture

  1. SAP HANA Persistence
  2. Sizing SAP HANA
  3. SAP HANA Scale Out

SAP HANA Tools Overview

  1. SAP HANA Studio
  2. DBA Cockpit

SAP HANA Pre & Post Installation

  1. Preparing SAP HANA Installation
  2. Review SAP HANA Installation
  3. Post-Installation Steps
  4. Auditing

Renaming HANA DB using HDBRENAME Tool
Administration and Operations in SAP HANA

  1. Starting and stopping SAP HANA
  2. Configuring SAP HANA
  3. Periodic Manual Tasks
  4. Enabling high availability of SAP HANA

Backup & Recovery

  1. Concept of Backup and Recovery
  2. Data Area Backup
  3. Log Area Backup
  4. Backup of Configuration Files and Backup Catalog
  5. Recovery
  6. Database Copy
  7. High Availability

HANA Security

  1. Maintaining Users and Authorizations
  2. Creating Users
  3. Creating Roles
  4. Types of Privileges
  5. Working with Analytic Privileges
  6. Standard Roles
  7. Administrative Tasks
  8. Authentication Methods
  9. Information Sources for Administrators and Auditing

Data Provisioning using SAP Landscape Transformation (SLT)

  1. Concepts of SLT
  2. Positioning and Key Concepts
  3. Installation Procedure of SLT
  4. Step by step configuration of SLT
  5. Landscape Strategy and Sizing Aspects
  6. Data Replication at a Glance
  7. Monitoring of Replication

Configure data replication with SAP Data Services

  1. Concept of BODS
  2. Step by Step configuration of BODS
  3. Uploading Data into HANA from SAP Sources

Configure Direct Extraction Connector (DXC)

  1. Step by Step Configuration

Monitoring and Troubleshooting

  1. Monitoring with SAP HANA Studio
  2. Monitoring with DBACOCKPIT
  3. Remote Support
  4. SAP Early Watch Alert

Software Lifecycle Management

  1. Updating SAP HANA
  2. Updating SAP HANA Studio
  3. Transporting Changes

SAP HANA SP9 Overview and Updates

  1. Discuss about New Features in SAP HANA SP9

Certification Guidance

About Trainer Eliaz:

  • More than 16+ years of Consulting & Teaching experience in different modules of SAP BW versions (2.0B, 2.1, 3.0B, 3.1C, 3.5, BW 7.0 NW 2004S, BW 7.3, BW 7.4), BPC, CRM (5.0, CRM2007), SD, ABAP/4. Primarily SAP BI with SAP Business Objects.
  • SAP 7+ year of Consulting & Teaching Experience with SAP BO BI XI R2, SAP BO BI XI 3.0, XI 3.1, BO BO 4.0, SAP BO BI 4.1(BI) SAP BODS 4.0, 4.1 (EIM) SAP BO PC 7.0, 7.5, 10 NW version (EPM)
  • 3 Years of Experience with SAP HANA (1.0 SPS2, SPS3, SPS4, SPS4, SPS6) HANA Certified in 1.0 SPS6 Completed 2 POC Projects, currently working in SAP HANA Projects.
  • With a strong back ground in training and deep knowledge of the core subject and techniques on getting certification successfully completed many batches in US and Canada.
  • Trained over 3000 students and 80% of the students accomplished in getting certification in various modules.
  • Taught more than 50 BW/BI batches in various versions 2.X, 3.0B, 3.1, 3.5, BI 7.0 NW 2004S,BW 7.4 in US and Canada for major Consulting Companies like CGI, DELLOLITE, etc..

CASE STUDY # 1 – “Creation of HANA Schema for SALES”

Creation of HANA Schema from scratch (Sales Domain):

In this Case study we will be creating a SAP Schema from scratch for Sales Domains. This Case Study also illustrates different types of challenges you will face while designing the HANA schema, importing the tables.


  • Designing HANA schema
  • Designing SAP BODS 4.2 Dataflows to load the data to HANA
  • Troubleshooting
  • Creating Attribute Views, Analytical Views and Calculation Views
  • Reporting – Generating Sales reports using BI 4.1 reporting tools and MS Excel
  • Example Reports are Sales Order Header, Item Level, Scheduling level and Sales Overview reports

CASE STUDY # 2 – “Creation of HANA Schema for FINANCE”

Creation of HANA Schema from scratch (Finance Domain):

In this Case study we will be creating a SAP Schema from scratch for Finance Domains. This Case Study also illustrates different types of challenges you will face while designing the HANA schema, importing the tables.


  • Designing HANA schema
  • Designing SAP BODS 4.2 Dataflows to load the data to HANA
  • Troubleshooting
  • Creating Attribute Views, Analytical Views and Calculation Views
  • Reporting – Generating Finance reports using BI 4.0 reporting tools and MS Excel
  • Example Reports are Balance Sheet Reports, Income Statements, Consolidated Income Statements, P&L Reports

How to be a certified SAP HANA certification?

Certification for SAP HANA can be attained by the aspirant in the following steps:
Step 1: Once training is over, Registration must be done for C_TADM53702 exam.
Step 2: Complete the exam and hence you shall be certified.

What are the requirements for the certification?

Degree in finance is desired along with the basic understanding of the concepts and functionalities of SAP shall be an advantage. Functional experience in marketing management is also desired for the candidate.

What are the pattern for the exam and the duration for the test?

The examination would consist of 80 multiple choice questions, the duration for the examination is 180 minutes and the passing score is 62%.

Technical Requirements to take an Online training with ZaranTech

Technical Requirements for ZaranTech Online Classes:

  • Operating System: Windows XP or newer
  • Browser: Internet Explorer 6.x or newer
  • CPU: P350 MHz, recommended P500+ MHz
  • Memory: 128 MB, recommended 256+ MB RAM
  • Free Disk Space: 40 MB, recommended 200+ MB for content and recordings
  • Internet Connection: 28.8 Kbps, recommended 128+ Kbps
  • Monitor: 16 bit colors (high color)
  • Other: Sound card, microphone, and speakers OR headset with microphone

Why is SAP HANA fast?

SAP HANA is fast for the following reasons:
a) HANA stores information in electronic memory as compared to regular RDBMS technologies that store information on hard disks.
b) Besides, most SAP systems have the database on one system and a calculation engine on another,and they pass information between them. With HANA, all this happens within the same machine.

Can you have row store tables in SAP HANA?

HANA can have column or row stores; there is no technical limitation. If you have row-store table in HANA, you cannot create any column views(Modelling views) on top of thoserow store tables. Typically, Metadata or system tables or rarely accessed data is stored in a row-store format.

How do you decide if the table should be row or column store in your project?

If you want to populate the tables with huge amounts of data that should be aggregated and analyzed fast and benefited from compression mechanisms, then column store is a better option. If you want to report on all the columns, then row store is more suitable.Simple rule of thumb in HANA is ‘use a column table unless specified.

Which are the two relational engines in In-Memory Computing Engine (IMCE)?

The two relational engines in IMCE are:
a) Row store
b) Column store
Both row store and column store are in-memory databases.

Define SAP HANA?

SAP HANA is a S/w and H/w solution by SAP, which is an In-Memory platform, that combines database, data processing, and application platform capabilities in-memory. The platform provides libraries for predictive, planning, text processing, spatial, and business analytic.

What is the Difference between Live training and Video training?

These Videos here will help you understand the difference,
VIDEO – What is Instructor led LIVE Training –
VIDEO – What is Instructor led VIDEO Training –

Benefits of online training as compared to classroom training

Online Training Benefits
A constantly shifting and changing IT market requires IT professionals to do more with less, making use of new tools and solutions to move forward. Investment in learning and development enables growth in our changing information technology marketplace, giving you the knowledge and skills to act, behave, and perform your job differently. Instructor-led Online training can provide the learning solutions you need in a format that is cost-effective and convenient bringing the interactivity, expertise, and diverse curriculum of our traditional courses to your home or office utilizing state-of-the-art technology. This method of learning allows for live interaction with the trainer and fellow students, without the cost of travel or lodging expenses. To accommodate the demanding schedules of professionals that is trying to do more with less.

Some of the major benefits are :

  1. Full Interactivity –
    Two-way voice over internet and web-conferencing using Cisco WebEx Meeting Center tool. This tool enables participants to ask questions and collaborate with each other in an online virtual space and enables the online trainer to answer questions, take simulations, and receive answers instantaneously. Every trainee can view the trainers desktop and vice versa.
  2. Cost Savings and Convenience –
    Courses can be completed from home, the office, or wherever the Internet is accessible. There is no need to travel to a specific location to attend a training program. Less overhead cost for the company and the savings is passed on to the trainees. Shorter course schedules mean that projects don’t have to be put on hold while participants train (for corporations).
  3. Never Miss a Session –
    With online training, you can receive archived video recorded sessions to all enrollees and the streaming video recording links are posted on the Training blog after each session. Participants may view these sessions to review sessions post-class or make up a missed class as needed. Accesses to Video Recordings are available after the training end thus making it easy for you to review after training ends.
  4. Location Independent –
    You may join for an online instructor-led course from any part of the world without having to travel. Trainees can attend from USA, Canada, New Zealand, UK, Australia, India and many other countries around the world.
  5. Affordable –
    Classroom sessions are expensive. You pay for Hotel, Food, Travel plus Course Fees. All those overhead costs quickly add up to more than 5,000 dollars. Online training programs costs less and is a fraction of that cost of classroom training.
  6. Career Focused –
    The online IT training courses match the tasks, assignments or projects you perform for employers on the job guaranteeing that the new skills you gain after training are immediately relevant to your career or employer.
  7. Shorter Sessions –
    By providing shorter session duration and then providing assignments, gives the trainees time to understand the concepts and practice from the assignments and be prepared for the next session. Online training sessions are each 2-3 hrs long and only cover 10hrs per week. Classes are scheduled 2-3 days apart giving you time to practice.
  8. Computer-Aided Simulation Learning –

    A growing number of Online Training courses are utilizing computer-aided simulation. This feature allows you to learn by making critical decisions in a realistic and safe “virtual” business setting. The consequences of your actions can be comprehended immediately. It is a highly-effective method for realizing the potential short- and long-term benefits (or dangers) of specific actions and decisions. The lessons learned using simulation are entrenched in your mind and can be applied to your role immediately.

  9. Minimum Technical Requirements:
    • Operating System: Windows XP or newer
    • Browser: Internet Explorer 6.x or newer
    • CPU: P350 MHz, recommended P500+ MHz
    • Memory: 128 MB, recommended 256+ MB RAM
    • Free Disk Space: 40 MB, recommended 200+ MB for content and recordings
    • Internet Connection: 28.8 Kbps, recommended 128+ Kbps
    • Monitor: 16 bit colors (high color)
    • Others: Sound card, microphone, and speakers OR headset with microphone

How soon after I Enroll would I get access to the Training Program and Content?

Right after you have Enrolled, we will send you an Email to your Gmail id with a Video on How To login to the training blog and get access to the training program and content.

What are the pre-requisites of taking this training?

– Someone who has the Basic computer and IT skills.
– Someone who is looking for a career in SAP HANA Database.
– Someone who is looking to start career in SAP focusing on HANA skills

Who are the instructors and what are their qualifications?

All our instructors are Senior Consultants themselves with a minimum of 10 years of real-time experience in their respective fields. Each trainer has also trained more than 100 students in the individual and/or corporate training programs.

How will be the practicals/assignments done?

Practicals/assignments will be done using the training blog. Instructions will be sent after you enroll.

When are the classes held and How many hours effort would I need to put in every day/week?

Online Live sessions are held weekdays evening CST (Central Standard Time GMT-6) or on Weekends. The schedule is posted for each batch on the website. You have to put in a effort of 8-10 hrs per week going thru the videos once again and completing your assignments.

What if I miss a class?

We Video record every Live session and after the session is complete, we will post the Video recording of that session in the blog. You will have access to these Video recordings for 6 months from the date you start your training. Material access will be provided using Google Drive Cloud for lifetime.

How can I request for a support session?

You can do that by posting a question on the training blog.

What If I have queries after I complete this course?

You can post those questions on the training blog.

Will I get 24*7 Support ?

You will get 24*7 accesss to the blog to post your questions. Trainers will answer your questions within 24 hrs of time. Normally they answer very frequently, like about 1-2 hrs. You can also approach your training coordinator for the same.

Can I get the recorded sessions of a class from some other batches before attending a live class?

Yes, you can. Or you can see our Youtube page for previous batch session recordings.

How will I get the recorded sessions?

It will be provided to you through the trainng blog.

How can I download the class videos?

You wont be able to download any videos. They are available for you to View using the training blog 24*7.

Is the course material accessible to the students even after the course training finishes?


Do you provide Placements as well

We are infact, a Consulting company which provides training so we are mainly looking for trainees who are looking for Placement after training.
After the Training Process explained (Video):
Our 6-step training to placement process (Video):

How can I complete the course in a shorter Duration?

Enroll to our Self paced video training.
Video Explanation – What is Instructor led VIDEO Training –

Do you provide any Certification? If yes, what is the Certification process?

We provide Certification guidance at the end of each course. You will also receive a “Certificate of Completion” from ZaranTech at the end of the course.

Are these classes conducted via LIVE video streaming?

We have both the options available

What internet speed is required to attend the LIVE classes?

1Mbps of internet speed is recommended to attend the LIVE classes. However, we have seen people attending the classes from a much slower internet.

What are the payment options?

We accept Credit Cards, Paypal, Bank payments from anywhere in USA, Money orders, International Wire transfer, ACH transfers, Chase Quickpay, Bank of America transfers, Wellsfargo Surepay. All the payments details are mentioned on the Enrollment page.

What if I have more queries?

Call the number listed on the Course Details page of our website.