In the past I've used MSDE with Visual Studio.NET 2003. I'm going to start studying for an MCP in SQL Server 2000 so I'll probably get SQL Server 2000 Developer Edition. Will I be able to install this on my PC if it already has MSDE installed, or will I need to remove MSDE, etc? If there are any other things I need to be aware of please let me know.
Also should I stick with SQL Server 2000 while studying for the exam, or would I probably be able to use SQL Server 2005 with a book that uses SQL Server 2000? I don't know how different they are.
To study for the SQL Server 2000 exam you need Robert Vierra's book and practice test. Yes you can install SQL Server 2000 as a named instance and register your MSDE installation by right clicking at the top of Enterprise manager. The exam is more about DDL(data definition langauge) than DML(data manipulation langauge). I think you should buy a very good book that comes with the eval version of SQL Server 2000 and then buy SQL Server 2005 developer edition. There is a lot of difference between SQL Server 2000 and SQL Server 2005, the quick place is run a search for what is new in SQL Server 2005 BOL (books online). Try the links below for two books and Certification tutorials. Hope this helps.
http://www.amazon.com/gp/product/007212587X/103-8611132-6819033?v=glance&n=283155
http://www.amazon.com/gp/product/0764543792/ref=pd_sbs_b_2/103-8611132-6819033?%5Fencoding=UTF8&v=glance&n=283155
http://www.codeclinic.com/certification.htm
No comments:
Post a Comment