Avoid or handle deadlocks. Use optimistic locking appropriately. Write Transact-SQL statements that use joins or subqueries to combine data from multiple tables. Design, create, use, and alter views. Modify data through a view.
Query data through a view.
Create and execute stored procedures to enforce business rules, to modify data in multiple tables, to perform calculations, and to use input and output parameters. Choose appropriate recompile options. Create triggers that implement rules, that enforce data integrity, and that perform cascading updates and cascading deletes. Implement transactional error handling. Create result sets that provide summary data.