SQL
SQL stands for Structured Query Language and is used for retrieving and manipulating data in a relational database management system (RDBMS). SQL is a declarative language meaning you don’t tell the computer how to return the data, you tell it what you want the results to look like and the database figures out the best way to deliver those results.
There are multiple variants or dialects of SQL built by different companies which are built on top of the SQL Standard. They are roughly 95% similar in terms of syntax but each database may interpret them differently leading to optimization differences between databases. It’s typically not important to learn more than one, especially when you are just getting started. However, when you get more advanced it will be helpful to know the differences as you will likely start using different types of databases for different use cases.
The most common variants are:
- [[T-SQL]] ([[Microsoft SQL Server]])
- [[PostgreSQL]] ([[PostgreSQL]])
- [[MySQL]] ([[MySQL]])
![[Learning Resources#SQL Learning Resources]]