Maintaining a Microsoft SQL Server 2008 Database

Descrizione

Questo corso intende fornire agli allievi le conoscenze e le competenze per manutenere un database Sql Server 2008. Il corso si focalizza sulle caratteristiche e sugli strumenti di Sql Server idonei a questo scopo.
Contenuti del Corso

• Installing and Configuring SQL Server Preparing to Install SQL Server
• Installing SQL Server
• Configuring a SQL Server Installation
• Managing Databases and Files Planning Databases
• Creating Databases
• Using Policy-Based Management
• Disaster Recovery Planning a Database Backup Strategy
• Backing Up a User Database
• Restoring User Databases
• Performing Online Restore Operations
• Recovering Data from Database Snapshots
• System Databases and Disaster Recovery
• Managing Security Overview of SQL Server Security
• Protecting the Server Scope
• Protecting the Database Scope
• Managing Keys and Certificates
• Auditing Security
• Transferring Data Overview of Data Transfer
• Introduction to SQL Server Integration Services
• Automating Administrative Tasks Automating Administrative Tasks in SQL Server
• Using SQL Server Agent
• Creating Maintenance Plans
• Implementing Alerts
• Managing Multiple Servers
• Managing SQL Server Agent Security
• Implementing Replication Overview of Replication
• Managing Publications and Subscriptions
• Configuring Replication in Some Common Scenarios
• Maintaining High Availability Introduction to High Availability
• Implementing Log Shipping
• Implementing Database Mirroring
• Implementing Server Clustering Using Distributed High Availability Solutions
• Monitoring SQL Server Viewing Current Activity
• Using SQL Server Profiler
• Monitoring with DDL Triggers
• Using Event Notifications
• Troubleshooting and Performance Tuning Troubleshooting SQL Server
• Performance Tuning in SQL Server
• Using Resource Governor
• Using Data Collector
• Partecipanti
• IT Professional
• Prerequisiti

Per partecipare con profitto a questo corso è consigliabile che gli allievi abbiano frequentato il corso MOC 2778 - Writing Queries Using SQL Server 2008 Transact-SQL
Obiettivi

Al termine del corso gli allievi saranno in gardo di:

• installare e configurare SQL Server 2008;
• gestire i file del database;
• effettuare backup e restore del database;
• gestire la sicurezza;
• trasferire dati da e in Sql Server;
• automatizzare task amministrativi;
• replicare dati tra istanze di Sql Server;
• monitorare il funzionamento di Sql Server.