Database Management System (DBMS) / SQL(STRUCTURED QUERY LANGUAGE)

What is SQL?

🎯 What is SQL?

SQL (pronounced "ess-cue-ell" or sometimes "sequel") stands for Structured Query Language. It is a standard programming language specifically designed for managing and manipulating relational databases.

SQL is used to:

  • Query data: Retrieve specific data from one or more tables (SELECT)

  • Insert data: Add new records (INSERT)

  • Update data: Modify existing records (UPDATE)

  • Delete data: Remove records (DELETE)

  • Create structures: Define tables, indexes, and views (CREATE)

  • Manage access: Control user permissions and security (GRANT, REVOKE)

👍 Common SQL Commands:

Command

Description

SELECT

Retrieves data from a database

INSERT

Adds new data

UPDATE

Changes existing data

DELETE

Removes data

CREATE

Creates a new table or database

DROP

Deletes a table or database

ALTER

Modifies a table’s structure

🌿 Popular SQL-Based Database Systems:

  • MySQL

  • PostgreSQL

  • Microsoft SQL Server

  • Oracle Database

  • SQLite