Maintaining a Microsoft SQL Server 2008 Database
Need course dates or locations to suit you? CLICK HERE TO SEND ENQUIRY...  
Maintaining a Microsoft SQL Server 2008 Database

Who should attend
The primary audience for this course is individuals who administer and maintain SQL Server databases. This course can also be helpful for individuals who develop applications that deliver content from SQL Server databases

Prerequisites
The knowledge and skills the delegate should have before attending this course are as follows: 
- 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 MS-2778

Course Objectives
Upon completing this course, the learner will be able to meet these overall objectives: 
- 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 Content
This five-day 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.
 
Need course dates or locations to suit you? CLICK HERE TO SEND ENQUIRY...  
My Location
Results for location are highlighted in the table below. Click here to remove highlight
1-24 of 24
Tip: Click column names to sort. Click start dates to see scheduled days
LocationRegionCourse Start DateNo. DaysWeb price ex.VATCourse Status 
Glasgow Scotland Mon 28 May 12 5£1,665      CLICK TO ENQUIRE
    CLICK TO BOOK
London London Mon 11 Jun 12 5£1,665      CLICK TO ENQUIRE
    CLICK TO BOOK
Newcastle North East Mon 11 Jun 12 5£1,665      CLICK TO ENQUIRE
    CLICK TO BOOK
Manchester North West Mon 18 Jun 12 5£1,665      CLICK TO ENQUIRE
    CLICK TO BOOK
Glasgow Scotland Mon 09 Jul 12 5£1,665      CLICK TO ENQUIRE
    CLICK TO BOOK
Birmingham Midlands Mon 09 Jul 12 5£1,665      CLICK TO ENQUIRE
    CLICK TO BOOK
Manchester North West Mon 16 Jul 12 5£1,665      CLICK TO ENQUIRE
    CLICK TO BOOK
Edinburgh Scotland Mon 23 Jul 12 5£1,665      CLICK TO ENQUIRE
    CLICK TO BOOK
Bristol South West Mon 06 Aug 12 5£1,665      CLICK TO ENQUIRE
    CLICK TO BOOK
Aberdeen Scotland Mon 06 Aug 12 5£1,665      CLICK TO ENQUIRE
    CLICK TO BOOK
Aberdeen Scotland Mon 13 Aug 12 5£1,665      CLICK TO ENQUIRE
    CLICK TO BOOK
Manchester North West Mon 20 Aug 12 5£1,665      CLICK TO ENQUIRE
    CLICK TO BOOK
Birmingham Midlands Mon 03 Sep 12 5£1,665      CLICK TO ENQUIRE
    CLICK TO BOOK
Glasgow Scotland Mon 03 Sep 12 5£1,665      CLICK TO ENQUIRE
    CLICK TO BOOK
Manchester North West Mon 17 Sep 12 5£1,665      CLICK TO ENQUIRE
    CLICK TO BOOK
Aberdeen Scotland Mon 01 Oct 12 5£1,665      CLICK TO ENQUIRE
    CLICK TO BOOK
Edinburgh Scotland Mon 15 Oct 12 5£1,665      CLICK TO ENQUIRE
    CLICK TO BOOK
Manchester North West Mon 15 Oct 12 5£1,665      CLICK TO ENQUIRE
    CLICK TO BOOK
Glasgow Scotland Mon 29 Oct 12 5£1,665      CLICK TO ENQUIRE
    CLICK TO BOOK
Bristol South West Mon 12 Nov 12 5£1,665      CLICK TO ENQUIRE
    CLICK TO BOOK
Birmingham Midlands Mon 12 Nov 12 5£1,665      CLICK TO ENQUIRE
    CLICK TO BOOK
Manchester North West Mon 12 Nov 12 5£1,665      CLICK TO ENQUIRE
    CLICK TO BOOK
Aberdeen Scotland Mon 10 Dec 12 5£1,665      CLICK TO ENQUIRE
    CLICK TO BOOK
Manchester North West Mon 10 Dec 12 5£1,665      CLICK TO ENQUIRE
    CLICK TO BOOK
Tools
 
Key Details
Duration5 days
 
£1,665
per delegate
 
 
Bookings Helpline: 01933 233884 (Monday to Thursday - 8:00am to 5:30pm and Friday 8:00am to 5:00pm).