SQL – stands for Structured Query Language
SQL is used to manage relational databases.
Some of the actions that you can perform on a table inside a database using SQL include:
- INSERT (adding a new record)
- DELETE (deleting an existing record)
- UPDATE (updating an existing record)
- MODIFY (updating an existing record or adding a new one if it doesn’t exist)
DB, Table & Record – Example
If we compare a database with a drawer unit, each drawer represents a table and each file inside that drawer represents a record. Each record has fields that correspond to the columns of the table that contain that record.
Example:
- Database: ITCompanyDB
- Tables: Customers, Suppliers, Inventory
- Record:
- Customer record: John Doe (name), 30 (age), Programmer (profession)
- Supplier record: ElectronicDevicesCo. (supplier name), New York (city)
- Inventory record: Monitor (type), Dell (brand), 500 (acquisition price)