• phone icon +44 7459 302492 email message icon info@uplatz.com
  • Register

BUY THIS COURSE (USD 23 USD 69)
4.3 (50 reviews)
( 327 Students )

 

Bundle Course - SAP HANA and SAP HANA Admin

Learn SAP HANA concepts & system administration using SAP HANA Cockpit & HANA Studio. Monitor, tune, troubleshoot HANA systems. Manage users & roles.
( add to cart )
Save 67% Offer ends on 30-Jun-2024
Course Duration: 30 Hours
  Price Match Guarantee   Full Lifetime Access     Access on any Device   Technical Support    Secure Checkout   Course Completion Certificate
New & Hot
Trending
Job-oriented
Instant access

Students also bought -

Completed the course? Request here for Certificate. ALL COURSES

Courses included in Bundle Course - SAP HANA and SAP HANA Admin are:

1)  SAP HANA

2)  SAP HANA Admin

 

SAP HANA is an in-memory database technology encompassing various components which makes it a complete package or suite for a centralized ERP system and business application development.  The multi-core processing engines process data parallels within different columns of the same database and return data to the clients in no time.  SAP HANA is the first technology which is used for both OLTP and OLAP application processing.

In-memory technology promises the extremely fast analysis and aggregation of huge amounts of data. It removes the limits known from traditional databases. The software has been optimized to take advantage of modern hardware architectures and heavily uses parallel processing. SAP Hana is an in-memory, column-oriented RDBMS. It serves as a database server that stores and retrieves huge volumes of data I real-time.

 

SAP HANA administration deals with managing SAP HANA system in a single and distributed system environment.  SAP Hana Administration includes the following activities:

1) SAP HANA Administration Tools

2) SAP HANA  Lifecycle Mangement

3) SAP HANA  Backup and Recovery Management

4) SAP HANA  Security and User Management

5) SAP HANA Multiple Host system management

 

The roles and responsibilities of SAP HANA Administrator are:

a) Create and configure connection SLT to HANA

b) Create and configure connection SLT TO ECC

c) Initial Configuration of SLT Replication Server

d) Configure alerts in DS, ST to monitor load failures

e) Hana Database security

f) Expertise in Hana studio

g) Integration of ECC with HANA Database using the SLT Replication Servers or services

h) Starting and stopping of Sap Hana systems

 

Uplatz provides this complete end-to-end SAP HANA and HANA Administration course covering all topics of SAP HANA and SAP HANA Admin in detail.

