Resources for Exam 70-441: Designing Database Solutions by Using Microsoft SQL Server 2005

This page is a work in progress, I am using it as a repository to store resources as I come across them.

Preparation Guide for Exam 70-441 (lists all the skills being tested)
http://www.microsoft.com/learning/exams/70-441.asp#SKILLS

Skills Assessment
Introducing Microsoft SQL Server 2005 for Database Developers

Books
Introducing Microsoft SQL Server 2005 for Classroom Training
Course 2734: Updating Your Database Development Skills to SQL Server 2005

Free* Microsoft E-Learning
The following e-learning courses are available for SQL Server 2005:
2939: Programming Microsoft SQL Server 2005
2940: Building Services and Notifications Using Microsoft SQL Server 2005
2941: Creating the Data Access Tier Using Microsoft SQL Server 2005

SQL 2005 Virtual Labs
http://www.microsoft.com/technet/traincert/virtuallab/sql.mspx

SQL 2005 Hands on Labs
http://msdn.microsoft.com/vstudio/tryit/hosted/sql/default.aspx

Print | posted on Tuesday, November 15, 2005 6:39 PM

Comments on this post

# re: Resources for Exam 70-441: Designing Database Solutions by Using Microsoft SQL Server 2005

Requesting Gravatar...
Hi,

How did you you determine the elearning courses relevant to this exam?
Left by mulhall on Nov 28, 2005 5:12 PM

# re: Resources for Exam 70-441: Designing Database Solutions by Using Microsoft SQL Server 2005

Requesting Gravatar...
Sorry, this page is a bit of a work in progress at the moment. I have been using the first link, which lists all the skill that the exam is testing as a guide for what to study. I know the first 2 eLearning courses are relevant (and at the moment they are free too!) - I have not looked at the third one yet.
Left by Darren Gosbell on Nov 28, 2005 5:43 PM

# re: Resources for Exam 70-441: Designing Database Solutions by Using Microsoft SQL Server 2005

Requesting Gravatar...
Cool. I'm having real difficulty finding anything on the many design topics for this one, especially unit testing.

Any advice would be appreciated.
Left by mulhall on Nov 30, 2005 2:54 PM

# re: Resources for Exam 70-441: Designing Database Solutions by Using Microsoft SQL Server 2005

Requesting Gravatar...
I had the same issue, there is not really much out there on unit testing databases. I did the Beta exam yesterday so I cannot say too much as it is covered under an NDA.

What I would suggest is to get familiar with the basic concepts of unit testing as they apply to languages like java, C# or VB.NET. I have used the TestDriven.net framework with VB.NET and I don't think I had too much trouble (I have to wait a while before I know if I passed or not.)
Left by Darren Gosbell on Dec 01, 2005 6:26 AM

# re: Resources for Exam 70-441: Designing Database Solutions by Using Microsoft SQL Server 2005

Requesting Gravatar...
Hi Darren

Did you pass 441? I just missed out!
Left by Mitch Wheat on Feb 28, 2006 9:08 AM

# re: Resources for Exam 70-441: Designing Database Solutions by Using Microsoft SQL Server 2005

Requesting Gravatar...
Hi Mitch,

Yes, I did pass. Not by too much, but it still counts! :)
Left by Darren Gosbell on Feb 28, 2006 5:59 PM

# re: Resources for Exam 70-441: Designing Database Solutions by Using Microsoft SQL Server 2005

Requesting Gravatar...
Can anyone send me study material regarding
1.Designing Database Testing and Code Management Procedures(Design a unit test plan for a database,Create a performance baseline and benchmarking strategy for a database. Create a plan for deploying a database. Control changes to source code.)
2.Designing an Application Solution for SQL Server 2005 (Select and design SQL Server services to support business needs.Design a logical database.Design an application solution to support security. Design an application solution that uses appropriate database technologies and techniques. Design an application solution that supports reporting. Design data distribution. )
Left by Archana on Mar 11, 2006 7:40 PM

# re: Resources for Exam 70-441: Designing Database Solutions by Using Microsoft SQL Server 2005

Requesting Gravatar...
Hi Darren
First of all Congratulation.I want to clear this exam.could u please guide me.
Left by Archana on Mar 11, 2006 7:45 PM

Your comment:

 (will show your gravatar)