1 . What is SQL ?
SQL (Structured Query Language) is a standard programming
language and manipulating relational databases. It allows
users to perform various operations on the data stored in
databases.
2. Key Components of SQL
Data Query Language (DQL) : Used to query the
database.
Select : Retrieves data from one or more tables.
Data Definition Language(DDL) : Used to define and
manage database structures.
- CREATE : Creates new tables or databases.
- ALTER : Modifies existing database structures.
- DROP : Deletes tables or databases.