Course/Topic 1 - SAP HANA - all lectures

  • In this first session of the SAP HANA tutorial, you will get a brief introduction to what exactly is SAP HANA, along with a pictorial representation of SAP HANA Architecture, HANA Software Editions, terminologies used in SAP HANA, the hardware innovations involved in SAP HAHAN, understanding the Columnar Data Storage, HANA Appliance and lastly the SAP HANA Editions.

    • 1:06:21
  • In this video, you will learn about the Architecture of SAP HANA, starting with the approach for data transfer, components of SAP HANA, the Database Engine view, SAP HANA Appliance, the different views of SAP HANA like the Data Loading View, Reporting View and the Administrative View. Furthermore, you will also be learning about the SAP HANA System Landscaping.

    • 1:28:54
  • This video is a complete practical session on the Data Services involved in the SAP HANA System Landscaping. The trainer will be guiding you with a step-by-step implementation of the whole process.

    • 48:29
  • This video is a continuation of the SAP BODS Data Services session where you will learn some more configuration steps involved in the SAP Data Services of the SAP HANA System.

    • 1:04:31
  • In this video, you will get a brief overview of LT Replication Server, learning concepts on SLT Environment Flow, setup of LT Replication Server like Installation Aspects, Configuration Steps, and the Setup Data Replication in SAP HANA. Furthermore, you will be learning about the key benefits of LT Replication Server, the architecture of TDMS Technology, SLT Replication Key Building Blocks, Technical Requirements, and System Set-up Information, SLT Replicator Configuration, details on Transformation Capabilities, Data Processing and Transformation Steps, Parameter based rules and many more.

    • 1:24:51
  • This video will teach you about the concept of Replication in the SAP HANA system where you will be learning about the 4 different ways of loading data into the SAP HANA database. You will also be learning about the HANA Appliance Server Configurations which are the Scale Up and Scale Out configuration. Furthermore, you will be learning about the SAP HANA System Sizing Guidelines and the complete work process of these will be shown by the trainer in the SAP system.

    • 1:26:56
  • In this SAP HANA video, you will learn about the different HANA Studio-Features like Modeling, Data Preview, Import/Export, and others. You will also learn about the HANA Studio Terminologies like Data Views and procedures. Further, you will learn the practical steps involved in creating an Attribute View which will be shown in the SAP system along with the Customer Attribute View.

    • 51:28
  • In this video, you will learn how to create package in Product or Material View along with getting the knowledge on Analytical View, Set Parameters, Table Selection, and creating Location Attribute View. You will also learn to create and maintain Operating Concern, its characteristics, database structures in CO-PA, and others.

    • 1:21:36
  • This video is a completely practical tutorial on how to create Location View in the SAP HANA System. You will be shown by the trainer a complete step-by-step process of how to do the work process in the SAP system.

    • 1:43:12
  • In this HANA tutorial, you will learn the whole work process of SLT Based Table Data Provisioning with every step being shown in the system. You will also learn Actual_AView and the Plan_AView and the concepts involved in both in the system.

    • 1:29:14
  • In this video, you will get a brief overview on the Analytics on HANA with the Scale Up Configuration, the client and connectivity options, HANA Analytics Supported Interface, the Reporting & Dashboard Overview, and under it the Semantic Layer Overview, Information Design Tool, the Universe Design Steps and these will be shown by the trainer in the SAP HANA system.

    • 1:53:06
  • In this video, you will be learning about the Analytical Reporting in the SAP HANA, and under it, you will learn about the BOBJ Explorer Set-up with an overview of what is BOBJ Explorer, which will be shown in the system by the trainer. Further, you will get the knowledge on the BOBJ Analysis for Office. You will also get recommendations on Configuration, Information Design Tool, BusinessObjects Explorer 4.0, and Web Intelligence 4.0.

    • 1:32:55
  • In this video, you will learn about the complete SAP HANA System Administration, starting with the In-Memory Database (IMDB) Installation and the steps involved in it. This will be shown in the SAP system by the trainer. Along with this, you will also learn about the Enterprise Server Configuration, Scale Up configuration, Distributed System Handling, Distributed System Landscape, Monitoring the Landscape, and a pictorial representation of the Disaster Tolerance Hardware along with showing it in the SAP HANA System.

    • 1:19:21
  • This is a continuation video to the previous session where you will be learning about the SAP HANA Database with monitoring the landscape, Multi Version Concurrency Control (MVCC), Persistence Layer, the concept of power failure deleting in-memory data and the backup process, disk failure, User Management and Security, HANA Customer Support and SAP Connection, a picturesque view of Creating Users, Managing Users and Assigning Security. You will also be learning about the User and Role concept which will be shown in the SAP system along with the User Provisioning and User Management, assigning Privileges to Roles, creating Role to User, types of Privileges in HANA, and the concept of Analytic Privileges.

    • 1:24:24
  • In this video you will be learning about the Migration of Database in the SAP HANA system, starting with the concept of In-Memory optimized InfoCube which will be shown in the SAP system, a diagrammatic explanation of the In-Memory optimized InfoCube Design in SAP BW, and the overview of Inventory Management with the Conversion Steps and Log Overview.

    • 52:48
  • In this video, you will get an introduction to SAP BOBJ Data Services, starting with the Enterprise Information Management (EIM), Business Objects Data Integrator, Data Services Usage, and Architecture. You will also learn about the Data Services Repository and its types, the Object Hierarchy, a brief overview of Work Flow shown, and the complete process in the SAP system.

    • 1:29:37
  • In this HANA tutorial, you will be learning about the ERM, its entities and their relations, the OLAP Database design, and the 4 schemas of MDM. You will get a brief training on the Star Schema as well.

    • 10:47
  • In this last session of the SAP HANA training, you will be learning about the LT Replication Server, showing its details in the SAP system, the new update in the SAP BO Data Services 4.0. Along with this, you will also learn about the SLT Environment Flow, the set-up of LT Replication Server with its configuration steps, what are the key benefits of LT Replication Server for SAP HANA, the Architecture of SAP TDMS Technology, SLT Replication Key Building Blocks, the Technical Requirements, and System Set-Up Information, the configuration steps for SLT Replicator. Furthermore, you will be learning about the Events based Rules, the Extension of Tablestructures and many more.

    • 1:51:27

