|
Formål:
Lær om de nye faciliteter i SQL Server 2008. Kurset er både for administratorer og udviklere med erfaring i SQL Server 2005.
Forudsætninger:
Følgende kurser eller tilsvarende viden:
- MS-2779 Implementing a Microsoft SQL Server 2005 Database
- MS-2780 Maintaining a Microsoft SQL Server 2005 Database
Beskrivelse:
Kurset introducerer de nye faciliteter i SQL Server 2008 inklusive administration, optimering og sikkerhed. Introduktion til nye muligheder for udviklere.
Lærebøger:
Microsoft Official Curriculum (MOC) materiale.
Certificeringer:
- 70-453 Upgrade: Transition Your MCITP SQL Server 2005 DBA to MCITP SQL Server 2008
- 70-454 Upgrade: Transition Your MCPD SQL Server 2005 DBD to MCPD SQL Server 2008 DBD
- 70-455 Upgrade: Transition Your MCITP SQL Server 2005 BI Developer to MCITP SQL Server 2008 BI Developer
Varighed / Pris:
3 dage / 11.100,- kr. (ekskl. moms)
|
Indhold:
- Introduction to SQL Server 2008
- The Evolution of SQL Server
- Preparing for SQL Server 2008
- SQL Server 2008 Manageability Enhancements
- Configuration Servers
- Policy-Based Management
- SQL Server 2008 Performance Enhancements
- Managing Workloads with Resource Governor
- Monitoring Performance with the Data Collector
- Managing Performance with Plan Freezing
- SQL Server 2008 Security Enhancements
- Encrypting Databases
- Auditing All Actions
- SQL Server 2008 Database Development Enhancements
- Developer Tool Enhancements
- Data Type Enhancements
- Working with Spatial Data
- SQL Server 2008 Availability Enhancements
- Always On Technologies
- Transactional Peer-to-Peer Replication
- SQL Server 2008 Data Warehousing Enhancements
- ETL Enhancements
- Using Partitioned Tables
- Optimizing Data Storage
- SQL Server 2008 Reporting Services Enhancements
- Reporting Services Architecture and Management
- Authoring Reports
- Report Processing and Rendering
- SQL Server 2008 Analysis Services Enhancements
- Multidimensional Analysis with SQL Server Analysis Services
- Data Mining with SQL Server Analysis Services
|