SQL COMMANDS DATA SCIENTIST MUST KNOW
SQL is used to communicate with a database. According to ANSI (American National Standards Institute), it is the standard language for relational database management systems. SQL statements are used to perform tasks such as update data on a database, or retrieve data from a database.
SQL COMMANDS DATA SCIENTIST MUST KNOW
E N D
Presentation Transcript
SQL COMMANDS DATA SCIENTIST MUST KNOW DATA DEFINITION DATA MANIPULATION CREATE: Used to create table/databases. INSERT: Creates a record in a table. DELETE: Delete rows or the entire table. ALTER: Used to modify values in tables. UPDATE: To modify records in a table. DROP: Deletes a table from the database. SELECT: Retrieves records from a table. TRUNCATE Deletes all rows from a table. TRANSACTION CONTROL LANGUAGE DATA CONTROL LANGUAGE COMMIT: Save changes to the database. GRANT: Used to provide privileges to database objects for a user ROLLBACK: Undo changes made to the database. REVOKE: Withdraw user privileges on database objects if any granted. SAVEPOINT: Creates a rollback point in your transaction. www.Learnbay.co
