|
 Topic: SQL Server 2005 or SQL Server 2000? Hlep! ( Topic Closed)
|
 
|
| Author |
|
Nowy013
New User
Joined: 03 August 2006
Location: United Kingdom
Posts: 2
|
| Posted: 03 August 2006 at 2:07am | IP Logged
|
|
|
I want to do MCDBA but i dont know whit one - SQL Server 2000 or 2005 ??? I know many companys are using verion 2000 now - but i think if u will learn 2005 then you will know how to work with older version as well. Its like learning how to use windows xp and then dont know how tu use windows 2000? OR maybe im wrong - can some one anwser on my question? And one more thing - on microsoft web sitehiere there is nothing about exams from SQL Server 2005. Why ?
MARS
Edited by Nowy013 on 03 August 2006 at 2:09am
__________________
MARS
|
| top |
|
| |
Wildcat_Dude
Platinum
Joined: 20 August 2003
Location: United States
Posts: 3441
|
| Posted: 03 August 2006 at 5:09am | IP Logged
|
|
|
Because you probably not looking in the right area. You didn't click on the MCITP link which would have taken you to the SQL 2005 Link - see courses & exam.
Now I'll have to ask you this. What do you actually know about databases? Like you said, there are still lots of companies using SQL 2000 and have no plans to change anytime soon, that's the route I'm taking. What makes you think you can do 2005 and go back and work on earlier databases if you don't know the quirks between the two?
Someone posted a reason why you'd choose one direction as opposed to another, so why not just browse and read the other forum messages. You may just find the answer you seek. Me, its a no brainer to go 2000 route, and upgrade later. by the way, that's exam 70-431 for SQL 2005 for MCTS and exams 70-443 and 70-444 for MCITP
Oh and MCDBA Upgrade exam 70-447 has been available since Feb 2006, so has the other 2005 exams except for 70-431, its been available since Jan 2006.
__________________
MCSE:Security & MCSA:Security, MCDST, MCP XP, CompTIA Sec+, A+ & N+
USAF (68-77) SP K9 Vietnam Vet 1969-DaNang, 1970-Tuy Hoa, Retired Police Detective/Narcotics/K9
|
| top |
|
| |
BosonMichael
Platinum
Certification Guru
Joined: 30 August 2005
Location: United States
Posts: 6048
|
| Posted: 03 August 2006 at 9:13am | IP Logged
|
|
|
If you know how to administer SQL 2005, you don't necessarily know how to administer SQL 2000... at least, not at the same level of proficiency. The same could be said for Windows 2000 and NT... if you know how to admin Win2K, you still wouldn't know how to administer NT at that same level of proficiency.
Always keep in mind that there are differences between versions... otherwise, there'd not be a reason to release a new version, right? So, if you go in to administer a SQL 2000 server and you're expecting a particular 2005 feature to be there... you might be out of luck. See what I mean?
__________________
BosonMichael
MCSE+I, MCSE: Security, MCSE: Messaging, MCDST, MCDBA, MCTS, OCP, CCNP, CCDP, CNE, SCSA, Security+, Linux+, Server+, Network+, A+
Served proudly, US Army, 98C Analyst, '89-'92
|
| top |
|
| |
Nowy013
New User
Joined: 03 August 2006
Location: United Kingdom
Posts: 2
|
| Posted: 03 August 2006 at 11:20pm | IP Logged
|
|
|
Thnx guys - 2000 then. I dont know much about databases so im kinda lost in all those exams.
I was thinking aboud doing MCDBA but now i noticed that MCITP - Database Administrator its kinda better (cause on microsoft web page u can upgrade from MCDBA to MCITP D.A. so sounds like MCITP is kinda better to do). But to do MCITP you have to do exam from SQL 2005 - and i decided to do exam from SQL 2000. Sorry if thats maybe silly question - but im relly lost in this - can anyone help me?
__________________
MARS
|
| top |
|
| |
BosonMichael
Platinum
Certification Guru
Joined: 30 August 2005
Location: United States
Posts: 6048
|
| Posted: 04 August 2006 at 12:33am | IP Logged
|
|
|
If you don't know much about databases, you should learn about them before even considering either of these certifications.
MCDBA and MCITP: Database Administrator are basically the same certification, except one covers SQL Server 2000 and one covers SQL Server 2005. Neither is better than the other; one is merely newer than another. The reason the certification names are different is because Microsoft is renaming ALL of their certification tracks.
__________________
BosonMichael
MCSE+I, MCSE: Security, MCSE: Messaging, MCDST, MCDBA, MCTS, OCP, CCNP, CCDP, CNE, SCSA, Security+, Linux+, Server+, Network+, A+
Served proudly, US Army, 98C Analyst, '89-'92
|
| top |
|
| |
Crito
Silver
Joined: 21 August 2006
Location: United States
Posts: 28
|
| Posted: 21 August 2006 at 9:29am | IP Logged
|
|
|
In the real-world you'll find that most places consider a DBA's job role to include database design, server administration and data warehousing/reporting/ETL activities. I don't know why MS decided they were going to try to split the role into three, but I've NEVER seen a place employ three DBA's for these three different activities. Data warehousing used to be a specialization, but that too has now been melded into the ever changing DBA job role. And that in a nutshell is the problem with job role certifications: job roles are dynamic, not static.
In any case, there used to be a data warehousing test for SQL Server 7 actually. Their first mistake was making it an elective and not a requirement. Then they never updated the exam for SQL 2000. That was their second mistake. Dumping the MCDBA enitrely is their third IMHO, and why I personally will not be upgrading to MCITP: Database Administrator any time soon. In fact, after completing MCTS: SQL Server 2005 (test 431) I'll probably go for MCITP: Business Intelligence Developer first, as that's the only new one that adds any real value to my existing MCDBA.
Edited by Crito on 21 August 2006 at 9:32am
|
| top |
|
| |
Wildcat_Dude
Platinum
Joined: 20 August 2003
Location: United States
Posts: 3441
|
| Posted: 21 August 2006 at 9:56am | IP Logged
|
|
|
Crito, welcome to certcities.com and a good first post.
__________________
MCSE:Security & MCSA:Security, MCDST, MCP XP, CompTIA Sec+, A+ & N+
USAF (68-77) SP K9 Vietnam Vet 1969-DaNang, 1970-Tuy Hoa, Retired Police Detective/Narcotics/K9
|
| top |
|
| |
BosonMichael
Platinum
Certification Guru
Joined: 30 August 2005
Location: United States
Posts: 6048
|
| Posted: 21 August 2006 at 3:44pm | IP Logged
|
|
|
They merely dumped the MCDBA acronym and renamed it MCITP: Database Administrator. It's the same thing, different version.
__________________
BosonMichael
MCSE+I, MCSE: Security, MCSE: Messaging, MCDST, MCDBA, MCTS, OCP, CCNP, CCDP, CNE, SCSA, Security+, Linux+, Server+, Network+, A+
Served proudly, US Army, 98C Analyst, '89-'92
|
| top |
|
| |
|
|
Sorry, you can NOT post a reply.
This topic is closed.
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You can vote in polls in this forum
|
top
|
|
