You are here:Courses|Microsoft|MCTS Certification|Microsoft SQL Server 2008, Implementation and Maintenance

Microsoft SQL Server 2008, Implementation and Maintenance

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

 

 

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
Total duration 9
 
 
Exam 70-432 is counted as credit for Microsoft Certified Solution Associate (MCSA): SQL Server 2008.

Prerequisites:

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.

 

Our Location

Get In Touch

1st Floor of CHABAH House,

Chabah Bus Stop on the Odokor-Mallam HighWay

Opposite Total Filling Station

P. O. Box DS 2022

Accra, Ghana

Phone: +233 303 393 1256 / +233 302 325 815

Cell: +233 244036 522

Email:[email protected]