SQL Basics Part1

  SQL Language Elements.

 

 

 

SQL-  Structured Query Language. SAP HANA DB is a relational database management system and it supports SQL & an extended version of SQL called SQL Scripts.

SQL is standardised, descriptive, optimised and is multi-set oriented (and not single record-based).

SQL language elements can be divided into three categories:

1. DML = Data Manipulation Language
                SELECT, INSERT, UPDATE, DELETE
2. DDL = Data Definition Language
                CREATE, ALTER, DROP, RENAME
3. DCL = Data Control Language
                GRANT, REVOKE

---