SQL Server 2005 Implementation and Maintenance

SQL 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)