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

BUY THIS COURSE (USD 17 USD 41)
3.6 (100 reviews)
( 887 Students )

 

SAP HANA Installation

Get details about installation, configuration, and administration of SAP HANA environment. Also understand post-installation steps & security aspects.
( add to cart )
Save 59% Offer ends on 30-Jun-2024
Course Duration: 2 Hours
View Course Curriculum   Price Match Guarantee   Full Lifetime Access     Access on any Device   Technical Support    Secure Checkout   Course Completion Certificate
Bestseller
Trending
Job-oriented
Instant access

Students also bought -

Completed the course? Request here for Certificate. ALL COURSES

SAP HANA is an in-memory, columnar database system developed by SAP. It enables real-time data processing, advanced analytics, and rapid decision-making by storing and accessing data in memory. This technology revolutionizes data management, providing businesses with faster insights and improved performance for various applications and data-driven processes.

 

Installing SAP HANA involves several steps to set up the software and configure the system correctly. Here's an overview of the general installation process for SAP HANA:

1. Prerequisites and Planning:

Before beginning the installation, review the SAP HANA hardware and software requirements to ensure that your system meets the necessary specifications.

Plan the installation process, including the edition of SAP HANA you want to install (e.g., SAP HANA Platform Edition or SAP HANA Express Edition), the installation method (e.g., using SAP HANA Lifecycle Manager or SAP HANA Installation media), and the deployment scenario (standalone, distributed, or scale-out).

2. Download SAP HANA Software:

Obtain the necessary SAP HANA installation files from the SAP Software Download Center or another authorized source. Make sure you have the correct installation package for your chosen edition and version.

3. Install Prerequisites:

Install any required software and libraries, such as the SAP HANA client software, operating system updates, and additional system components.

4. Run SAP HANA Installation:

Launch the SAP HANA installation program, which typically involves running the SAP HANA Database installer.

Provide the necessary installation parameters and credentials, such as the installation path, system ID, instance number, database user passwords, and system administrator passwords.

5. Database Instance Configuration:

During the installation, you'll configure the SAP HANA instance, which includes defining memory and CPU settings, data storage locations, and network configuration.

6. Database Initialization:

The installation process initializes the SAP HANA database. This step involves creating the necessary database files, data structures, and system tables.

7. Post-Installation Steps:

After the initial installation is complete, you may need to perform additional post-installation tasks, such as applying support packages, patches, or updates.

8. Configuration Validation:

Verify that the SAP HANA installation was successful and that the system is functioning correctly. Check the system logs and run basic tests to ensure everything is in order.

9. Security Setup:

Set up user authentication and authorization, configure SSL certificates if required, and implement other security measures to protect the SAP HANA system and data.

10. Backup and Recovery Configuration:

Implement a backup and recovery strategy to safeguard data and ensure business continuity in case of system failures.

11. Monitoring and Maintenance:

Set up monitoring tools and procedures to keep track of system performance and health. Plan for regular maintenance activities like applying updates and monitoring system resources.

Please note that the specific installation steps and procedures may vary depending on the version of SAP HANA and the deployment scenario chosen. Always refer to the official SAP HANA installation guides and documentation for detailed instructions relevant to your specific environment.

 

This SAP HANA Installation course by Uplatz will help you install, configure, and administer the SAP HANA system.

Course/Topic - SAP HANA Installation - all lectures

  • In this video, you will learn how to install SUSE Linux with a step-by-step process of the complete procedure in the SAP HANA System.

    • 40:48
  • In this session, you will learn how you can install SAP HANA. This video is a complete tutorial on HANA installation and the entire work process in the SAP system.

    • 49:55
Course Objectives Back to Top

This course will prepare you to:

Install, update and configure an SAP HANA 2.0 SPS05 database.

Installation, update and configure of SAP HANA cockpit 2.0 SP12.

Perform the SAP HANA system administration tasks using SAP HANA cockpit 2.0 SP12 in a multitenant database environment.

Start and stop, change the configuration, backup and troubleshoot an SAP HANA 2.0 SPS05 database.

Backup and recover a multitenant SAP HANA 2.0 SPS05 database.

Setup up an SAP HANA Environment

