It is used to retrieve, store, delete, insert and update data in/from the database. DML Commands: - extracts data from the database - inserts new data into the database CALL - updates data in the database EXPLAIN PLAN - deletes data from the database LOCK DDL - Data Definition Language (CREATE TABLE) It is used to create and modify the structure of database objects in the database. DDL Commands: CREATE creates a new database or index. TRUNCATE – ALTER - alters or changes the database table. COMMENT DROP - deletes the database table RENAME DCL - Data Control Language It is used to create roles, permissions, control access and referential integrity to the database. DCL Commands: - gives access privileges to users of the database. REVOKE withdraws access privileges to users of the database. – TCL - Transactional Control Language It is used to manage different transactions occurring within a database. TCL Commands: COMMIT - Saves the work done so SAVE POINT allows us to break – that the changes or additions are the sql code in to blocks and then reflected in future. name that blocks as save point. ROLLBACK - restores the database SET TRANSACTION values to original state since the last commit. Pros and Cons of SQL: Pros: Cons: Very flexible Requires Detailed Knowledge of the Universal (Oracle, Access, Paradox, Structure of the Database Microsoft, etc) Can Provide Misleading Results Relatively Few Commands to
It is used to retrieve, store, delete, insert and update data in/from the database. DML Commands: - extracts data from the database - inserts new data into the database - updates data in the database - deletes data from the database CALL EXPLAIN PLAN LOCK DDL - Data Definition Language (CREATE TABLE) It is used to create and modify the structure of database objects in the database. DDL Commands: CREATE – creates a new database or index. ALTER - alters or changes the database table. DROP - deletes the database table TRUNCATE COMMENT RENAME DCL - Data Control Language It is used to create roles, permissions, control access and referential integrity to the database. DCL Commands: - gives access privileges to users of the database. REVOKE – withdraws access privileges to users of the database. TCL - Transactional Control Language It is used to manage different transactions occurring within a database. TCL Commands: COMMIT - Saves the work done so that the changes or additions are reflected in future. SAVE POINT – allows us to break the sql code in to blocks and then name that blocks as save point. ROLLBACK - restores the database values to original state since the last commit. SET TRANSACTION Pros and Cons of SQL: Pros: Cons: Very flexible Universal (Oracle, Access, Paradox, Microsoft, etc) Relatively Few Commands to Requires Detailed Knowledge of the Structure of the Database Can Provide Misleading Results
SQL-data-analysis.docx