With this introductory SAP HANA SQL tutorial, we will start with learning the SQL implementation on SAP HANA database. SQL is an integral part of working with SAP HANA. So, let us quickly begin with learning some basics of SQL in SAP HANA.<\/p>\n
SQL stands for Structured Query Language which interacts with relational databases. It is a standardized language that is used to store, manipulate and retrieve data from the different relational databases such as Oracle, MySQL, etc.<\/p>\n
SAP HANA users can create SQL scripts and apply complex business logic to the database manipulating data as per their requirement.<\/p>\n
For using SQL in SAP HANA, the basic knowledge of SQL includes SQL data types<\/strong>, functions, expressions, operators, sequences, triggers, synonyms, script,\u00a0explain plans, etc.<\/p>\n You can add comments in a SQL script to make notes and improve the understanding of the script. The comments can be added in two ways; either by adding the comment after double hyphens \u201c–\u201d or between \u201c\/*\u201d and \u201c*\/\u201d. Although, the SQL parser ignores the comments.<\/p>\n SAP HANA supports various\u00a0SQL statements\u00a0<\/strong>such as:<\/p>\n We use the data manipulation language (DML) within schema objects to manipulate and manage data in them. Generally used DML keywords are SELECT<\/strong> (to retrieve data from database), INSERT<\/strong> (to add data into a data table) and UPDATE<\/strong> (to update data that already exists in a table).<\/p>\n We use the DDL statements and keywords to define the structure of data in databases and schemas. Commonly used DDL keywords are CREATE<\/strong> (creates objects in the database), ALTER<\/strong> (alters the database structure), DROP<\/strong> (deletes or drops objects from the database).<\/p>\n We use the DCL statements to control user access and privileges to the database. Commonly used DCL keywords are GRANT<\/strong> (to give access privilege to database to the users) and REVOKE<\/strong> (to take back the access privileges given using GRANT command).<\/p>\n Backup and recovery statements enable users to perform backup and recovery operations on the HANA database.<\/p>\n Access control statements allow database administrators to create, alter and drop access to the HANA database.<\/p>\n Data import export statements enable import and export operations on data from the HANA database.<\/p>\n These statements enable users to use the SAP HANA database in the form of a JSON document store.<\/p>\n Encryption statements allow database administrators to work with encrypted data in the HANA database.<\/p>\n Tenant database management statements manage the SAP HANA tenant databases.<\/p>\n The procedural statements allow users to manage both the system and user-defined procedures for data in HANA database.<\/p>\n These statements manage transactions in the SAP HANA database.<\/p>\n We use these statements to manage database sessions.<\/p>\n These statements enable users to manage system configuration settings in the HANA database.<\/p>\n These statements manage both the workload classes and mappings.<\/p>\n In SAP HANA, we use SQL statements to perform five basic tasks as mentioned below:<\/p>\n SQL and SQL scripting holds great importance in SAP HANA because a database only understands a standardized language like SQL. Whenever an SAP HANA user wishes to work with data stored in the HANA database, the interaction happens through SQL.<\/p>\n Using SQL keywords, SQL expressions, and SQL functions, one can efficiently access data from the databases, transform it, and perform other management tasks on the system.<\/p>\n In addition to this, while making information models, SQL plays an important role. Especially in creating SAP HANA calculation views<\/strong>, SQL scripting is used to create procedures and apply complex logic and calculations to the data residing in the database.<\/p>\n This concludes our introductory discussion on SQL in SAP HANA. In the upcoming tutorials, we will cover different elements of SQL used in SAP HANA.<\/p>\n Did you like our explanation? We will wait for your feedback and suggestions. See you in our next tutorial!<\/p>\n","protected":false},"excerpt":{"rendered":" With this introductory SAP HANA SQL tutorial, we will start with learning the SQL implementation on SAP HANA database. SQL is an integral part of working with SAP HANA. So, let us quickly begin...<\/p>\n","protected":false},"author":6,"featured_media":55853,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18002],"tags":[19681,19682,19683],"class_list":["post-55830","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sap-hana","tag-sap-hana-sql","tag-sap-hana-sql-statements","tag-sql-tasks-in-sap-hana"],"yoast_head":"\nTypes of SQL Statements in SAP HANA<\/h3>\n
1. Data Manipulation Language Statements<\/h4>\n
2. Data Definition Language Statements<\/h4>\n
3. Data Control Language Statements<\/h4>\n
4. Backup and Recovery Statements<\/h4>\n
5. Access Control Statements<\/h4>\n
6. Data Import Export Statements<\/h4>\n
7. JSON Document Store Statements<\/h4>\n
8. Encryption Statements<\/h4>\n
9. Tenant Database Management Statements<\/h4>\n
10. Procedural Statements<\/h4>\n
11. Transaction Management Statements<\/h4>\n
12. Session Management Statements<\/h4>\n
13. System Management Statements<\/h4>\n
14. Workload Management Statements<\/h4>\n
Key Tasks of SQL in SAP HANA<\/h3>\n
\n
Significance of SQL in SAP HANA<\/h3>\n
Summary<\/h3>\n