Install SAP HANA in different modes and Configurations

Configure SAP HANA DB post installation

Operate and Administer SAP HANA Landscape

Monitor SAP HANA with different Monitoring Tools

Setup end to end Security

Backup and Recover SAP HANA DB

Understand High Availability and Disaster Recovery

 

With SAP HANA Installation course you will learn:

a) Setup up an SAP HANA Environment.

b) Install SAP HANA in different modes and Configurations.

c) Configure SAP HANA DB post installation.

d) Operate and Administer SAP HANA Lanscape.

e) Monitor SAP HANA with different Monitoring Tools.

f) Setup end to end Security.

g) Backup an Recover SAP HANA DB.

h) Understand High Availability and Disaster Recovery.

Course Syllabus Back to Top

SAP HANA INSTALLATION – COURSE SYLLABUS

 

• Preparing Installation

o Sizing of SAP HANA

o Requirements

• Installation

o Introduction SAP HANA Lifecycle Management Tools

o Advanced installation options

o SAP HANA Studio installation

o Performing a Distributed System Installation

• Post Installation

o Post-Installation Steps

o Updating SAP HANA

o Revision strategy of SAP HANA

• Architecture and Scenar

o SAP HANA Memory Management and Data Persistence

o Software Packaging

o SAP HANA Roadmap and Scenarios

o Deployment Options

• Admin Tools for SAP HANA

o Administration Tool Overview

o SAP HANA Studio and SAP HANA Cockpit

o SHINE - SAP HANA Interactive Education

o DBA Cockpit

o HDBSQL Command Line Tool

• Operations and Troubleshooting

o Starting and Stopping SAP HANA

o Configuring SAP HANA

o SAP HANA Table Administration

o Periodic Tasks

o Configuring Traces

o Working with Diagnosis Information and Diagnosis Files

o SQL Console

o Transporting Changes

• Backup and Recovery

o Concept of Backup and Recovery

o Data Area Backup

o Log Area Backup

o Additional Backup Topics

o Recovery

o Backup and Recovery using Storage Snapshot

o Database Copy

• Security

o Security Overview

o Authentication and Authorization

o Encryption

o Auditing

 

Certification Back to Top

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

SAP HANA is used for Big Data processing and analytics. Its function is to make the information stored in different databases and in different forms readily available to other applications.

SAP HANA (High-performance ANalytic Appliance) is a multi-model database that stores data in its memory instead of keeping it on a disk. This results in data processing that is magnitudes faster than that of disk-based data systems, allowing for advanced, real-time analytics.

SAP HANA is an in-memory data platform that is deployable as an on-premise appliance, or in the cloud. It is a revolutionary platform, which is best suited for performing real-time analytics, and developing and deploying real-time applications.

Companies using SAP S/4 HANA for ERP Financial include: US Army, a United States based Government organization with 1258472 employees and revenues of $778.00 billions, Walmart Inc., a United States based Retail organization with 2200000 employees and revenues of $571.96 billions, Toyota Motor Corporation, a Japan based. 

Uplatz online training guarantees the participants to successfully go through the  SAP HANA Installation 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 Installation online course.

Career & Jobs Back to Top

The SAP HANA Installation draws an average salary of $117,000 per year depending on their knowledge and hands-on experience.

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.

SAP HCM Payroll Consultant.

SAP SF / HCM – Manager.

SAP HCM Consultant.

 

Interview Questions Back to Top

1. What is SAP HANA?

SAP HANA is an in-memory database.

·       It is a combination of hardware and software made to process massive real-time data using in-memory computing.

·       It combines row-based and column-based database technologies.

·       Data now resides in the main memory (RAM) and no longer on a hard disk.

 

·       It is best suited for performing real-time analytics and developing and deploying real-time applications.

 

2. Compare SAP HANA with Oracle.

Criteria

SAP HANA

Oracle

Strengths

Customization, customer service, and functionality

Ease of use, quick deployment, and flexibility

Compatibility to work with other databases

Very Good

Average

Comparison based on costs

Higher for internal resources and training

Much lesser on both fronts

 

3. Why choose SAP HANA?

