Microsoft Certified Database Administrator (MCDBA)

Demonstrate that you have the skills to lead organizations in the successful design, implementation, and administration of Microsoft SQL Server 2000 databases with the following Microsoft Certified Database Administrator (MCDBA) credential.

CBT Nuggets SQL Server 2005 Implementation and Maintenance Exam-Pack 70-431

More than 15 Hours 600 MBSQL Server 2005 has been tweaked drastically to make your life as a Database Administrator (DBA) or Developer easier.While much of the core functionality has been carried over from previous versions of SQL Server, many of the rules of play have changed:* SQL Server 2005 makes your life as a DBA or Developer easier because it combines good productivity features, easy to use new tools, and a more powerful than ever database engine.* Now DBAs and Developers can work together more easily–the tools for each job have been integrated and simplified inside the new SQL Server Management Studio.* SQL Server 2005 is faster than all previous versions–it broke the 1,000,000 transactions per minute milestone, which means it can now compete with the major players in the enterprise database market.With this new version, there’s a lot to learn.In this series, instructor Garth Schulte shows you what’s new, what’s different, and what’s useful. As you go through and watch each video, you learn not only the features that SQL Server 2005 has, but what they do and–most importantly–how to use them. Plus you’ll be preparing for MCTS certification exam 70-431 at the same time.Exam-Pack 70-431: SQL Server 2005 Implementation and Maintenance contains:- Introduction to SQL Server 2005- Installing and Configuring SQL Server 2005- Implementing Security- Implementing Disaster Recovery- Monitoring Activity and Performance- Maintaining High Availability- Implementing Replication- Automating Tasks with SQL Server Agent- TSQL Language Primer- Creating, Managing, and Maintaining Databases- Designing and Creating Tables- Implementing Indexes- Creating and Using Views- Creating and Using Stored Procedures- Creating and Using User-Defined Functions- Working with XML Data- Working with Managed Code- Intro to Messaging with SQL Server Notification Services (SSNS)- Intro to Transforming Data with SQL Server Integration Services (SSIS)- Intro to Reporting with SQL Server Reporting Services (SSRS)

CBT Nuggets SQL Server 2005 Implementation and Maintenance Exam-Pack 70-431 Part 01
CBT Nuggets SQL Server 2005 Implementation and Maintenance Exam-Pack 70-431 Part 02
CBT Nuggets SQL Server 2005 Implementation and Maintenance Exam-Pack 70-431 Part 03
CBT Nuggets SQL Server 2005 Implementation and Maintenance Exam-Pack 70-431 Part 04
CBT Nuggets SQL Server 2005 Implementation and Maintenance Exam-Pack 70-431 Part 05