Course/Topic 2 - SAP HANA Admin - all lectures

  • In this first video on SAP HANA Admin tutorial, you will get a brief introduction to what is SAP HANA, what is HANA database, how HANA overcomes the daily irritations like the sub-optimal execution speed, lack of transparency, reactivate business model, how HANA database is much more useful than the normal database and many more. You will also learn about the SAP HANA deployment view, the component Architecture view, the HANA individual components, a pictorial diagram showing the example of Deployment Landscape, and many more.

    • 10:57
  • This video is about the installation of SAP HANA, starting with the SAP HANA Sizing, Main Memory Sizing, Disk Sizing, CPU Sizing, what is SAP Quicksizer, what are the requirements for the SAP HANA Single-Host and Multi-Host Database System, the basic components of the SAP HANA system, the installation of single and multiple-SID and lastly the Operating System and Hardware Requirements. Further, you will be learning about the important directories and their sizes and finally the File System Structure for a Multi-SID Installation.

    • 10:40
  • This video is a tutorial on the SAP HANA appliance and the sizing of the components. You will get a practical demonstration on how to show certified SAP HANA appliance configurations throughout the session.

    • 01:30
  • This tutorial will explain to you the various Lifecycle Management tools for installing SAP HANA starting with a brief introduction to SAP HANA Lifecycle Management Tools, explaining various installation methods, how to install SAP HANA as a single-host, installing and configuring SAP HANA Studio, installing the SAP HANA SHINE content and lastly, explaining a multi-host system installation.

    • 26:47
  • This session is an exercise on installing your own standalone SAP HANA System. You will be shown the complete process during the session and lastly, how to update the SAP HANA Studio using an Update Site.

    • 04:45
  • This session will teach you about the post-installation steps, updating SAP HANA, the revision strategy of SAP HANA and SHINE; SAP HANA Interactive Education. Here the target audience is taken as the System Administrator.

    • 31:14
  • In this tutorial, you will learn how to update SAP HANA with a new support package along with installing the SAP HANA Interactive Education (SHINE) content. The complete and step-by-step work process will be shown throughout the session.

    • 03:50
  • In this session, you will learn about the SAP HANA Memory Management and Data Persistence, Software Packaging, SAP HANA Roadmap and Scenarios, and the Deployment Options. Here, the target audience is the System Administrator and the complete session will be shown with a detailed explanation in a step-by-step procedure.

    • 54:43
  • This tutorial will explain to you the different admin tools for the SAP HANA, starting with a detailed explanation on the Overview of Administration Tool, the SAP HANA Studio and SAP HANA Cockpit, the DBA Cockpit, and lastly, the HDBSQL Command Line Tool.

    • 33:46
  • In this tutorial, you will learn about the process of starting and stopping SAP HANA, the configurations steps involved in SAP HANA, the SAP HANA Table Administration, the Periodic Tasks and the process of Transporting Changes.

    • 1:53:46
  • This practice session is an exercise on the process of starting and stopping SAP HANA. You will learn the complete process of how to do it in the SAP system.

    • 22:55
  • In this video, you will learn about the concept of Backup and Recovery, the Data Area Backup, Log Area Backup along with some additional Backup topics. You will also learn about the Recovery process, the Backup, and Recovery using Storage Snapshot, and the Database Copy.

    • 48:54
  • This video is an exercise session on the Backup and Recovery process where you will get a complete and step-by-step explanation of the whole work process in the SAP System.

    • 03:52
  • In this session, you will learn about the Monitoring and Troubleshooting steps involved in SAP HANA, starting with Configuring Traces, working with Diagnosis Information and Diagnosis Files, SQL Console, and Query Analysis. You will also be learning about the Monitoring with SAP Solution Manager, Remote Support, and lastly the SAP Early Watch Alert.

    • 41:03
  • This video will show you the complete work process of how to configure SAP HANA Traces. You will learn each and every step of it during the session.

    • 06:14
  • In this video, you will get a complete overview of the Security involved in SAP HANA along with Authentication and Authorization, encryption, and lastly the Auditing.

    • 40:48
  • In this session, you will learn about User Management, the types of Privileges, Roles, Administrative Tasks, the information Sources of Administrators, and lastly the SAP HANA Live Authorization Assistant.

    • 1:02:05
  • This video is an exercise session on Maintaining Users and Authorization in the SAP HANA system. You will be getting a detailed workaround of the entire procedure in the SAP system.

    • 20:47
  • In this video, you will get the knowledge on the concepts like High Availability and Disaster Tolerance, starting with the Continuous Availability and then moving forward towards High Availability, the SAP HANA Scale Out and lastly the Disaster Recovery.

    • 31:49
  • In this video, you will learn a complete step-by-step procedure of the installation of the SAP HANA Scale Out System and the whole work process associated with it.

    • 04:48
  • This video will teach you about the Multitenant Database Containers starting with the Architecture and Technology of it, the Administration of Multitenant Database Containers, the Backup and Recovery of Multitenant Database Containers, and lastly the Appendix.

    • 34:27
  • This last video is a post-assessment session where you will be asked some questions and based on that, your knowledge of the subject will be measured. The assessment will cover modules like SAP HANA Introduction, Installation and Post Installation, Architecture and Scenarios, Admin Tools for SAP HANA, Operations, Backup and Recovery, Monitoring and Troubleshooting, Security, Maintaining Users and Authorization and lastly about the High Availability and Disaster Tolerance.

    • 03:08