SAP HANA is one of the fastest growing products in SAP history and is viewed by the industry as a breakthrough solution for in-memory databases. SAP HANA claims that it accelerates analytics and applications on a single, in-memory platform, as well as combining databases, data processing, and application platform capabilities.

SAP HANA is the next-generation business platform that brings together:

·       Business transactions

·       Advanced analytics

·       Social media

·       Mobile experience

·       Collaborative business

·       Design connections

 

4. What is SAP HANA Studio?

·       SAP HANA Studio is an Eclipse-based development and administration tool for working with HANA.

·       It enables technical users to manage the SAP HANA database, create and manage user authorizations, create new or modify the existing models of data, etc.

·       It is a client tool, which can be used to access the local or remote HANA system.

 

5. What are the supported platforms for HANA Studio?

SAP HANA Studio runs on the Eclipse platform 3.6. We can use SAP HANA Studio on the following platforms:

·       Microsoft Windows x32 and x64 versions of: Windows XP, Windows Vista, and Windows 7

·       SUSE Linux Enterprise Server SLES 11: x86 64-bit version

Note: For Mac OS, HANA Studio is available, but there is no HANA client for that.

 

6. What is SAP HANA 1.5, 1.2, and 1.0 SP03?

They are all the same, and 1.0 SP03 is touted to be the final name that should go into Ramp Up (beta) in Q4 2011. This allows any SAP NetWeaver BW 7.3 Data Warehouse to be migrated into a HANA appliance. HANA 1.0 SP03 specifically accelerates BW calculations and planning, which means that even more performance results can be attained.

 

7. What is a restricted user in SAP HANA system?

Restricted users are those users who access the HANA system with some applications, but they don’t have SQL privileges on the HANA system. When these users are created, they don’t have the access initially.

If we compare restricted users with standard users:

·       Restricted users can’t create objects in the HANA database or their own schemas.

·       They don’t have access to view any data in the database as they don’t have the generic public role added to their profiles as for standard users.

·       They can connect to the HANA database only using HTTP/HTTPS.

 

8. What is Schema in SAP HANA?

A database schema is a way to logically group objects such as tables, views, stored procedures, etc. There are three types of schemas.

·       User-defined Schema: These are created by a user (DBA or System Administrator).

·       System-defined Schema: These schemas are delivered with the SAP HANA database and contain the HANA system information. There are system schemas like _SYS_BIC, _SYS_BI, _SYS_REPO,_SYS_STATISTICS, etc.

·       SLT-derived Schema: When SLT is configured, it creates a schema in the HANA system. All tables replicated into the HANA system are contained in this schema.

 

9. What is the maximum number of tables in a Schema in SAP HANA?

The maximum number of tables in a schema in SAP HANA is 131,072.

 

10. What is the maximum number of columns in a table in SAP HANA?

The maximum number of columns in a HANA Table is 1,000.

 

11. What is Schema Mapping in SAP HANA?

Schema mapping is done when the physical schema in the target system is not the same as the physical schema in the source system.

Suppose, we are moving components from the development system (DEV) to the production system (PROD). The tables in DEV reside in DEV_SCHEMA and the same tables should reside in the PROD system in PROD_SCHEMA. If an Attribute View is transported from DEV to PROD, it will not work because the schema name is referenced in the definition of the Attribute View. In order for the promoted objects to work in PROD, schema mapping needs to be set-up in the target system.

Note: Schema mapping only applies to references from repository objects to catalog objects. It is not intended to be used for repository-to-repository references.

 

12. What are the system requirements for SAP HANA?

·       Java JRE 1.6 or 1.7 must be installed to run SAP HANA Studio.

·       Java runtime must be specified in the PATH variable.

·       We should make sure to choose the correct Java variant for the installation of SAP HANA Studio:

o   For 32-bit installation, choose a 32-bit Java variant

o   For 64-bit installation, choose a 64-bit Java variant

 

13. Explain Meta Data, Master Data, and Transaction Data.

·       Meta Data: Metadata is data about the data. It tells us about the structure of data or Metaobjects.

·       Master Data: This is the key business information such as information regarding customers, employees, materials, etc. This is more like a reference data. For example, suppose, a customer orders 10 units of our product. Instead of asking the customer for the shipping address 10 times, the same can be referenced from the Customer Master Data.

