Start with 7 free days of training.

Gain instant access to our entire IT training library, free for your first week.
Train anytime on your desktop, tablet, or mobile devices.

Server 2005 Implementation and Maintenance

This course will be retired in 250 days. If you have questions, please contact us.

Exam 70-431 was retired in June 2011. However, this training retains considerable value as an IT resource....
Exam 70-431 was retired in June 2011. However, this training retains considerable value as an IT resource.

In this course, instructor Garth Schulte shows you what's new, what's different, and what's useful about SQL Server 2005. 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.

Passing the 70-431 exam earns you certification as a Microsoft Certified Technology Specialist (MCTS), which tells employers that you are a specialist at implementing and maintaining a SQL Server 2005 installation. A basic understanding of computers and networking is recommended before viewing this training.

All trademarks and copyrights are the property of their respective holders.
 show less
1. Introduction to SQL Server 2005 (36 min)
2. Installing and Configuring SQL Server 2005 (36 min)
3. Implementing Security (47 min)
4. Implementing Disaster Recovery (58 min)
5. Monitoring Activity and Performance (44 min)
6. Maintaining High Availability (50 min)
7. Implementing Replication (54 min)
8. Automating Tasks with SQL Server Agent (39 min)
9. TSQL Language Primer (77 min)
10. Creating, Managing, and Maintaining Databases (44 min)
11. Designing and Creating Tables (52 min)
12. Implementing Indexes (37 min)
13. Creating and Using Views (36 min)
14. Creating and Using Stored Procedures (39 min)
15. Creating and Using User-Defined Functions (31 min)
16. Working with XML Data (49 min)
17. Working with Managed Code (47 min)
18. Intro to Messaging with SQL Server Notification Services (SSNS) (51 min)
19. Intro to Transforming Data with SQL Server Integration Services (SSIS) (47 min)
20. Intro to Reporting with SQL Server Reporting Services (SSRS) (44 min)

Please help us improve by sharing your feedback on training courses and videos. For customer service questions, please contact our support team. The views expressed in comments reflect those of the author and not of CBT Nuggets. We reserve the right to remove comments that do not adhere to our community standards.

comments powered by Disqus
15 hrs 20 videos


Training Features

Practice Exams
These practice tests help you review your knowledge and prepare you for exams.

Virtual Lab
Use a virtual environment to reinforce what you are learning and get hands-on experience.

Offline Training
Our iOS and Android mobile apps offer the ability to download videos and train anytime, anywhere offline.

Accountability Coaching
Develop and maintain a study plan with one-to-one assistance from coaches.

Supplemental Files
Files/materials that supplement the video training.

Speed Control
Play videos at a faster or slower pace.

Included in this course
Pick up where you left off watching a video.

Included in this course
Jot down information to refer back to at a later time.

Closed Captions
Follow what the trainers are saying with ease.
Garth Schulte
Nugget trainer since 2002