Course Objectives Back to Top

•How to create and configure connection SLT to HANA

•How to create and configure connection SLT TO ECC

•About Initial Configuration of SLT Replication Server

•About configure alerts in DS, ST to monitor load failures

•About Hana Database security

•About expertise in Hana studio

•How to Integration of ECC with HANA Database using the SLT Replication Servers or services

•How to Start and stop of Sap Hana systems.

Course Syllabus Back to Top

BUNDLE COURSE - SAP HANA AND SAP HANA ADMIN - COURSE SYLLABUS

 

SAP HANA 2.0

COURSE DETAILS & CURRICULUM

Lesson 1: SAP HANA Foundation

Lesson 2: Deployment Strategies

 

•       On-Premise

•       On-Cloud

•       Side-Car

 

 

Lesson 3: Architecture of SAP HANA

 

Lesson 4: Replicating Data to SAP HANA

 

•       Business Objects Data Services (BODS)

•       SAP Landscape Transformation (SLT)

 

Lesson 5: SAP HANA Studio Interface

 

•       Attribute View

•       Analytic View

•       Calculation View

•       Catalog - Schemas, HANA Live Package

•       SAP HANA - SQL Overview

•       SAP HANA Transports Options

•       SAP ABAP - HANASAP HANA CDS Views

 

Lesson 6: SAP HANA Reporting Overview (BOBJ)

 

•       BO WEBi

•       BO Crystal Reports Enterprise

•       BO IDT (BO UNX)

•       BO CMC (Admin-SSO)

•       BO AO (Analysis Office)

•       BO Design Studio

•       SAP Lumira& Smart Business Client

•       SAP Fiori& SAP NetWeaver Business Client7

 

Lesson 7: SAP HANA System Monitoring & Administration

 

•       DBA Cockpit

•       Database Migration Option (DMO)

 

Lesson 8: SAP HANA Security & Authorization

 

•       User Management

•       Role Management

 

Lesson 9: Advanced Features Overview

 

•       SAP HANA Web IDE

•       SAP Predictive Analytics on HANA

•       SAP BW-BPC embedded on HANA

•       SAP S/4HANA

•       Rapid Deployment Solutions (RDS) for HANA

•       SAP Activate Solution Manager for SAP HANA

 

SAP HANA ADMIN

Lesson 00 - SAP HANA ARCHITECTURE

Lesson 01 - SAP HANA Architecture

- In-Memory Computing

- Hardware-Innovations

- Software –Innovations

- SAP HANA simplified Architecture

- SAP HANA Extended Architecture

- Business Intelligence Clients with HANA

- HANA Columnar Store

- SAP HANA row store VS Columnar store

- Understanding Columnar Storage

Lesson 02 - SAP HANA Edition

- SAP HANA Enterprise Edition

- SAP HANA Enterprise Extended Edition (As of SPS03)

- SAP HANA Platform Edition

Lesson 03 - SAP HANA Sizing

- SAP HANA In-Memory Database Sizing elements

- RAM, Disk, CPU

- Memory Sizing

- Disk Sizing

- CPU sizing

Lesson 04 - SAP HANA Versions