·       Transaction Data: This is data related to day-to-day transactions.

 

14. What is a Delivery Unit in SAP HANA?

Delivery Unit (DU) is a container used by the Life Cycle Manager (LCM) to transport repository objects between the SAP HANA systems. The name of the Delivery Unit must contain only capital letters (A–Z), digits (0–9), and underscore (_).

 

15. Why do we configure Import Server in SAP HANA?

In order to load data from external sources to SAP HANA, we need to establish a connection with the server. To connect, we need to provide the details of the BusinessObjects Data Services repository and ODBC drivers. Once the connection is established, we can import the table definition and then load data into the table definition.

 

16. What is SAP HANA Appliance 1.0?

SAP HANA 1.0 is an analytics appliance that consists of certified hardware, an in-memory database (IMDB), an analytics engine, and some tooling for getting data in and out of HANA. The logic and structures are built by the user and a tool is used, e.g., SAP Business Objects, to visualize or analyze data.

 

17. What is the prerequisite for Unit of Measure in SAP HANA?

We need to import the tables T006 and T006A for Unit of Measures.

 

18. Explain Column stores and Row stores in HANA.

HANA supports both types of data stores in the database. A row store is used when we need to use the Select statement and no aggregations are performed.

A column store is used to perform aggregations, and HANA Modeling is supported only on column-based tables.

 

19. Which operating system is supported by the HANA system?

The only operating system that is supported by HANA is Suse Linux Enterprise Server SP1/SP2 (SLES SP1/2).

 

20. What are the different license key types in the HANA system? Mention their validity.

·       Temporary License Key: Temporary license keys are automatically installed when we install the HANA database. These keys are valid only for 90 days, and we should request for permanent license keys from SAP before they expire.

·       Permanent License Key: Permanent License keys are valid till the predefined expiration date. License keys specify the amount of memory licensed to the target HANA installation.

 

21. What is the difference between a Catalog tab and a Content tab?

·       Catalog: This contains RDBMS objects like schemas, tables, views, procedures, etc. We can open the SQL editor and design the database objects.

·       Content: This is used to maintain and design time repository. We can create new packages and design Information views in the HANA system. Various views can be created under the content tab to meet business requirements and create analytical reports on top of the Modeling views.

 

22. What are the different perspectives available in HANA?

·       Modeler: Used for creating various types of views and analytical privileges

·       SAP HANA Development: Used for programming applications for creating development objects to access or update data models such as Server-side JavaScript or HTML files

·       Administration: Used to monitor the system and change settings

·       Debug: Used to debug code such as SQL Script (.procedure files) or Server-side JavaScript (.xsjs files)

 

23. What are the supported object types in Modeler perspective?

The supported object types in Modeler perspective are Attribute Views, Analytic Views, Calculation Views, Analytical Privileges, Procedures, Decision Tables, and Process Visibility Scenario.

 

24. What is the main SAP HANA database component?

The main SAP HANA database component is Index Server that consists of actual data engines for data processing, including input SQL and MDX statements, and performs authentic transactions.

 

25. Explain Parallel Processing in SAP HANA.

Using the columnar data storage approach, the workload in SAP HANA is divided vertically. The columnar approach allows linear searching and aggregation of data unlike the two-dimensional data structure. If more than one column is to be processed, then each task is assigned to a separate processor. Operations on one column are then collimated by column divisions processed by different processors.

 

26. Can the table size in SAP HANA database and in the source system be the same?

No, because a HANA database supports compression.

 

27. What is SQL Script?

It is a set of SQL extensions for SAP HANA database that allows developers to push data-intensive logic into the database.

 

28. When should the SQL Script be used?

SQL Script should be used in cases where other modeling constructs of HANA, such as Attribute Views or Analytic Views, are not sufficient.

 

29. What is Label Mapping?

We can choose to associate an attribute with another attribute description. Label mapping is also called Description mapping. For example, if A1 has a label column B1, then we can rename B1 to A1.description. The related columns appear side by side during data preview.

 

30. What are the different types of Joins?

A Join clause combines records from two or more tables/views in a database.
SAP HANA supports the following types of Joins.

