 |
 |
 |
 |
MCITP SQL 2005 DBA 70-443+70-444
Doelgroep
Database-ontwikkelaars met ruime ervaring met SQL Server in een enterprise-omgeving.
Voorkennis
Kennis van en ervaring met SQL Server, bijvoorbeeld MS Certified Technology Specialist voor SQL Server of vergelijkbare ervaring. De volgende cursussen worden aanbevolen:
- Writing Queries Using SQL Server 2005 Transact-SQL (M2778)
- Implementing a SQL Server 2005 Database (M2779)
- Maintaining a SQL Server 2005 Database (M2780).
Kennis van storage types (RAID, SAN), replicatie, query execution plan, (de)normalisatie (t/m 3NF), applicatiearchitecturen, operating system en platform.
Duur
5 dagen - examens niet tijdens training
Globale inhoud
Designing the Hardware and Software Infrastructure. Designing Physical Storage. Designing a Consolidation Strategy. Designing Database-Level Security. Designing Windows Server-Level Security Processes. Designing SQL Server Service-Level Security. Designing SQL Server Object-Level Security. Designing a Physical Database. Creating Database Conventions and Standards. Designing a SQL Server 2005 Solution for High Availability. Designing a Data Recovery Solution for a Database. Designing a Data-Archiving Solution. Optimizing the Performance of Databases and Database Servers. Optimizing the Performance of Queries. Optimizing and Implementing a Data Recovery Plan for a Database. Designing a Strategy to Monitor a Database Solution. Designing a Strategy to Maintain a Database Solution. Designing and Managing SSIS Packages. Designing a Database Data Management Strategy. Designing a Strategy to Manage Replication. Protecting Your SQL Server from Attack. Designing a Strategy to Manage and Maintain Database Security.
|
 |
 |
 |
 |