- HANA 1.0 SPS03

- HANA 1.0 SPS04—New Features

- HANA 1.0 SPS05—New Features

- HANA 1.0 SPS06—New Features

Lesson 05 - SAP HANA INSTALLATION OVERVIEW

Lesson 06 - SAP HANA Hardware and Software Requirements

- Certified Hardware

- SLES 11 Sp1

- Preparing file system & directories

- Prepare Installation parameters

- Users created during Installation

- Required Installation media

- Prepare Installer configuration file

Lesson 07 - Installing SAP HANA

- SAP HANA unified Installer Tool

- Running Unified Installer to install the SAP HANA SERVER

- Components installed by Installer

Lesson 08 - Install HANA Client

- Available Clients on Linux

- Available Clients on windows

- Install SAP HANA Client on LINUX Host

- Install SAP HANA Client on Windows Host

Lesson 09 - Install HANA Studio

- System Requirements

- Supported Platforms

- Install SAP HANA Studio on LINUX Host

- Install SAP HANA Studio on Windows Host

Lesson 10 - Post – Installation Steps

- Starting and Stopping SAP HANA System

- Displaying Process List

- Logging on to HANA system using HANA studio

- User Security

- Configuring SUM for HANA

- Automatic Start of HANA

- Applying Support packages and Updates

- Monitoring HANA Landscape

Lesson 11 - Enabling High availability of SAP HANA

- Concept of HANA high- availability

- Disaster Tolerance

- Redundant Hardware

- Distributed System

- Standby Host

- Installation Planning for Distributed System

- Install HANA distributed system

- Monitoring and Configuring Standby Hosts

Lesson 12 - SAP HANA DATA PROVISIONING

Lesson 13 - Configuring Data Replication with SLT

Positioning and benefits of SLT for SAP HANA

Key benefits of Trigger-Based Approach

Architecture and building Blocks

Architecture for SAP Source Replication

Architecture for Non-SAP source Replication

Set-up of SAP LT replication server

Installation Aspects

Configuration Steps for SLT replication server

Setup Data Replication

Database-Supportability

Landscape strategy of SLT replication server

SLT replication server Installation Options

Technical Requirements and system setup Information

DMIS2010 and relevant Support packs

SAP Kernel and DBSL Installation

Creating RFC Connections

Creating DB Connections

Configuring and Monitoring Dashboard

Creating New Configuration for SAP source

- Creating New Configuration for NON-SAP source

- Monitoring of Replication

- Mass Transfer IDS

- IUUC Synchronisation Cockpit

- Data Transfer Monitor

- Backup and Recovery Strategy

- Data Volume Management

Lesson 14 - SAP HANA Direct Extractor Configuration Overview

- Introduction to SAP HANA Direct Extractor Connection (DXC)

- Limitations of DXC

- Setup and Configurations

- Enabling Services

- HTTP connection

- Test Connection

Lesson 15 - Configuring Data Replication with SAP BODS

- SAP BODS 4.0 and SAP HANA

- SAP BODS 4.0 Architecture

- Configuring BO Data services

- Installing HANA ODBC Driver

- Creating SAP HANA Datastore in Data Services

- Creating SAP ERP Data store in Data Services

- Configuring HANA Studio for Importing Metadata

- Import Metadata

- Mass Import

- Selective Import

- Load Data via Data services into SAP HANA

Lesson 16 - SAP HANA TECHNICAL OPERATIONS

Lesson 17 - Operate SAP HANA

- Starting & Stopping SAP HANA

- Starting SAP HANA Database

- Stopping SAP HANA Database

- Displaying Process List

- Monitoring HANA landscape

Lesson 18 - Configuring SAP HANA DB

- System Configuration Parameters

- Monitoring and system state Parameters

Lesson 19 - Backup & Recovery SAP HANA

- Need of Backup

- Backup Types

- Data Backup

- Log Backup

- Recovery Options

- Recovery in Replication Scenarios

- Backup to External Backup Destinations

- Recovery scenarios

- Power Failure

- Disk Failure

- High Availability for SAP HANA

Lesson 20 - SAP HANA Security

- Create Users

- User and Role Concept

- Creating Roles

- Assigning Privileges to Roles

- Privileges

- SQL privileges

- System Privileges

- Analytic Privileges

- Reporting and Privileges

- Modeling required privileges

