|
Home > Archive > microsoft.public.cert.mcdba > December 2003 > Advice (SQL 2000 & MCDBA)
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Advice (SQL 2000 & MCDBA)
|
|
| Malcolm 2003-12-19, 4:24 am |
| Early next year I (should) complete my MCSA (210 - 215 -
218 - 216) I've passed the 1st two exams.
If I pass two SQL exams do I become an MCDBA?
And...I've been using Informix for 4 years. Next year my
employer will be bringing in an application running on
SQL 2000. What are the best books to enable rapid
comprehension of SQL 2000 for both day-to-day use and
exam passing, given my current use of Informix?
Thanks.
| |
| Cowboy \(Gregory A. Beamer\) 2003-12-19, 2:24 pm |
| The 70-215, along with 70-228 and 70-229 will get you DBA. 70-228 can also
be used for elective towards MCSE, if you go that route.
As far as rapid absorbsion, I would recommend getting a copy of SQL Server
and designing a database. Then, play around with the ENterprise manager. For
the SQL 2000 tests, you have to know more syntax (SQL 7 was mainly "Open
Enterprise Manager, right click on" types of questions, SQL 2000 is not).
Books Online is a great tool. Study it. It will help you out of a lot of
jams. And, BOL can get you to a passing grade if you actually experiment
with SQL Server, which is the best way to learn anyway. For a quick intro,
the programming SQL Server 2000, Step By Step book is fairly decent. With
your experience in Informix, you will likely rip through the examples fairly
fast. Not the best cert book, but it should get you a start where you can
let BOL and experimentation fill in the rest.
--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
******************************
******************************
**********
Think Outside the Box!
******************************
******************************
**********
"Malcolm" <anonymous@discussions.microsoft.com> wrote in message
news:09cf01c3c60f$92c66330$a10
1280a@phx.gbl...
> Early next year I (should) complete my MCSA (210 - 215 -
> 218 - 216) I've passed the 1st two exams.
>
> If I pass two SQL exams do I become an MCDBA?
>
> And...I've been using Informix for 4 years. Next year my
> employer will be bringing in an application running on
> SQL 2000. What are the best books to enable rapid
> comprehension of SQL 2000 for both day-to-day use and
> exam passing, given my current use of Informix?
>
> Thanks.
| |
| Ray Higdon 2003-12-20, 9:24 am |
| I agree with Greg, you can pick up SQL developer edition for $50.
--
Ray Higdon MCSE, MCDBA, CCNA
---
"Cowboy (Gregory A. Beamer)" <NoSpamMgbworld@comcast.netNoSpamM> wrote in
message news:uySuNMmxDHA.2712@TK2MSFTNGP11.phx.gbl...
> The 70-215, along with 70-228 and 70-229 will get you DBA. 70-228 can also
> be used for elective towards MCSE, if you go that route.
>
> As far as rapid absorbsion, I would recommend getting a copy of SQL Server
> and designing a database. Then, play around with the ENterprise manager.
For
> the SQL 2000 tests, you have to know more syntax (SQL 7 was mainly "Open
> Enterprise Manager, right click on" types of questions, SQL 2000 is not).
>
> Books Online is a great tool. Study it. It will help you out of a lot of
> jams. And, BOL can get you to a passing grade if you actually experiment
> with SQL Server, which is the best way to learn anyway. For a quick intro,
> the programming SQL Server 2000, Step By Step book is fairly decent. With
> your experience in Informix, you will likely rip through the examples
fairly
> fast. Not the best cert book, but it should get you a start where you can
> let BOL and experimentation fill in the rest.
>
> --
> Gregory A. Beamer
> MVP; MCP: +I, SE, SD, DBA
>
> ******************************
******************************
**********
> Think Outside the Box!
> ******************************
******************************
**********
> "Malcolm" <anonymous@discussions.microsoft.com> wrote in message
> news:09cf01c3c60f$92c66330$a10
1280a@phx.gbl...
>
>
|
|
|
|
|