1
A database is an organized collection of information designed to easily access, manage, update, and secure data, consisting of tables made of rows (records) and columns (fields).
2
Relational databases allow data to be combined across tables using primary keys (uniquely identifying a row) and foreign keys (referencing a primary key in another table).
3
ACID is an acronym representing transaction consistency in relational databases: Atomicity, Consistency, Isolation, and Durability.
4
SQL Server Developer Edition is a free version used for local development and practice.
5
Database backups (.bak files) like the AdventureWorks sample database can be restored via SQL Server Management Studio (SSMS) using the Restore Database tool.
6
The SELECT query is the foundational SQL command consisting of clauses such as column lists, FROM, WHERE, ORDER BY, and terminated by a semicolon.