SAP ERP High Performance Analytic Appliance-HANA Training Course in Pakistan

What is SAP HANA?

SAP HANA is the most recent, in-memory data set, and stage which can be sent on-premises or cloud. SAP HANA is a mix of equipment and programming, which coordinates various parts like SAP HANA Database, SAP SLT (System Landscape Transformation) Replication worker, SAP HANA Direct Extractor association and Sybase replication. HANA has exceptional selection by the SAP clients. SAP HANA is equipped for preparing a lot of continuous information in a brief timeframe period.

SAP HANA Architecture, Landscape and Sizing

SAP HANA Database is Main-Memory driven information the board stage. SAP HANA Database runs on SUSE Linux Enterprises Server and expands on C++ Language. 

SAP HANA Database can be dispersed to numerous machines. 

SAP HANA Advantages are as referenced beneath - 

• SAP HANA is valuable as it's extremely quick because of all information stacked in-Memory and no compelling reason to stack information from plate. 

• SAP HANA can be utilized with the end goal of OLAP (On-line logical) and OLTP (On-Line Transaction) on a solitary information base. 

SAP HANA Database comprises of a bunch of in-memory preparing motors. Estimation motor is primary in-memory Processing motors in SAP HANA. It works with other handling motor like Relational information base Engine(Row and Column motor), OLAP Engine, and so on.

SAP HANA Architecture     

Information is compacted by various pressure procedures (for example word reference encoding, run length encoding, scanty encoding, bunch encoding, circuitous encoding) in SAP HANA Column store. 

At the point when fundamental memory limit is reached in SAP HANA, the entire data set articles (table, view, etc.) that are not utilized will be dumped from the principle memory and saved into the circle. 

These items names are characterized by application semantic and reloaded into principle memory from the circle when required once more. Under ordinary conditions SAP HANA information base oversees dumping and stacking of information consequently. 

Be that as it may, the client can stack and dump information from singular table physically by choosing a table in SAP HANA studio in particular Schema-by right-clicking and choosing the alternative "Dump/Load".

SAP HANA Landscape

"HANA" mean High Performance Analytic Appliance is a mix of equipment and programming stage. 

Because of progress in PC engineering, the more remarkable PC is accessible regarding CPU, RAM, and Hard Disk. 

SAP HANA is the answer for execution bottleneck, in which all information is put away in Main Memory and no compelling reason to habitually move information from circle I/O to principle memory.

SAP HANA Sizing 

Estimating is a term which is utilized to decide equipment prerequisite for SAP HANA framework, like RAM, Hard Disk and CPU, and so on 

The primary significant estimating segment is the Memory, and the second significant measuring segment is CPU. The third principle part is a plate, however estimating is totally reliant on Memory and CPU. 

In SAP HANA execution, one of the basic assignments is to decide the correct size of a worker as indicated by business prerequisite. 

SAP HANA DB vary in estimating with typical DBMS as far as.

• Primary Memory Requirement for SAP HANA ( Memory estimating is dictated by Metadata and Transaction information in SAP HANA) 
• Computer chip Requirement for SAP HANA (Forecast CPU is Estimated not exact). 
• Plate Space Requirement for SAP HANA ( Is determined for information tirelessness and for logging information) 

The Application worker CPU and application worker memory stay unaltered. 

For estimating count SAP has given different rules and strategy to ascertain right size. 

We can use underneath strategy 

• Estimating utilizing ABAP report. 
• Estimating utilizing DB Script. 
• Estimating utilizing Quicksizer Tool.

SAP HANA SQL:

Most RDBMS information base uses SQL as data set language, the explanation of being famous is – it is amazing, merchant autonomous and normalized. SAP HANA additionally underpins SQL. 

In SAP HANA, SQL is the principle data set language. 

What is SAP HANA SQL? 

SQL Stands for Structured Query Language. It is a Standard Language for speaking with Relational information base like Oracle, MySQL and so forth SQL is utilized to store, recover and alter the information in the data set. 

By utilizing SQL in SAP HANA, we can perform following position 

• Diagram definition and use (CREATE SCHEMA). 
• DML Statement (SELECT, UPDATE, INSERT). 
• DDL Statement ( CREATE , ALTER , DROP ) 
• DCL Statement ( GRANT ,REVOKE) 
• Framework Management 
• Meeting Management 
• Exchange Management 

Remark in SQL 

We can add a remark to improve the lucidness and practicality of SQL Statements. Remark can be put on SQL two ways.

• Single Line Comment - Double Hyphens "— ". This is one line remark. 
• Various Line Comment – "/*/".

SAP HANA Identifiers 

Identifiers are utilized to address name in SQL articulation (for example table name, see name, section name, file name, equivalent word name, system name, work name, and so forth) 

