Surface Your Creds How to Participate
dp900
There's 3 type of Relational data SQL:
DDL (Data Definition Language) CREATE, DROP, ALTER, RENAME, COMMENT AND TRUNCATE.
DML (Data Manipulación Language) SELECT, INSERT INTO, DELETE, UPDATE. DCL (Data Control Language) REVOKE & GRANT.
TCL (Transaccional Control Language) COMMIT & ROLLBACK
Hot - Optimized for storing data that is accessed frequently.
Cool - Optimized for storing data that is infrequently accessed and stored for at least 30 days.
Archive - Optimized for storing data that is rarely accessed and stored for at least 180 days with flexible latency requirements (on the order of hours).