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.
This course is intended for IT Professionals who administer and maintain SQL Server databases.


Objetivos:

No final da acção de formação os participantes deverão estar aptos a:

_ 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.


Conteúdo Programático:
_ Module 1: Introduction to SQL Server 2008 R2 and its Toolset
_ Module 2: Preparing Systems for SQL Server 2008 R2
_ Module 3: Installing and Configuring SQL Server 2008 R2
_ Module 4: Working with Databases
_ Module 5: Understanding SQL Server 2008 R2 Recovery Models
_ Module 6: Backup of SQL Server 2008 R2 Databases
_ Module 7: Restoring SQL Server 2008 R2 Databases
_ Module 8: Importing and Exporting Data
_ Module 9: Authenticating and Authorizing Users
_ Module 10: Assigning Server and Database Roles
_ Module 11: Authorizing Users to Access Resources
_ Module 12: Auditing SQL Server Environments
_ Module 13: Automating SQL Server 2008 R2 Management
_ Module 14: Configuring Security for SQL Server Agent
_ Module 15: Monitoring SQL Server 2008 R2 with Alerts and Notifications
_ Module 16: Performing Ongoing Database Maintenance
_ Module 17: Tracing Access to SQL Server 2008
_ Module 18: Monitoring SQL Server 2008 R2
_ Module 19: Managing Multiple Servers
_ Module 20: Troubleshooting Common SQL Server 2008 R2 Administrative Issues


Requisitos Prévios:
_ 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


Duração: 30 horas / 5 dias



Solicite mais informação

Inscreva-se neste curso