SQL - Maintaining a Microsoft SQL Server 2008 Database 6231

Course Type

Scheduled:

Date	Location	Duration	Cost
16 Jul 2012 (Mon) 17 Jul 2012 (Tue) 18 Jul 2012 (Wed) 19 Jul 2012 (Thu) 20 Jul 2012 (Fri)	Sunderland	5	£ 1595
All prices exclude VAT

Private:

This outline is available as a private course. Please contact us to arrange this course at a venue and date of your choice.

Private courses can be held at your site or one of our training venues, and can be customised to fit your requirements.

You can choose to have a private course based on an existing outline or you can choose the most applicable lessons from a number of different outlines and consolidate them into one course.

We can also write bespoke courses to fit your specific requirements, whether you require training on a standard application or a bespoke inhouse system.

Please contact us to discuss this further on 0191 377 8377.

Course Overview

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. Target Audience 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

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

Objectives

Delegates 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
Replicate data between SQL Server instances.
Maintain high availability.
Monitor SQL Server.

Related Courses

Course Content

Introduction to SQL Server 2008 R2 and its Toolset

Preparing Systems for SQL Server 2008 R2

Installing and Configuring SQL Server 2008 R2

Working with Databases

Understanding SQL Server 2008 R2 Recovery Models

Backup of SQL Server 2008 R2 Databases

Restoring SQL Server 2008 R2 Databases

Importing and Exporting Data

Authenticating and Authorizing Users

Assigning Server and Database Roles

Authorizing Users to Access Resources

Auditing SQL Server Environments

Automating SQL Server 2008 R2 Management

Configuring Security for SQL Server Agent

Monitoring SQL Server 2008 R2 with Alerts and Notifications

Performing Ongoing Database Maintenance

Tracing Access to SQL Server 2008 R2

Monitoring SQL Server 2008 R2

Managing Multiple Servers

Troubleshooting Common SQL Server 2008 R2 Administrative Issues

Training Options

Scheduled public courses at one of our training venues
Private course at your company office throughout the UK, at one of our training venues (Durham, Newcastle or Washington) or at an independent location, convenient to you
For further information please contact us on 0191 377 8377

What's Included

1 delegate per computer
Lunch and refreshments when training is delivered at our training venue
Comprehensive course manual and exercises

SQL - Maintaining a Microsoft SQL Server 2008 Database 6231, SQL training courses in the North East of England including Durham, Washington, Newcastle, Gateshead, Darlington, training courses for Microsoft SQL Server

"Trainer was excellent and very approachable"
L.C. CLRN - VBA Using Excel

"Excellent as always"
S.W. National Grid - PhotoShop Level 1

"The trainer was excellent, he listened to what we wanted to gain from the course and didn’t waste time trying to teach us things we would never use, he explained in simple terms..."
P.C. Northumbria Police - Excel Level 2

"Great, exactly what I wanted at a level I could understand"
P.A. Straughans - Access Level 1

"Having one-on-one training was unexpected but was a tremendous bonus. Could not fault the day"
D.R. UK Asset Resolution - PowerPoint Level 2

"This is my second course and I have enjoyed both and have another booked for February so I wouldn't change anything"
T.S. Bell Truck and Van - Excel 2007 / 2010 Level 2

"This is my third course and I have enjoyed them all"
T.S. Bell Truck and Van - PowerPoint Level 2

"Knowledge and professionalism of the trainer was excellent, questions encouraged and answered knowledgeably"
J.M. The Cyrenians - VBA using Excel

"I enjoyed the course and was pleased with the speed it progressed"
G.J. NCFE - HTML Level 1

"Very good way to teach. Nice mix of theory and practice"
K.F. Durham University - Access Level 2

View More | Hide