·       Inner Join: It selects the set of records that matches in both tables. Inner join should be used if referential integrity is ensured. It is much faster than Outer Join.

o   In Attribute Views, Inner Join can be used to join different Master Data tables into a joint dimension.

o   In Analytic Views, it can be used if referential integrity cannot be ensured.

·       Left Outer Join: It selects the complete set of records from the first table (say, CUSTOMER), with the matching records (if available) from the second table (say, SALES_ORDER). If there is no match, the right side will contain ‘null.’

·       Right Outer Join: It selects the complete set of records from the second table (SALES_ORDER), with the matching records (if available) from the first table (CUSTOMER). If there is no match, the left side will contain ‘null.’

·       Full Outer Join: It selects all rows from the left table (CUSTOMER) and from the right table (SALES_ORDER). The FULL OUTER JOIN keyword combines the results of both LEFT OUTER and RIGHT OUTER joins.

·       Referential Join: It is semantically an Inner Join that assumes that referential integrity is given (referential integrity is the property of a database which ensures that each foreign key value in a table exists as a primary key in the referenced table). Referential Join is, performance-wise, better than Inner Join, but should only be used when we are sure that referential integrity is maintained.

·       Text Join: Text Join is used in order to get language-specific data. Suppose, we have a PRODUCT table that contains product IDs without descriptions and a TEXT table that contains language-specific descriptions for each product. We can deploy a Text Join between the two tables to get the language-specific details of each product, along with its ID. In Text Join, the right table should be the TEXT table, and it is mandatory to specify the Language Column.

 

31. What are Analytic Privileges?

Analytic Privileges restrict users to view data for which they authorize. SAP HANA Analytic Privileges are used for security purposes. They are used to provide authorization on Attribute Views, Analytic Views, and Calculation Views.

Although SQL Privileges provide authorization at the object level, they do not provide authorization at the record level, so to provide both record-level and object-level authorizations SAP HANA Analytic Privileges can be used.

 

32. What is an Attribute?

An attribute represents the descriptive data used in modeling, e.g., city, country, etc.

 

33. What is an Attribute View?

An Attribute View is used to model an entity based on the relationship between the attribute data that resides in multiple source tables. We can model columns, calculated columns, and hierarchies.

 

34. What are the advantages of an Attribute View?

·       An Attribute View acts as a Master Data context, which provides text or description for a key/non-key field.

·       It can be reused in an Analytic View or in a Calculation View.

·       An Attribute View is used to select a subset of columns and rows from a database table.

·       Attributes (fields) can be calculated from multiple table fields.

·       There is no measure and aggregation option.

 

35. What are the types of Attribute Views?

·       Standard Attribute View: It is an Attribute View that is created by table fields.

·       Time Attribute View: It is an Attribute View, which is based on the default time table

·       Derived Attribute View: It is an Attribute View, which is derived from another existing Attribute View. Derived Attribute View will be opened in the read-only mode. The only editable field is its description.

 

36. Explain each part of the Information View editor.

·       Scenario Pane: In this pane, the following nodes exist:

o   Semantics: This node represents the output structure of the view. Here, it is Dimension

o   Data Foundation: This node represents the table that we use for defining the Attribute View. Within this node, we drop the table for creating the Attribute View

·       Details Pane: In this pane, we have three tabs, Columns, View Properties, and Hierarchies. Inside Columns, there are ‘Local’ and ‘Show’ tabs

o   Local: Here, all local attribute details will be displayed

o   Show: Here, we can filter for the local attributes

 

37. Which engine is used to create an Attribute View?

Join Engine is used to create an Attribute View.

·       This engine is used when we execute any Attribute View in HANA or run native SQL on more than one table with a join condition.

·       If there are any calculations involved either in the Attribute View or in native SQL, then Join Engine will use Calculation Engine for calculations and for fetching the result.

 

38. What is a Calculated Attribute?

Calculated attributes are derived from one or more existing attributes or constants, e.g., deriving the full name of a customer (both first name and last name). It is a read-only field, the value of which is calculated based on a specified formula.

 

39. What is a Calculation View?

SAP HANA Calculation View is a powerful information view.

SAP HANA Analytic View measure can be selected from only one fact table. When there is a need for more fact tables in the information view, then Calculation View comes into the picture.

 