Lesson 21 - SAP HANA Monitoring & Troubleshooting

- Configuring Remote Support

- Solution Manage Integration

- Remote Service Connection

- EWA for HANA

- Availability Monitoring

- Setting up Monitoring

- System Monitoring Setup

- Status Overview

- Services Overview

- System Load History

- Disk usage Details

- Checking System Configuration Alerts

Lesson 22 - Analyzing logs & traces

- Regular administration tasks

- Troubleshooting

- Analyzing performance

Lesson 23 - Software Life cycle Management

- Transporting Changes

- CTS/CTS+

- SAP HANA with CTS+

- Exporting and Importing

- Developer Mode

- Delivery Unit

- SAP support Mode

- Exporting Tables

- Updating SAP HANA

- SAP HANA Update and Patching

- SP stack Update

Lesson 24 - SAP HANA PLATFORM

- SAP HANA Native Applications

- Non-Native SAP HANA Applications

Lesson 25 - SAP HANA in Cloud overview

- Access to HANA systems in cloud

- SAP HANA Developer Edition Environment

Lesson 26 - MIGRATION TO SAP HANA

Lesson 27 - SAP BW Powered by HANA

Lesson 28 - SAP ERP on HANA

Lesson 29 - SAP CRM on HANA

Lesson 30 - SAP HANA Rapid Deployment Solutions (RDS)

 

 

Certification Back to Top

The SAP HANA and SAP HANA Admin Certification ensures you know planning, production and measurement techniques needed to stand out from the competition.

SAP HANA is an in-memory database for performing real-time data analysis, and development of applications on top of real-time data. HANA administration deals with managing SAP HANA systems in a single and distributed system environment.

Integration of SAP HANA into different remote systems. Exposure to different remote access options in the HANA system. Experience in monitoring, tuning, and troubleshooting of SAP HANA systems. HANA system administration using SAP HANA Cockpit and HANA Studio.

Based on the current scenario, if you are considering the long-term benefit rather than an immediate job, SAP HANA Simple Finance Certification can be the right track for you. Getting additional skill and knowledge will always add value in your career now more than ever.

Uplatz online training guarantees the participants to successfully go through the SAP HANA and SAP HANA Admin certification provided by Uplatz. Uplatz provides appropriate teaching and expertise training to equip the participants for implementing the learnt concepts in an organization.

Course Completion Certificate will be awarded by Uplatz upon successful completion of the SAP HANA and SAP HANA Admin online course.

 

      SAP BW/4HANA 2.0 Delta.

      SAP Certified Product Support Specialist - SAP Commerce.

      SAP BW powered by HANA SPS12 (Edition 2016)

      Financials in SAP S/4HANA for SAP ERP Finance Experts (SAP S/4HANA 1809)

      SAP Commerce Cloud 1905 Developer.

      System Security Architect.

Career & Jobs Back to Top

The SAP HANA and SAP HANA Admin draw an average salary of $98,080 per year depending on their knowledge and hands-on experience. The SAP HANA and SAP HANA Admin job roles are in high demand and make a rewarding career.

SAP certification is an excellent career option for those candidates who dream to become a successful SAP HANA consultant. There is no doubt that SAP HANA job offers complete job satisfaction with a greater salary range.

In the present job market, the SAP HANA experts are in high demand. Well, there are only some professionals who meet the needs of the SAP HANA requirements. As SAP HANA is the most challenging and demanding technology today, the SAP HANA professionals can get the average salary in the range of $51,994 – $145,093.

Note that salaries are generally higher at large companies rather than small ones. Your salary will also differ based on the market you work in.

The following are the job titles:

SAP HANA Administrator.

SAP HANA Consultant.

Interview Questions Back to Top

1) Mention what is SAP HANA?

 

SAP HANA stands for High Performance Analytical Appliance- in-memory computing engine. HANA is linked to ERP systems; Frontend modeling studio can be used for replication server management and load control.

2) Mention the two types of Relational Data stored in HANA?

The two types of relational data stored in HANA includes

  • Row Store
  • Column Store

3) Mention what is the role of the persistence layer in SAP HANA?

SAP HANA has an in-memory computing engine and access the data straightaway without any backup. To avoid the risk of losing data in case of hardware failure or power cutoff, persistence layer comes as a savior and stores all the data in the hard drive which is not volatile.

4) Mention what is modeling studio?

