This course will teach database administrators and developers advanced database infrastructure design, optimization, maintenance, troubleshooting and security. To get the most out of this course, you should have at least one year of experience working with SQL Server 2008 and have a strong grasp of database administration fundamentals.
Lessons
Lesson 1: Getting Started with Advanced SQL Server 2008 Database Administration
00:03:35
Lesson 2: Lab Setup
00:02:55
Lesson 3: The Course Scenario
00:02:22
Lesson 4: Setup and Installation of SQL Server 2008
00:34:35
Lesson 5: Optimizing SQL Searches with Indexes
01:04:55
Lesson 6: Full-Text Search
00:44:32
Lesson 7: SQL Server 2008 Security
00:50:34
Lesson 8: SQL Server 2008 Policy-Based Management
00:31:53
Lesson 9: SQL Server 2008 Data Encryption
00:45:35
Lesson 10: SQL Server 2008 Backup and Recovery
00:44:11
Lesson 11: SQL Server 2008 High Availability
00:32:42
Lesson 12: SQL Server 2008 Failover Clustering
00:18:44
Lesson 13: SQL Server 2008 Database Mirroring
00:29:26
Lesson 14: SQL Server 2008 Log Shipping
00:37:42
Lesson 15: SQL Server 2008 Replication
01:04:05
Lesson 16: SQL Server 2008 Resource Governor
00:21:52
Lesson 17: Monitoring SQL Server 2008
01:03:28
Lesson 18: SQL Server 2008 Performance Tuning
00:28:18
Lesson 19: SQL Server 2008 PowerShell
00:27:59
Lesson 20: SQL Server 2008 Integration Services
00:32:42
Lesson 21: Preparing for Your MCITP: 70-450 Certification Exam
00:08:57
Lesson 22: Next Steps
00:03:36
