MCTS Exam 70 - 432: Microsoft SQL Server 2008 - Implementation and Maintenance

Chapter 1: Installing and Configuring SQL Server 2008;
1.1 Before You Begin;
1.2 Lesson 1: Determining Hardware and Software Requirements;
1.3 Lesson 2: Selecting SQL Server Editions;
1.4 Lesson 3: Installing and Configuring SQL Server Instances;
1.5 Lesson 4: Configuring Database Mail;
1.6 Chapter Review;
1.7 Suggested Practices;
1.8 Take a Practice Test;

Chapter 2: Database Configuration and Maintenance;
2.1 Before You Begin;
2.2 Lesson 1: Configuring Files and Filegroups;
2.3 Files and Filegroups;
2.4 Transaction Logs;
2.5 FILESTREAM data;
2.6 tempdb Database;
2.7 Lesson 2: Configuring Database Options;
2.8 Database Options;
2.9 Collation Sequences;
2.10 Lesson 3: Maintaining Database Integrity;
2.11 Database Integrity Checks;
2.12 Chapter Review;
2.13 Suggested Practices;
2.14 Take a Practice Test;

Chapter 3: Tables;
3.1 Before You Begin;
3.2 Lesson 1: Creating Tables;
3.3 Lesson 2: Implementing Constraints;
3.4 Chapter Review;
3.5 Suggested Practices;
3.6 Take a Practice Test;

Chapter 4: Designing SQL Server Indexes;
4.1 Before You Begin;
4.2 Lesson 1: Index Architecture;
4.3 Lesson 2: Designing Indexes;
4.4 Lesson 3: Maintaining Indexes;
4.5 Chapter Review;
4.6 Suggested Practices;
4.7 Take a Practice Test;

Chapter 5: Full Text Indexing;
5.1 Before You Begin;
5.2 Lesson 1: Creating and Populating Full Text Indexes;
5.3 Lesson 2: Querying Full Text Data;
5.4 Lesson 3: Managing Full Text Indexes;
5.5 Chapter Review;
5.6 Suggested Practices;
5.7 Take a Practice Test;

Chapter 6: Distributing and Partitioning Data;
6.1 Before You Begin;
6.2 Lesson 1: Creating a Partition Function;
6.3 Lesson 2: Creating a Partition Scheme;
6.4 Lesson 3: Creating Partitioned Tables and Indexes;
6.5 Lesson 4: Managing Partitions;
6.6 Chapter Review;
6.7 Suggested Practices;
6.8 Take a Practice Test;

Chapter 7: Importing and Exporting Data;
7.1 Before You Begin;
7.2 Lesson 1: Importing and Exporting Data;
7.3 Bulk Copy Program;
7.4 The BULK INSERT command;
7.5 Chapter Review;
7.6 Suggested Practices;
7.7 Take a Practice Test;

Chapter 8: Designing Policy Based Management;
8.1 Before You Begin;
8.2 Lesson 1: Designing Policies;
8.3 Facets;
8.4 Conditions;
8.5 Policy Targets;
8.6 Policies;
8.7 Policy Categories;
8.8 Policy Compliance;
8.9 Import and Export Policies;
8.10 Chapter Review;
8.11 Suggested Practices;
8.12 Take a Practice Test;

Chapter 9: Backing up and Restoring a Database;
9.1 Before You Begin;
9.2 Lesson 1: Backing up Databases;
9.3 Backup Types;
9.4 Partial Backups;
9.5 Page Corruption;
9.6 Maintenance Plans;
9.7 Certificates and Master Keys;
9.8 Validating a Backup;
9.9 Lesson 2: Restoring Databases;
9.10 Transaction Log Internals;
9.11 Database Restores;
9.12 Lesson 3: Database Snapshots;
9.13 Creating a Database Snapshot;
9.14 Reverting Data Using a Database Snapshot;
9.15 Chapter Review;
9.16 Suggested Practices;
9.17 Take a Practice Test;