Modeling studio in HANA performs multiple task like

  • Declares which tables are stored in HANA, first part is to get the meta-data and then schedule data replication jobs
  • Manage Data Services to enter the data from SAP Business Warehouse and other systems
  • Manage ERP instances connection, the current release does not support connecting to several ERP instances
  • Use data services for the modeling
  • Do modeling in HANA itself
  • essential licenses for SAP BO data services


5) Mention what are the different compression techniques?

There are three different compression techniques

  • Run-length encoding
  • Cluster encoding
  • Dictionary encoding

6) Mention what is latency?

Latency is referred to the length of time to replicate data from the source system to the target system.

7) Explain what is transformation rules?

Transformation rule is the rule specified in the advanced replication setting transaction for the source table such that data is transformed during the replication process.

8) Mention what is the advantage of SLT replication?

  • SAP SLT works on trigger based approach; such approach has no measurable performance impact in the source system
  • It offers filtering capability and transformation
  • It enables real-time data replication, replicating only related data into HANA from non-SAP and SAP source systems
  • It is fully integrated with HANA studios
  • Replication from several source systems to one HANA system is allowed, also from one source system to multiple HANA systems is allowed.

9) Explain how you can avoid un-necessary information from being stored?

To avoid un-necessary information from being stored, you have to pause the replication by stopping the schema-related jobs


10) Mention what is the role of master controller job in SAP HANA?

The job is arranged on demand and is responsible for

  • Creating database triggers and logging table into the source system
  • Creating Synonyms
  • Writing new entries in admin tables in SLT server when a table is replicated/loaded
Course Quiz Back to Top
Start Quiz
Q1. What are the payment options?
A1. We have multiple payment options: 1) Book your course on our webiste by clicking on Buy this course button on top right of this course page 2) Pay via Invoice using any credit or debit card 3) Pay to our UK or India bank account 4) If your HR or employer is making the payment, then we can send them an invoice to pay.

Q2. Will I get certificate?
A2. Yes, you will receive course completion certificate from Uplatz confirming that you have completed this course with Uplatz. Once you complete your learning please submit this for to request for your certificate https://training.uplatz.com/certificate-request.php

Q3. How long is the course access?
A3. All our video courses comes with lifetime access. Once you purchase a video course with Uplatz you have lifetime access to the course i.e. forever. You can access your course any time via our website and/or mobile app and learn at your own convenience.

Q4. Are the videos downloadable?
A4. Video courses cannot be downloaded, but you have lifetime access to any video course you purchase on our website. You will be able to play the videos on our our website and mobile app.

Q5. Do you take exam? Do I need to pass exam? How to book exam?
A5. We do not take exam as part of the our training programs whether it is video course or live online class. These courses are professional courses and are offered to upskill and move on in the career ladder. However if there is an associated exam to the subject you are learning with us then you need to contact the relevant examination authority for booking your exam.

Q6. Can I get study material with the course?
A6. The study material might or might not be available for this course. Please note that though we strive to provide you the best materials but we cannot guarantee the exact study material that is mentioned anywhere within the lecture videos. Please submit study material request using the form https://training.uplatz.com/study-material-request.php

Q7. What is your refund policy?
A7. Please refer to our Refund policy mentioned on our website, here is the link to Uplatz refund policy https://training.uplatz.com/refund-and-cancellation-policy.php

Q8. Do you provide any discounts?
A8. We run promotions and discounts from time to time, we suggest you to register on our website so you can receive our emails related to promotions and offers.

Q9. What are overview courses?
A9. Overview courses are 1-2 hours short to help you decide if you want to go for the full course on that particular subject. Uplatz overview courses are either free or minimally charged such as GBP 1 / USD 2 / EUR 2 / INR 100

Q10. What are individual courses?
A10. Individual courses are simply our video courses available on Uplatz website and app across more than 300 technologies. Each course varies in duration from 5 hours uptop 150 hours. Check all our courses here https://training.uplatz.com/online-it-courses.php?search=individual

Q11. What are bundle courses?
A11. Bundle courses offered by Uplatz are combo of 2 or more video courses. We have Bundle up the similar technologies together in Bundles so offer you better value in pricing and give you an enhaced learning experience. Check all Bundle courses here https://training.uplatz.com/online-it-courses.php?search=bundle

