SQL also known as Structured Query Language, is a domain-specific language used in programming and designed for managing data held in a relational database management system

Check out SQL Command Cheat Sheet for the syntax cheat sheet

Database terms

Record - Each entry that exists in a table

Row and record can be used interchangeably

field - a column in a table containing specific information about every record in the table

relational algebra - allows us to retrieve data efficiently