Creating and managing databases
- How to create a database and a table
- Database schema changes
- Apply migrations programmatically
- Add a foreign key
- How to add indexes
- How to create a composite primary key
- Inheritance mapping
Queries
- Basic SELECT queries
- SELECT queries involving multiple tables
- Aggregate SELECT queries
- How to use table-valued parameters (TVP)