INPTIC

Liste des Formations

Administration et maintenance d?une base de données MS SQL Server 2008

 

Durée : 5jours

 Programme:

1.   Installing and Configuring SQL Server 2008

·      Preparing to Install SQL Server 2008

·      Installing SQL Server 2008

·      Configuring SQL Server 2008 Installation

·      Installing and Configuring SQL Server 2008

 

2.   Managing Databases and Files

·      Planning Databases

·      Creating Databases

·      Using Policy-Based Management

·      Managing Databases and Files

 

3.   Disaster Recovery

·      Planning a Database Backup Strategy

·      Backing Up User Databases

·      Disaster Recovery-Part A

·      Restoring User Databases

·      Performing Online Restore Operations

·      Recovering Data from Database Snapshots

·      System Databases and Disaster Recovery

 

4.   Managing security

·      Overview of SQL Server Security

·      Protecting the Server Scope

·      Protecting the Database Scope

·      Managing Keys and Certificates

·      Auditing Security

 

5.   Transfering Data

·      Overview of Data Transfer

·      Introduction to SQL Server Integration Services

 

6.   Automating Administrative Tasks

·      Automating Administrative Tasks in SQL Server 2008

·      Using SQL Server Agent

·      Creating Maintenance Plans

·      Implementing Alerts

·      Managing Multiple Servers

·      Managing SQL Server Agent Security

 

7.   Implementing Replication

·      Overview of Replication

·      Managing Publications and Subscriptions

·      Configuring Replication in Some Common Scenarions

 

8.   Maintaining High Availability

·      Introduction to High Availability

·      Implementing Log Shipping

·      Implementing Database Mirroring

·      Implementing Server Clustering

·      Using Distributed High Availability Solutions

 

9.   Monitoring SQL Server

·      Viewing Current Activity

·      Using SQL Server Profiler

·      Monitoring with DDL Triggers

·      Using Event Notifications

 

 

 

 

 

 

 

.

Avec l'INPTIC, DEVELOPPER  vos compétences !!