SQL Server 2008 Designing, Optimizing and Maintaining a Database Course

The SQL Server 2008 Designing, Optimizing and Maintaining a Database short course is ideal for helping you prepare adequately for the 70-450 exam from Microsoft.

You will learn how to design a database security server solution, design a backup and recovery solution, and design a strategy to maintain and manage databases. At the end of this course you will understand how to install, configure, maintain, and secure a SQL Server 2008 database.

About the Author

Wayne Snyder is recognized worldwide as a SQL Server expert and Microsoft Most Valued Professional (MVP), with over 25 years of experience in project management, database administration, software design, performance measurement and capacity planning. He is a sought out consultant, trainer, writer and speaker, and produces a series of web-based seminars on SQL Server 2005. Wayne has edited many SQL Server books, contributes monthly to SQL Server Magazine and is a Managing Consultant for Mariner, a Business Intelligence Company.

On completion of the SQL Server 2008 Designing, Optimizing and Maintaining a Database short course, you’ll have learned to:

• » Design a database security server solution
• » Design a back-up and recovery solution
• » Design strategies for maintenance and management for databases
• » Configure and maintain a SQL Server 2008 database
• » Implement disaster planning techniques
• » Troubleshoot issues that may arise
• » Prepare for and pass the 70-450 Microsoft exam

The estimated course completion time is approximately 18 hours, although it is very possible to complete it quicker than this if you wish.

It should also be noted that this IT server short course is designed for use on a PC and not on a Mac.