Q12. What are Career Path programs?
A12. Career Path programs are our comprehensive learning package of video course. These are combined in a way by keeping in mind the career you would like to aim after doing career path program. Career path programs ranges from 100 hours to 600 hours and covers wide variety of courses for you to become an expert on those technologies. Check all Career Path Programs here https://training.uplatz.com/online-it-courses.php?career_path_courses=done

Q13. What are Learning Path programs?
A13. Learning Path programs are dedicated courses designed by SAP professionals to start and enhance their career in an SAP domain. It covers from basic to advance level of all courses across each business function. These programs are available across SAP finance, SAP Logistics, SAP HR, SAP succcessfactors, SAP Technical, SAP Sales, SAP S/4HANA and many more Check all Learning path here https://training.uplatz.com/online-it-courses.php?learning_path_courses=done

Q14. What are Premium Career tracks?
A14. Premium Career tracks are programs consisting of video courses that lead to skills required by C-suite executives such as CEO, CTO, CFO, and so on. These programs will help you gain knowledge and acumen to become a senior management executive.

Q15. How unlimited subscription works?
A15. Uplatz offers 2 types of unlimited subscription, Monthly and Yearly. Our monthly subscription give you unlimited access to our more than 300 video courses with 6000 hours of learning content. The plan renews each month. Minimum committment is for 1 year, you can cancel anytime after 1 year of enrolment. Our yearly subscription gives you unlimited access to our more than 300 video courses with 6000 hours of learning content. The plan renews every year. Minimum committment is for 1 year, you can cancel the plan anytime after 1 year. Check our monthly and yearly subscription here https://training.uplatz.com/online-it-courses.php?search=subscription

Q16. Do you provide software access with video course?
A16. Software access can be purchased seperately at an additional cost. The cost varies from course to course but is generally in between GBP 20 to GBP 40 per month.

Q17. Does your course guarantee a job?
A17. Our course is designed to provide you with a solid foundation in the subject and equip you with valuable skills. While the course is a significant step toward your career goals, its important to note that the job market can vary, and some positions might require additional certifications or experience. Remember that the job landscape is constantly evolving. We encourage you to continue learning and stay updated on industry trends even after completing the course. Many successful professionals combine formal education with ongoing self-improvement to excel in their careers. We are here to support you in your journey!

Q18. Do you provide placement services?
A18. While our course is designed to provide you with a comprehensive understanding of the subject, we currently do not offer placement services as part of the course package. Our main focus is on delivering high-quality education and equipping you with essential skills in this field. However, we understand that finding job opportunities is a crucial aspect of your career journey. We recommend exploring various avenues to enhance your job search:
a) Career Counseling: Seek guidance from career counselors who can provide personalized advice and help you tailor your job search strategy.
b) Networking: Attend industry events, workshops, and conferences to build connections with professionals in your field. Networking can often lead to job referrals and valuable insights.
c) Online Professional Network: Leverage platforms like LinkedIn, a reputable online professional network, to explore job opportunities that resonate with your skills and interests.
d) Online Job Platforms: Investigate prominent online job platforms in your region and submit applications for suitable positions considering both your prior experience and the newly acquired knowledge. e.g in UK the major job platforms are Reed, Indeed, CV library, Total Jobs, Linkedin.
While we may not offer placement services, we are here to support you in other ways. If you have any questions about the industry, job search strategies, or interview preparation, please dont hesitate to reach out. Remember that taking an active role in your job search process can lead to valuable experiences and opportunities.

Q19. How do I enrol in Uplatz video courses?
A19. To enroll, click on "Buy This Course," You will see this option at the top of the page.
a) Choose your payment method.
b) Stripe for any Credit or debit card from anywhere in the world.
c) PayPal for payments via PayPal account.
d) Choose PayUmoney if you are based in India.
e) Start learning: After payment, your course will be added to your profile in the student dashboard under "Video Courses".

Q20. How do I access my course after payment?
A20. Once you have made the payment on our website, you can access your course by clicking on the "My Courses" option in the main menu or by navigating to your profile, then the student dashboard, and finally selecting "Video Courses".

Q21. Can I get help from a tutor if I have doubts while learning from a video course?
A21. Tutor support is not available for our video course. If you believe you require assistance from a tutor, we recommend considering our live class option. Please contact our team for the most up-to-date availability. The pricing for live classes typically begins at USD 999 and may vary.



BUY THIS COURSE (USD 23 USD 139)