corner corner
banner
home > Corsi in accordo con Pipeline > corso MOC 6231 - Maintaining a Microsoft SQL Server 2008 Database 2008

Catalogo corsi

  catalogo corsi
     

Segnalaci il tuo interesse per questo corso compilando questo modulo

 

calendario corsicatalogo corsi

Thecla su Facebook
Diventa nostro fan su Facebook

newsletter

 

Corso MOC 6231 - Maintaining a Microsoft SQL Server 2008 Database 2008

2008 Microsoft
Categoria Corsi MOC in accordo con Pipeline Livello
Prerequisiti
 
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.
 
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
 
Corso di gruppo
Corso personalizzato (1 o 2 partecipanti)
35 ore
non previsto
min. 5 - max. 10 partecipanti
2 persone: sconto del 50%
Corso individuale a distanza su VoIP
non previsto
 
 
corner corner
 
Mappa del sito
 
©2017 Thecla Informatica di Silvia Montanari - Strada Malchioda 42, 29121 Piacenza - P. IVA 01173520337