SQL Server 2008 Corso, Maintaining a SQL2008 Database

Microsoft SQL Server 2008 è l'ultima versione di RDMS di Microsoft per le aziende. Le funzioni di Business-intelligence implementate consentono l'elaborazione con tecnologie di data warehouse.

Obiettivo

Dopo questo seminario sarete in grado di utilizzare e configurare database SQL Server 2008.

Nota

MOC6231, Questo seminario è un EGOS! Clever Track.

Contenuto SQL Server 2008 Corso

Giorno 1	Giorno 2	Giorno 3	Giorno 4	Giorno 5
Installing and configuring SQL Server – Preparation – SQL Server installation – Inital Configuration Managing Databases and Files – Planning Databases – Creating Databases – Using Policy-Based Management	Disaster Recovery – Designing a Backup Strategy – Backup User Databases – Recovery of User Databases – Onlinerestore – Recovery of Data with Database Snapshots – System Databases and Disaster Recovery	Managing Security – SQL Server Security Overview – Securing the Servers – Securing the database – Using Schemas for Security – Monitoring Security Transfering Data – DTS Overview – SQL Server Integration Services Introduction	Automation – Automating Admin-Tasks – SQL Server Agent – Creating Maintenance Plans – Creating Jobs – Implementing Warnings – Multi-Server-Management – Managing SQL Server Agent Security Implementing Replication – Replication Overview – Managing Publications and Subscriptions – Monitoring Replication	High Availability – HA Features Overview – Configuring Log Shipping Feature – Introduction to Database Mirroring – Server Clusters with SQL Server – Using distributed HA Solutions Monitoring SQL Server – Current Activity – Using SQL Server Profiler – Monitoring with DDL Triggers – Using Event Notifications Troubleshooting and Performance Tuning – Troubleshooting SQL Server – Performance Tuning SQL Server – Resource Governor – Using Data Collectors

www.egos.co.at | www.egos.it