Omschrijving
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...
Bestemd voor
Ervaren SQL Server (2008) database administrators.
Kosten
€ 2.250,00
Prijzen zijn exclusief 19% btw.