Doel

Deze cursus (level 300) verschaft database administrators de kennis en vaardigheden om een volledige database-oplossing gebaseerd op SQL Server 2008 te ontwerpen, optimaliseren en onderhouden.

Module 1 - Designing an Administrative Solution for SQL Server 2008:

• Overview of SQL Server 2008
• Designing an Administrative Solution
• Developing and Deploying an Administrative Solution for SQL Server 2008
• Implementing an Administrative Solution in SQL Server Management Studio (SSMS).

Module 2 - Deploying SQL Server 2008:

• System Requirements for SQL Server 2008
• Upgrading and Migrating to SQL Server 2008
• Configuring Instances in SQL Server 2008.

Module 3 - Designing the Physical Structure of SQL Server 2008:

• Introduction to the Physical Structure of a Database
• Planning for Partitioning
• Planning for Full-Text Indexing.

Module 4 - Designing a Strategy for Maintaining a Database in SQL Server 2008:

• Designing a Strategy for Maintaining Statistics for a Database
• Designing a Strategy for Maintaining Indexes
• Designing a Strategy for Database Compression.

Module 5 - Designing Solutions for Managing SQL Server 2008:

• Designing a Policy-Based Management Strategy
• Controlling Resource Usage by using Resource Governor
• Auditing Database Changes.

Module 6 - Automating a Database Management Strategy for SQL Server 2008:

• Managing SQL Server Agent
• Automating Administrative Tasks in SQL Server
• Monitoring Events in SQL Server.

Module 7 - Designing a Strategy for Securing SQL Server 2008:

• Securing SQL Server 2008 Instances
• Planning Database Security
• Managing Certificates and Keys in SQL Server 2008
• Implementing Database Encryption.

Module 8 - Designing a Strategy for Monitoring SQL Server 2008:

• Overview of Monitoring SQL Server 2008
• Monitoring SQL Server Instances
• Monitoring SQL Server Databases
• Monitoring Multiple SQL Servers by Using Data Collection.

Module 9 - Designing a Strategy for Content Distribution in SQL Server 2008:

• Distributing Data in SQL Server 2008
• Working with Distributed Queries
• Managing Distributed Content by Using Distributed Transactions
• Managing SQL Server Integration Services (SSIS) Packages
• Setting Up Scalable Shared Databases.

Module 10 - Designing a Strategy for Replication in SQL Server 2008:

• Designing a Database Replication Strategy
• Implementing Content Distribution by Using Replication
• Configuring a High-Availability Solution by Using Replication.

Module 11 - Designing a High-Availability Solution for SQL Server 2008:

• Introduction to High Availability
• Implementing Log Shipping
• Implementing Database Mirroring
• Implementing Failover Clustering
• Designing a High-Availability Strategy.

Module 12 - Designing a Backup and Recovery Strategy for SQL Server 2008:

• Planning a Backup Strategy
• Planning a Recovery Strategy
• Designing a Backup and Recovery Strategy
• Implementing a Repair Strategy.

Lesvorm

De training wordt aangeboden op basis van onze Open Leervorm-lesmethodiek. Dat betekent dat u onder actieve begeleiding van onze trainer zelfstandig aan het werk gaat om u de stof eigen te maken. Zo kunt u in eigen tempo uw leerdoelen behalen zonder daarbij gehinderd te worden door het snellere of langzamere tempo van uw medecursisten. Uiteraard ziet onze trainer erop toe dat u op schema blijft en of de leerdoelen ter voorbereiding op het examen behaald. Deze leervorm biedt ruimte aan een stuk maatwerk. U krijgt de gelegenheid om voorbeelden uit uw eigen praktijk en IT-omgeving in te brengen en zodoende nog specifieker te leren. meer...