Interview Questions

SAP HANA SQL

In this section, we will examine one of the most important element in SAP HANA database system, SQL. SQL stands for Structured Query Language which is a standardized database manipulation language used for communicating with a relational database system. SQL is used to retrieve the data, store or manipulate the data in the database. Following are the different types of SQL queries supported by SAP HANA system,

Data definition and manipulation SQL queries
SQL queries for System management
SQL Queries for Session management
Transaction management SQL queries
SQL Queries for Schema definition and manipulation
The set of SQL extensions, which allow developers to push data into the database, is called SQL scripts.

Data Manipulation Language (DML)

The set of data manipulation SQL queries can be grouped as DML statements. They can be used for managing data within schema objects. Some of the popular DML queries are,

SELECT	This SQL query can fetch data from the database and displays it.
INSERT	This SQL query is used to insert data into any particular database table.
UPDATE	Once the data is stored in a table, those data can be altered with the help of this query

Data Definition Language (DDL)

The complete set of data definition SQL queries can be grouped under the name DDL (Data Definition Language). Following are the popular DDL statements in SQL,

CREATE	This SQL query can create a new table in any desired database.
ALTER	Once the database table is created, it can be altered with the help of this SQL statement.
DROP	The entire table can be deleted with the help of this SQL query.

Data Control Language (DCL)

In order to manage the access and privilege given to the users of SAP HANA system, a certain set of SQL statements are used. They are called as DCL (Data Control Language). Below are the two main DCL statements used in the SAP HANA system,

GRANT	With the help of this SQL query, the access privileges to SAP HANA system are granted to any particular user.
REVOKE	This SQL statement is used for withdrawing the access privileges given to any particular user of SAP HANA system.

How to open SQL console in SAP HANA Studio?

There are two simple ways to open the SQL console in the SAP HANA studio, either you can select the HANA system and click on SQL console option in system view. Or else, you can also open SQL console by right click on Catalog tab or any on any Schema name.

Interested about SAP HANA?
Get in touch with training experts Get Free Quotes