Maintaining a Microsoft SQL Server 2008 Database

(Start)Datum	Locatie	Inschrijven
02 July 2012	Eindhoven
01 October 2012	Eindhoven
05 November 2012	Amsterdam
03 December 2012	Nieuwegein

Description:
This five-day course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2008 database. The course focuses on teaching individuals how to use SQL Server 2008 product features and tools related to maintaining a database.

Target Audience:
This course is intended for IT Professionals who administer and maintain SQL Server databases.

Duration:
5 day

Pre-Requisites:
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.

Objectives:

• Introduction to SQL Server 2008 R2 and its Toolset
  • Introduction to SQL Server Platform
  • Working with SQL Server Tools
  • Configuring SQL Server Services
• Preparing Systems for SQL Server 2008 R2
  • Overview of SQL Server 2008 R2 Architecture
  • Planning Server Resource Requirements
  • Pre-installation Testing for SQL Server 2008 R2
• Installing and Configuring SQL Server 2008 R2
  • Preparing to Install SQL Server 2008 R2
  • Installing SQL Server 2008 R2
  • Upgrading and Automating Installation
• Working with Databases
  • Overview of SQL Server Databases
  • Working with Files and Filegroups
  • Moving Database Files
  • Module 5: Understanding SQL Server 2008 R2 Recovery Models
  • Backup Strategies
  • Understanding SQL Server Transaction Logging
  • Planning a SQL Server Backup Strategy
• Backup of SQL Server 2008 R2 Databases
  • Backing up Databases and Transaction Logs
  • Managing Database Backups
  • Working with Backup Options
• Restoring SQL Server 2008 R2
  • Understanding the Restore Process
  • Restoring Databases
  • Working with Point-in-time Recovery
  • Restoring System Databases and Individual Files
• Importing and Exporting Data
  • Transferring Data To/From SQL Server 2008 R2
  • Importing & Exporting Table Data
  • Inserting Data in Bulk
• Authenticating and Authorizing Users
  • Authenticating Connections to SQL Server
  • Authorizing Logins to Access Databases
  • Authorization Across Servers
• Assigning Server and Database Roles
  • Working with Server Roles
  • Working with Fixed Database Roles
  • Creating User-defined Database Roles
• Authorizing Users to Access Resources
  • Authorizing User Access to Objects
  • Authorizing Users to Execute Code
  • Configuring Permissions at the Schema Level
• Auditing SQL Server Environments
  • Options for Auditing Data Access in SQL Server
  • Implementing SQL Server Audit
  • Managing SQL Server Audit
• Automating SQL Server 2008 R2 Management
  • Automating SQL Server Management
  • Working with SQL Server Agent
  • Managing SQL Server Agent Jobs
• Configuring Security for SQL Server Agent
  • Understanding SQL Server Agent Security
  • Configuring Credentials
  • Configuring Proxy Accounts
• Monitoring SQL Server 2008 R2 with Alerts and Notifications
  • Configuration of Database Mail
  • Monitoring SQL Server Errors
  • Configuring Operators, Alerts and Notifications
• Performing Ongoing Database Maintenance
  • Ensuring Database Integrity
  • Maintaining Indexes
  • Automating Routine Database Maintenance
• Tracing Access to SQL Server 2008 R2
  • Capturing Activity using SQL Server Profiler
  • Improving Performance with the Database Engine Tuning Advisor
  • Working with Tracing Options
• Monitoring SQL Server 2008 R2
  • Monitoring Activity
  • Capturing and Managing Performance Data
  • Analyzing Collected Performance Data
• Managing Multiple Servers
  • Working with Multiple Servers
  • Virtualizing SQL Server
  • Deploying and Upgrading Data-Tier Applications
• Troubleshooting Common SQL Server 2008 R2 Administrative Issues
  • SQL Server Troubleshooting Methodology
  • Resolving Service-related Issues
  • Resolving Concurrency Issues
  • Resolving Login and Connectivity Issues