Can anyone recommend a SQL server 2005 training course/CD_ROM/DVD/book

[AccessNut]

I may have to upsize my Access database to SQL server 2005. I have no experience with SQL Server, have some experience with Crystal Reports, and I'm an intermediate user of Access. I have done a lot of programming with VB, C++, Java, but not the .Net framework. Basically I will need to upsize the Access database, write queries and reports in SQL Server, and maybe even doing a little bit of DBA. I have multiple users across a network. My employer is probably willing to pay 1-2k on training, and something like a CD_ROM or DVD course probably works out the best since I can fit that in whenever I get a break at work. Books are also good.

I googled the subject and was overwhelmed with the number of courses and books available. If anyone can recommend a course/book I'd really appreciate it. Thanks.

 

[MSAccessRookie]

I may have to upsize my Access database to SQL server 2005. I have no experience with SQL Server, have some experience with Crystal Reports, and I'm an intermediate user of Access. I have done a lot of programming with VB, C++, Java, but not the .Net framework. Basically I will need to upsize the Access database, write queries and reports in SQL Server, and maybe even doing a little bit of DBA. I have multiple users across a network. My employer is probably willing to pay 1-2k on training, and something like a CD_ROM or DVD course probably works out the best since I can fit that in whenever I get a break at work. Books are also good.

I googled the subject and was overwhelmed with the number of courses and books available. If anyone can recommend a course/book I'd really appreciate it. Thanks.

There are many routes that can be taken in this instance. I recently completed a project of the exact same type, and in the end, the users are STILL using their MS Access Front end, along with its Forms and Reports.

As a result of the project, all of the data tables were moved to the SQL Server, along with about 40% of the queries (which were converted to SQL Server Views). The result was a system that was 25+ times more efficeint, and so far is supporting over three times as many users using about 40% of the resources that used to be needed. In addition, there have been no Application or database failures for nearly 8 months(since the installation last fall), compared to the daily application events, and bi-weekly data events that were occuring before the migration.

I am sure there are many other resources available, but I was provided that following books that I found useful.

• Microsoft Access Developer's Guide to SQL Server (Parson's/Randolph)
• From Access to SQL Server (Sinclair)
• Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL and .NET (Sunderic)
• Inside MicroSoft SQL Server 2005: T-SQL Querying (Ben-Gan/Kollar/Sarka)

AND OF COURSE:

• SQL For Dummies (Taylor)

I do not think the whole library cost over $350, but I did not have to pay for it, so I could be wrong.