70-461 Exam objectives

70-461 Exam objectives

1. Create Database Objects (24%)
1. Create and alter tables using T-SQL syntax (simple statements).
2. Create and alter views (simple statements).
3. Design views.
4. Create and modify constraints (simple statements).
5. Create and alter DML triggers.
2. . Work with Data (27%)
1. Query data by using SELECT statements.
2. Implement sub-queries.
3. . Implement data types.
4. Implement aggregate queries.
5. Query and manage XML data.
3. Modify Data (24%)
1. Create and alter stored procedures (simple statements).
2. Modify data by using INSERT, UPDATE, and DELETE statements.
3. Combine datasets.
4. Work with functions.
4. Troubleshoot & Optimize (25%)
1. Optimize queries.
2. Manage transactions.
3. Evaluate the use of row-based operations vs. set-based operations.
4. Implement error handling.