---
title: SQL
slug: concepts/sql
docTags: 
createdAt: 2025-09-09T08:54:36.225Z
---

## What is SQL?

**SQL** (Structured Query Language) is the standard language used to interact with relational databases. It provides a consistent way to:

- **Query data** – `SELECT` statements return specific rows and columns from tables.
- **Modify data **– `INSERT`, `UPDATE`, and `DELETE` statements let you add, change, or remove records.
- **Define structure** – `CREATE` and `ALTER` statements define or update tables, indexes, and other schema objects.
- **Control access** – `GRANT` and `REVOKE` manage permissions for users and applications.

## Why use SQL?

SQL is used in nearly every modern software system that relies on structured data because it is:

- **Standardized**: Works across most relational databases (MySQL, PostgreSQL, Oracle, SQL Server, SQLite).
- **Efficient**: Optimized by database engines to handle very large datasets quickly.
- **Readable**: SQL statements are close to plain English, making them easy to understand, maintain, and review.
- **Reliable**: Ensures **ACID** compliance (Atomicity, Consistency, Isolation, Durability) for safe and predictable data operations.

In software projects, SQL is essential for connecting the application layer to persistent data storage.

## More information

- [PostgreSQL Documentation](https://www.postgresql.org/docs/17/tutorial-sql.html) - For SQL basics
- [PostgreSQL Documentation](https://www.postgresql.org/docs/current/sql.html) - For SQL syntax and behavior. 
- [Configuring a SQL collector](docId\:JGCek7sjj-9dntSxr9Zqt)