Categories of SQL command to know for Data Analysis
Categories of SQL command to know for Data Analysis
SQL | DDL, DQL, DML, DCL and TCL Commands
SQL | DDL, DQL, DML, DCL and TCL Commands
SQL Commands 4 categories
SQL Commands 4 categories
1. DDL – Data Definition Language2. DQl – Data Query Language3. DML – Data Manipulation Language4. DCL – Data Control Language
1. DDL – Data Definition Language2. DQl – Data Query Language3. DML – Data Manipulation Language4. DCL – Data Control Language
DDL (Data Definition Language):
DDL (Data Definition Language):
– CREATE: This command is used to create the database or its objects– DROP: This command is used to delete objects from the database.– ALTER: This is used to alter the structure of the database
– CREATE: This command is used to create the database or its objects– DROP: This command is used to delete objects from the database.– ALTER: This is used to alter the structure of the database
DQL (Data Query Language):
DQL (Data Query Language):
– SELECT: It is used to retrieve data from the database.
– SELECT: It is used to retrieve data from the database.
DML(Data Manipulation Language):
DML(Data Manipulation Language):
– INSERT : It is used to insert data into a table.
– UPDATE: It is used to update existing data within a table.
– DELETE : It is used to delete records from a database table.
– INSERT : It is used to insert data into a table.– UPDATE: It is used to update existing data within a table.– DELETE : It is used to delete records from a database table.
DCL (Data Control Language):
DCL (Data Control Language):
– GRANT: This command gives users access privileges to the database.– REVOKE: This command withdraws the user’s access privileges given by using the GRANT command.
– GRANT: This commandgives users access privileges to the database.– REVOKE: This command withdraws the user’s access privileges given by using the GRANT command.
– Easy to Learn
– Step by step guide
– No Coding or Experience required
– Education from any field
– Work on Live projects
– Apply for jobs 100% Placement Assistance
– Easy to Learn– Step by step guide– No Coding or Experience required– Education from any field– Work on Live projects– Apply for jobs 100% Placement Assistance