Corso MOC 6231
|
 |
Hai la Software Assurance? Puoi partecipare GRATUITAMENTE a questo corso! |
Modulo di Iscrizione al Corso MOC 6231
Sei un privato, lavori per la PA o per un partner Microsoft, siete in 2 o più a partecipare al corso?
Scopri le Scontistiche Pipeline - Calcola la tariffa più vantaggiosa per te
Sei interessato ad una attività personalizzata?
- Codice Corso:
- MOC 6231
- Titolo:
- Maintaining a Microsoft SQL Server 2008 R2 Database
- Durata:
- 4.5 giorni
- Documentazione:
- Courseware ufficiale Microsoft Learning n.6231 in lingua inglese
- Importo:
- 1490 Euro+IVA
- Quando:
- 06.02.2012 - 10.02.2012
- Dove:
- Pipeline Padova
- Categoria:
- SQL Server
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
| 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 |
| 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 Databases |
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 |
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.
