This instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2008 R2 database.
The course focuses on teaching individuals how to use SQL Server 2008 R2 product features and tools related to maintaining a database.
After completing this course, students will be able to:
- Explain SQL Server 2008 R2 architecture, resources requirements and perform pre-checks of I/O subsystems
- Plan, install and configure SQL Server 2008 R2
- Backup and restore databases
- Import and export wizards and explain how they relate to SSIS
- Use BCP and BULK INSERT to import data
- Manage security
- Assign, configure fixed database roles and create and assign user defined database roles
- Configure and assign permissions
- Implement SQL Server 2008 R2 Audits
- Manage SQL Server 2008 R2 Agent and Jobs
- Configure database mails, alerts and notifications
- Maintain databases
- Configure SQL Profiler Traces and Use the Database Tuning Advisor
- Monitor data by using Dynamic Management Views
- Execute multi-server queries and configure a central management server
- Deploy a data-tier-application
- Troubleshoot common issues
|Schedule for Microsoft SQL Server 2008, Implementation and Maintenance Boot Camp Training|
|Course#||Course Contents||Exam#||Exam||Regular Track (days)|
|6231B||Maintaining a Microsoft SQL Server 2008 R2 Database||70-432 *||-||6|
|Balance Days for day of arrival, exam(s) and practice||3|
Before attending this course, students must have:
- Basic knowledge of the Microsoft Windows operating system and its core functionality.
- Working knowledge of Transact-SQL.
- Working knowledge of relational databases.
- Some experience with database design.
- Completed Course 2778: Writing Queries Using Microsoft SQL Server 2008 Transact-SQL.