Day 12 — SAP HANA SQL

What is SQL in SAP HANA? Why is it important?

SQL (Structured Query Language) is the language used to communicate with the SAP HANA database. It helps developers create, retrieve, update, and delete data. 1. What is SQL? a. Database query language. b. Used to access SAP HANA. c. Easy to learn. d. Supports data manipulation. e. Industry-standard language. 2. What Can We Do Using SQL? a. Create database objects. b. Insert data. c. Retrieve data. d. Update data. e. Delete data. 3. Types of SQL Commands a. DDL (Data Definition Language) b. DML (Data Manipulation Language) c. DCL (Data Control Language) d. TCL (Transaction Control Language) e. Query Commands

A company wants to find all customers from Hyderabad. Using SQL: • The database searches the CUSTOMER table. • Retrieves matching records. • Displays the result instantly.

1. What is SQL? 2. Why is SQL important in SAP HANA? 3. What are the different types of SQL commands? 4. What operations can be performed using SQL? 5. Give one real-time example of SQL.