There are two sorts of identifiers – delimited identifiers and undelimited identifiers. 

• Delimited Identifiers – It is encased in the delimiter, Double Quotes "". The identifier can contain any character including exceptional character. 
• Undelimited Identifiers – Undelimited identifiers (table name, section name) should begin with a letter and can't contain any images other than a digit or an underscore '_'. 

There are two sorts Quotation mark for delimit as beneath 

• Single Quotation Mark (' ') – It is utilized to delimit the string. 
• Twofold Quotation Mark (" ")- It is utilized for delimiting identifiers.

SAP HANA Operator:

SAP HANA Operator can be utilized for computation, esteem examination or to dole out esteem. SAP HANA Contain beneath administrators.

Arithmetic Operator 

• Expansion (+) 
• Deduction (- ) 
• Augmentation ( * ) 
• Division (/) 

String Operator 

A String Operator is a link administrator which joins two things like strings, articulations or constants into one. 

Two Vertical Bar "||" is utilized as the connection administrator. 

Comparison Operator 

Comparison administrator is utilized to analyze two operand. The following are rundown of Comparison Operator- 

• Equivalent to ( = ) 
• More prominent Than ( > ) 
• Not exactly ( < ) 
• More prominent than or equivalent to ( > = ) 
• Not exactly or equivalent to ( < = ) 
• Not Equal (!= , <> ) 

Logical Operator 

Logical administrator is utilized in search models. 

For example WHERE condition1 AND/OR/NOT condition2 

The following is rundown of consistent administrator – 

• AND, - (for example WHERE condition1 AND condition2) 

In the event that both Condition1 AND Condition2 are valid, Combine condition is genuine else it will bogus. 

• Or on the other hand – (for example WHERE condition1 OR condition2) 

On the off chance that Condition1 OR Condition2 is valid, join condition is valid or bogus if the two Conditions are bogus. 

• NOT - (for example WHERE NOT condition) 

NOT condition is valid If Condition is bogus. 

Set Operators 

• Association - Combines two or many select articulations or question without copy. 
• Association ALL - Combines two or many select articulations or question, including all copy line. 
• Converge - Combines two or many select explanations or question, and return every single regular column. 
• Except - Takes the yield from the primary inquiry and eliminates column chose constantly question.

SAP HANA SQL Function 

SAP HANA Provides following SAP HANA Functions

• Information Type Conversion Function – Data Type transformation work are utilized to change over one information type to another. The following are rundown of Data Type Conversion work 

For example CAST, TO_ALPHANUM, TO_BIGINT, TO_BINARY and so forth 

• Date Time Functions - Date Time Function are utilized to change over Date/Time in an alternate configuration. 

For example – ADD_DAYS, ADD_MONTHS, ADD_SECOND, and so forth 

• Fulltext Functions - Fulltext Functions is utilized for text search. 

For example – SCORE and so forth 

• Number Functions - Number Functions take a numeric worth, or string with numeric characters, as info and return numeric qualities. 

For example – ABS, ROUND, POWER, and so forth 

• String Functions - String Functions accept a string as information, measure them and return an incentive as per work. 

For example (ASCII, CHAR, CONCAT, and so forth) 

• Window Functions – Window Functions let client partition result set of a question into gatherings of columns named window segment. 

For example RANK (), DENSE_RANK (), ROW_NUMBER (), and so on 

• Incidental Function -There are some more capacities, which are utilized for the random work. For example – CONVERT_CURRENCY, CURRENT_SCHEMA, and so on

SAP HANA SQL Expression

SQL Expressions is a statement that can be utilized for bring values back. There are 4 sorts of SQL Expressions

• Case Expressions – In this articulation the client can utilize IF – THEN – ELSE rationale without compose strategy. 
• Capacity Expressions – SQL worked in-capacities can be utilized as Expressions. 
• Total Expressions – In This Expression total capacities is utilized to ascertain a solitary incentive from the estimations of various lines for a section. 

Total Name Description 

COUNT Count the Number of lines returned by the question. 

MIN Return the base estimation of the articulation. 

MAX Return the most extreme estimation of the articulation. 

SUM Return the amount of articulations. 

AVG Return the arithmetical mean of articulations. 

STDDEV Return the Standard Deviation of given articulations as the square foundation of VARIANCE work. 

VAR  Return the fluctuation of articulations as the square of standard deviation 

Subqueries in Expression – A subquery is a select assertion encased in enclosures and utilized in a principle select proclamation as information.

You can visit for more details. Regarding SAP ERP High Performance Analytic Appliance -HANA Training Courses with low fee structure in Lahore Pakistan.

Try to visit for the best SAP ERP Training Institute in Lahore Pakistan.