- Create Database Objects
- Work with Data
- Modify Data
- Create and alter stored procedures
- Modify data by using INSERT, UPDATE, and DELETE statements
- Work with functions (reference 2)
- Troubleshoot and Optimize queries
- Optimize queries
- Manage transactions
- Evaluate the use of row-based operations vs. set-based operations
- Implement error handling
- Install and Configure SQL Server
- Plan installation
- Install SQL Server and related services
- Implement a migration strategy
- Configure additional SQL Server components
- Manage SQL Server Agent
- Maintain Instances and Databases
- Manage and configure databases
- Configure SQL Server instances
- Implement a SQL Server clustered instance
- Manage SQL Server instances
- Optimize and Troubleshoot SQL Server
- Identify and resolve concurrency problems
- Collect and analyze troubleshooting data
- Audit SQL Server instances
70-464: Developing Microsoft SQL Server 2012 Databases
- Implement Database Objects
- Create and alter tables
- Design, implement, and troubleshoot security
- Design the locking granularity level
- Maintain indexes
- Implement data types
- Create and modify constraints
- Work with XML data
- Implement Programming Objects
- Write automation scripts
- Design and implement stored procedures
- Design T-SQL table-valued and scalar functions
- Create, use, and alter user-defined functions (UDFs)
- Create and alter views
- Design Database Objects
- Design tables
- Design for concurrency
- Create and alter indexes
- Design data integrity
- Design for implicit and explicit transactions
- Optimize and Troubleshoot Queries
- Optimize and tune queries
- Troubleshoot and resolve performance problems
- Optimize indexing strategies
- Capture and analyze execution plans
- Collect performance and system information
No comments:
Post a Comment