Microsoft Training Courses - Microsoft SQL Server Training

Introduction

During this course, candidates will learn about how to maintain a Microsoft SQL Server 2008 R2 database, how to use its features and how to use the tools involved.

Pre-Requisites

Prior to attending this course, candidates are recommended to have an understanding of Microsoft Windows and the core functionality of the operating system. Also required is a knowledge of Transact-SQL, relational databases, database design and ideally the successful completion of the Querying SQL Databases Using T-SQL course.

Who Should Attend

This course is for employees who develop applications that use SQL server databases to deliver content.

Course Objectives

Upon completion of this course, candidates should gain knowledge on:

• SQL Server architecture and requirements
• Performing checks on I/O systems
• Backing up and restoring databases
• How to plan and install SQL Server 2008 R2
• Assigning permissions
• Auditing database roles
• Agents and jobs
• Database mails, alerts and notifications
• Maintaining databases effectively
• SQL Profiler Traces
• Database Tuning Advisor
• User defined database roles
• Multi-server queries
• Central management servers
• Dynamic Management Views
• Data-tier-applications
• BCP and BULK INSERT and how they help with importing data
• Using import and export wizards
• Security management
• How to recognise and solve common issues and errors

Course Outline

The units in this course include:

• Introduction to SQL Server 2008 R2
• Using SQL Server tools
• Backup of SQL Server 2008 R2 Databases
• Configuring Security for SQL Server Agent
• Multiple Server Administration
• Troubleshooting
• Preparing Systems for SQL Server 2008 R2
• Installing and Configuring SQL Server 2008 R2
• Restoring SQL Server 2008 R2 Databases
• Importing and Exporting Data
• User Management
• Role Assignment for Servers and Databases
• Authorizing Users Access
• Auditing SQL Server Environments
• Automating SQL Server 2008 R2 Management
• 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 Performance
• Working with Databases
• SQL Server 2008 R2 Recovery Models