Building & foundations
For a solid base to build on
Designing a database properly, and getting comfortable asking it questions.
- Designing & building tables: CREATE TABLE, data types, keys and relationships done properly.
- Indexes & integrity: the indexing and constraints that keep data fast and correct.
- Your first queries: SELECT, INSERT, UPDATE and DELETE, filtering with WHERE and wildcards.
- Joining tables: pulling related data together, the single most useful thing SQL does.
- Finding your way around SSMS: the tool you’ll actually be sitting in front of.

