Digi Academy

Updating Your SQL Server 2005 Skills to SQL Server 2008

Digi Academy
A Milano

Chiedi il prezzo
Chiedi informazioni a un consulente Emagister

Informazioni importanti

Tipologia Corso
Luogo Milano
Inizio Scegli data
  • Corso
  • Milano
  • Inizio:
    Scegli data
Descrizione

Preparing for SQL Server 2008 Reviewing the SQL Server Books Online Tutorials Reviewing SQL Server Books Online After completing this module, students will be able to: Describe the evolution of SQL Server.

Strutture (1)
Dove e quando
Inizio Luogo
Scegli data
Milano
Via Valtellina, 63, 20124, Milano, Italia
Visualizza mappa
Inizio Scegli data
Luogo
Milano
Via Valtellina, 63, 20124, Milano, Italia
Visualizza mappa

Cosa impari in questo corso?

Server
Reporting
Peer to peer
Management
SQL
Data Mining

Programma

Prepare for SQL Server 2008.


Configuration Servers


Policy-Based Management


Creating a Configuration Server


Creating and Applying a Policy


After completing this module, students will be able to:


Create and use a configuration server.


Create and use policies.


Managing Workloads with Resource Governor


Monitoring Performance with the Data Collector


Managing Performance with Plan Freezing


Using Resource Governor


Using the Data Collector


After completing this module, students will be able to:


Manage workloads with Resource Governor.


Monitor performance with the Data Collector.


Manage performance with Plan Freezing.


Encrypting Databases


Auditing All Actions


Using Transparent Data Encryption


After completing this module, students will be able to:


Encrypt databases.


Audit all actions.


Developer Tool Enhancements


Data Type Enhancements


Working with Spatial Data


Using Date and Time Data Types


Using Spatial Data


After completing this module, students will be able to:


Describe the developer tool enhancements in SQL Server 2008.


Use the data type enhancements in SQL Server 2008.


Work with spatial data.


Always On Technologies


Transactional Peer-to-Peer Replication


Configuring Peer-to-Peer Replication


Adding a Replication Node


After completing this module, students will be able to:


Describe the SQL Server 2008 always on technologies.


Implement transactional peer-to-peer replication.


ETL Enhancements


Using Partitioned Tables


Optimizing Data Storage


Using Change Data Capture


Using the MERGE Statement


Working with Partitioned Data


After completing this module, students will be able to:


Describe the ETL enhancements in SQL Server 2008.


Use partitioned tables.


Optimize data storage.


Reporting Services Architecture and Management


Authoring Reports


Report Processing and Rendering


Creating a Report with Report Designer


Managing Reporting Services


After completing this module, students will be able to:


Describe the Reporting Services architecture and management.


Author reports.


Understand report processing and rendering.


Multidimensional Analysis with SQL Server Analysis Services


Data Mining with SQL Server Analysis Services


Implementing Multidimensional Analysis


Implementing Data Mining


After completing this module, students will be able to:


Implement multidimensional analysis.


Implement data mining.



Gli utenti che erano interessati a questo corso si sono informati anche su...
Leggi tutto