Create and alter tables using T-SQL syntax (simple statements)
Create and alter views (simple statements)
Design views
Create and modify constraints (simple statements)
Create and alter DML triggers
- Create tables without using the built in tools; ALTER; DROP; ALTER COLUMN; CREATE
Create and alter views (simple statements)
- Create indexed views; create views without using the built in tools; CREATE, ALTER, DROP
Design views
- Ensure code non regression by keeping consistent signature for procedure, views and function (interfaces); security implications
Create and modify constraints (simple statements)
- Create constraints on tables; define constraints; unique constraints; default constraints; primary and foreign key constraints
Create and alter DML triggers
- Inserted and deleted tables; nested triggers; types of triggers; update functions; handle multiple rows in a session; performance implications of triggers