1. What is SQL?

SQL (Structured Query Language) is a domain-specific language used for managing and interacting with relational databases. It is designed to handle tasks such as querying, updating, and managing data within a database. SQL allows users to retrieve, insert, update, and delete data, as well as create and modify the structure of a database.

Usage of SQL

SQL is used by database administrators, developers, and analysts to interact with databases. It is the primary method for querying databases in applications that involve data storage, such as:

• Web applications (e.g., e-commerce platforms, content management systems)
• Financial systems
• Customer relationship management (CRM) systems
• Enterprise resource planning (ERP) systems

SQL is also used in data analysis, business intelligence, and reporting tools.

Types of SQL (DDL, DML, DCL, TCL)