40. What are the characteristic of SAP HANA Calculation View?

·       Unlike other View, Calculation Views support complex calculations.

·       They are used to consume Analytic Views, Attribute Views, and other Calculation Views.

·       They support OLTP and OLAP models.

·       Joins, Union, Projection, Aggregation, and Rank are supported.

·       They support client handling, language, currency conversion, etc.

 

41. What are the types of Calculation Views?

·       SAP HANA Graphical Calculation Views (Created by SAP HANA Studio Graphical Editor)

·       SAP HANA SQL Script-based Calculation Views (Created by SAP HANA Studio using SQL Script)

 

42. What are the different types of nodes in a Calculation View?

The different types of nodes in a Calculation View are:

·       Join: This node is used to join two source objects and pass the result to the next node. A Join can be Inner Join, Left Outer Join, Right Outer Join, or Text Join. We can only add two source objects to a Join node.

·       Union: This is used to perform the union of all operations between multiple sources. The source can be n number of objects.

·       Projection: This is used to select columns, filter data, and create additional columns before we use it in the next nodes like Union, Aggregation, and Rank.

·       Aggregation: This is used to perform aggregation on the specific columns based on the selected attributes.

·       Rank: This is the exact replacement for the RANK function in SQL. We can define the partition and order by clause based on the requirement.

 

43. What is Calculation View with Star Join?

Calculation View with Star Join does not allow base Column tables, Attribute Views, or Analytic views to get added at Data Foundation. All Dimension tables must be changed to Dimension Calculation Views to be used in Star Join. All Fact tables can be added and they can use default nodes in Calculation View.

 

44. Can we call an Analytic View or a Calculation View inside another Calculation View in SAP HANA?

Yes. We can call all views (Attribute Views, Analytic Views, and other Calculation Views, as well as tables) inside a Calculation View. Calculation Views are composite views that can be used to combine other views.

 

45. Which engine is used to create a Calculation View?

SQL Engine is used to create a Calculation View.

·       SQL Engine, which is also known as SQL Parser/Interface, is used for all sorts of SQL statements generated by the frontend application via different clients and also for native SQL run at the database level.

·       From SAP HANA SP7 version, we have an option for Calculation Views in the ‘Properties’ section, where we can choose a Calculation View to run in SQL Engine. The advantage of this option is that instead of moving data between multiple engines, HANA executes the entire script in SQL Engine to get the final result.

 

46. What is an Analytic View?

Analytic View is in the form of a star schema, wherein we join one Fact table to multiple Dimension tables. Analytic Views use the real power of SAP HANA to perform complex calculations and aggregate functions by joining tables in the form of a star schema and by executing star schema queries.

 

47. What are the properties of an Analytic View?

Following are the properties of SAP HANA Analytic Views:

·       Analytic Views are used to perform complex calculations and aggregate functions like Sum, Count, Min, Max, etc.

·       They are designed to run star schema queries.

·       Each Analytic View has one Fact table surrounded by multiple Dimension tables. The Fact table contains the primary key for each Dimension table.

·       Analytic Views are similar to InfoObjects and InfoSets of SAP BW.

 

48. What is Star Join in an Analytic View?

Star Join in an Analytic View joins the Attribute View to the Fact table to create a star schema structure, i.e., one central Transaction Data table being surrounded by multiple Master Data tables. It consumes the Fact table forwarded to it from the Data Foundation node and accepts Attribute Views in it. The output columns chosen after creating the Join are forwarded to the Semantics layer. The output table is then made available to the end-user for data analysis.

 

49. Which engine is used to create an Analytic View?

OLAP Engine is used to create an Analytic View.

·       This engine will be called in the backend whenever we run any queries on Analytic Views in SAP HANA.

·       If there are no additional calculations performed, such as calculated columns and restricted measures and counters, then everything will be processed in OLAP Engine.

·       OLAP Engine acts as Join Engine for those Attribute Views used in Analytic Views, without any calculated columns. All Join Engine works will be converted into ‘BwPopJoin’, which is part of OLAP Engine.

·       If there are any calculations present to be performed, then Calculation Engine will be used along with OLAP Engine.

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 17 USD 203)