SQL

The standard language for defining, querying and changing data in a relational database.

In more detail

SQL stands for Structured Query Language. It is declarative: you describe the result you want and the database decides how to fetch it, which is why a query keeps working as data grows. The core is an international standard, and every database adds its own extensions, so SQL written for one database may need changes for another.

Examples

In AWS: The standard language for defining, changing and querying data in relational databases.
In the course, SELECT, INSERT, WHERE and ORDER BY queries run against a small SQLite database kept in memory.
Mocks cannot prove SQL behaviour; Testcontainers can.
INSERT INTO orders (item) VALUES ('keyboard')
Many SIEM query languages can express the same joins and counts that SQL does, so a detection written as SQL, such as successes after five failures from one address, translates readily.
The SQL course marks every place where SQLite and PostgreSQL differ.
In this course: Each database engine speaks its own dialect of SQL, so a query that works against a fake or a different engine can still fail against the real one. That is one of the main reasons to test with a real database.

Related terms

Taught in

References

Certification courses