SQL (Structured Query Language) commands are instructions to communicate with a relational database management system (RDBMS) to perform various tasks such as data manipulation, data definition, and data control. These commands allow users to perform specific operations on the database, such as creating, altering, and deleting tables, inserting, updating, and retrieving data, setting user permissions, etc. This tutorial will cover some of the most commonly used SQL commands.
SQL Commands
| SQL Command | Description |
|---|---|
| CREATE DATABASE | The CREATE DATABASE command is used to create a new database. |
| CREATE TABLE | The CREATE TABLE command is used to create a new table in the database. |
| ALTER DATABASE | The ALTER DATABASE command is used to modify the structure of a database. |
| ALTER TABLE | The ALTER TABLE command is used to modify the structure of a table. |
| DROP TABLE | The DROP TABLE command is used to delete a table. |
| SELECT | The SELECT command is used to retrieve data from a database. |
| UPDATE | The UPDATE command is used to modify existing records in a table. |
| DELETE | The DELETE command is used to delete records from a table. |
| INSERT INTO | The INSERT command is used to add new records to a table. |
These are just a few examples of the many SQL commands available. Please note that SQL commands are executed in a specific order; First, create a database, then create a table, then you can insert, update, delete or select data from it.