Chapter 10: Automating SQL Server;
10.1 Before You Begin;
10.2 Lesson 1: Creating Jobs;
10.3 Job Schedules;
10.4 Job History;
10.5 Operators;
10.6 Lesson 2: Creating Alerts;
10.7 SQL Server Agent Alerts;
10.8 Chapter Review;
10.9 Suggested Practices;
10.10 Take a Practice Test;

Chapter 11: Designing SQL Server Security;
11.1 Before You Begin;
11.2 Lesson 1: TCP Endpoints;
11.3 TCP Endpoints;
11.4 Lesson 2: Configuring the SQL Server Surface Area;
11.5 Lesson 3: Creating Principals;
11.6 Lesson 4: Managing Permissions;
11.7 Lesson 5: Auditing SQL Server Instances;
11.8 Lesson 6: Encrypting Data;
11.9 Chapter Review;
11.10 Suggested Practices;
11.11 Take a Practice Test;

Chapter 12: Monitoring Microsoft SQL Server;
12.1 Before You Begin;
12.2 Lesson 1: Working with System Monitor;
12.3 System Monitor Overview;
12.4 Capturing Counter Logs;
12.5 Performance Counters;
12.6 Lesson 2: Working with the SQL Server Profiler;
12.7 Defining a Trace;
12.8 Specifying Trace Events;
12.9 Selecting Data Columns;
12.10 Applying Filters;
12.11 Managing Traces;
12.12 Correlating Performance and Monitoring Data;
12.13 Lesson 3: Diagnosing Database Failures;
12.14 SQL Server Logs;
12.15 Database Space Issues;
12.16 Lesson 4: Diagnosing Service Failures;
12.17 Finding Service Startup Failures;
12.18 Lesson 5: Diagnosing Hardware Failures;
12.19 Disk Drives;
12.20 Memory and Processors;
12.21 Lesson 6: Resolving Blocking and Deadlocking Issues;
12.22 Locks;
12.23 Transaction Isolation Levels;
12.24 Blocked Processes;
12.25 Deadlocks;
12.26 Chapter Review;
12.27 Suggested Practices;
12.28 Take a Practice Test;

Chapter 13: Optimizing Performance;
13.1 Before You Begin; 11111
13.2 Lesson 1: Using the Database Engine Tuning Advisor;
13.3 Database Engine Tuning Advisor;
13.4 Lesson 2: Working with Resource Governor;
13.5 Resource Governor;
13.6 Lesson 3: Using Dynamic Management Views and Functions;
13.7 DMV Categories;
13.8 Lesson 4: Working with the Performance Data Warehouse;
13.9 Performance Data Warehouse;
13.10 Chapter Review;
13.11 Suggested Practices; 13.12 Take a Practice Test;

Chapter 14: Failover Clustering;
14.1 Before You Begin;
14.2 Lesson 1: Designing Windows Clustering;
14.3 Lesson 2: Designing SQL Server 2008 Failover Cluster Instances;
14.4 Chapter Review;
14.5 Suggested Practices;
14.6 Take a Practice Test;

Chapter 15: Database Mirroring;
15.1 Before You Begin;
15.2 Lesson 1: Overview of Database Mirroring;
15.3 Lesson 2: Initializing Database Mirroring;
15.4 Lesson 3: Designing Failover and Failback Strategies;
15.5 Chapter Review;
15.6 Suggested Practices;
15.7 Take a Practice Test;

Chapter 16: Log Shipping;
16.1 Before You Begin;
16.2 Lesson 1: Overview of Log Shipping;
16.3 Lesson 2: Initializing Log Shipping;
16.4 Lesson 3: Designing Failover and Failback Strategies;
16.5 Chapter Review;
16.6 Suggested Practices;
16.7 Take a Practice Test;

Chapter 17: Replication;
17.1 Before You Begin;
17.2 Lesson 1: Overview of Replication;
17.3 Lesson 2: Transactional Replication;
17.4 Lesson 3: Merge Replication;
17.5 Chapter Review;
17.6 Suggested Practices;
17.7 Take a Practice Test; Glossary;