SQl Commands
Parmeshwar Salunke
Data Engineer II ,Bigdata Developer Pyspark| Spark | Scala | Hive | Sqoop | Hbase | Aws | S3 | Sql | Athena | Glue | Maprduece | Aws Redshift | DSA |Aws Emr |
1> DDL (Data Definition Language)
> These commands interact with Database directly.
1. CREATE
2. ALTER
3. TRUNCATE
4. RENAME
5. DROP
6. FLASHBACK
7. PURGE
8. COMMENT
2> DML (Data Manipulation Language)
> These commands dal with data only. Manipulation means add, delete, short etc. these commands deal with buffer . whatever you work do, its saved in buffer initially. after commit all content moved in database.
1. SELECT
2. INSERT
3. UPDATE
4. DELETE
3> TCL (Transaction Control Language)
> These commands deal with DML operation .
every transaction start with DML commands.
1. COMMIT
2. ROLLBACK
3. SAVEPOINT
4> DCL (Data Control Language)
> These commands deal with database directly.
1. GRANT
2. REVOKE
3. SET ROLL
𝐅𝐨𝐮𝐧𝐝𝐞𝐫 & 𝐂𝐄𝐎 @𝐒𝐞𝐞𝐤𝐡𝐨 𝐁𝐢𝐠𝐝𝐚𝐭𝐚 𝐈𝐧𝐬𝐭𝐢𝐭𝐮𝐭𝐞, 𝐁𝐢𝐠𝐝𝐚𝐭𝐚 𝐓𝐫𝐚𝐢𝐧𝐞𝐫
2yReach ++