Course Topics

• 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
• Query data by using SELECT statements
• Implement sub-queries
• Implement data types
• Implement aggregate queries
• Query and manage XML data
• Create and alter stored procedures (simple statements)
• Modify data by using INSERT, UPDATE, and DELETE statements
• Combine datasets
• Work with functions
• Manage transactions
• Evaluate the use of row-based operations vs. set-based operations
• Implement error handling