MCDBA Roadmap

Hey Guys,
Does any 1 have the roadmap to MCDBA? If you have the document, please send
me a link where I can download or please email the document to
seelanr@.hotmail.com
Thanks"Seelan Raja" <seelan_rd@.NOSPAMyahoo.com> wrote in message
news:%234iLarkNGHA.1716@.TK2MSFTNGP10.phx.gbl...
> Hey Guys,
> Does any 1 have the roadmap to MCDBA? If you have the document, please
> send
> me a link where I can download or please email the document to
> seelanr@.hotmail.com
> Thanks
>
http://www.microsoft.com/learning/mcp/mcdba/mcdba.asp
Rick Sawtell
MCT, MCSD, MCDBA|||Thanks Rick
But that web page only has the requirements and NOT the ROADMAP.
"Rick Sawtell" <Quickening@.msn.com> wrote in message
news:uACCW9kNGHA.2624@.TK2MSFTNGP12.phx.gbl...
> "Seelan Raja" <seelan_rd@.NOSPAMyahoo.com> wrote in message
> news:%234iLarkNGHA.1716@.TK2MSFTNGP10.phx.gbl...
> http://www.microsoft.com/learning/mcp/mcdba/mcdba.asp
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>|||What are you talking about if not the MCDBA requirements? The roadmap
is simply do the 3 core exams (SQL design, SQL admin & one of the Win
Server exams) and 1 of the electives (mostly dev/design exams). Or do
you mean MCDBA (SQL 7) -> MCDBA (SQL 2000) -> MCDBA (SQL 2005) -> ?
etc.? If so then this may (or may not) be helpful:
http://www.microsoft.com/learning/mcp/mcitp/dbadmin/
*mike hodgson*
http://sqlnerd.blogspot.com
Seelan Raja wrote:

>Thanks Rick
>But that web page only has the requirements and NOT the ROADMAP.
>"Rick Sawtell" <Quickening@.msn.com> wrote in message
>news:uACCW9kNGHA.2624@.TK2MSFTNGP12.phx.gbl...
>
>
>|||Hey Guys,
Thanks for the replies but What I am looking for is the steps/the order in w
hich I take the courses/ exam.
-Seelan
"Mike Hodgson" <e1minst3r@.gmail.com> wrote in message news:OJgWJBoNGHA.3936@.
TK2MSFTNGP10.phx.gbl...
What are you talking about if not the MCDBA requirements? The roadmap is simply do the
3 core exams (SQL design, SQL admin & one of the Win Server exams) and 1 of the electi
ves (mostly dev/design exams). Or do you mean MCDBA (SQL 7) -> MCDBA (SQL 2000) -> MCD
BA (SQL 2005) -> ? etc.? If so then this may (or may not) be helpful: http://ww
w.microsoft.com/le.../mcitp/dbadmin/
mike hodgson
http://sqlnerd.blogspot.com
Seelan Raja wrote:
Thanks Rick
But that web page only has the requirements and NOT the ROADMAP.
"Rick Sawtell" <Quickening@.msn.com> wrote in message
news:uACCW9kNGHA.2624@.TK2MSFTNGP12.phx.gbl...
"Seelan Raja" <seelan_rd@.NOSPAMyahoo.com> wrote in message
news:%234iLarkNGHA.1716@.TK2MSFTNGP10.phx.gbl...
Hey Guys,
Does any 1 have the roadmap to MCDBA? If you have the document, please
send
me a link where I can download or please email the document to
seelanr@.hotmail.com
Thanks
http://www.microsoft.com/learning/mcp/mcdba/mcdba.asp
Rick Sawtell
MCT, MCSD, MCDBA|||There are no steps. Order is unimportant. You can take them in any
order you feel like. Each exam is independent in it's own right. Many
people like to do the ones they are most comfortably with first (ie. the
ones they think they are most likely to pass) to give them a confidence
boost for the harder ones but it's all just personal preference.
*mike hodgson*
http://sqlnerd.blogspot.com
Seelan Raja wrote:
[vbcol=seagreen]
> Hey Guys,
> Thanks for the replies but What I am looking for is the steps/the
> order in which I take the courses/ exam.
> -Seelan
> "Mike Hodgson" <e1minst3r@.gmail.com <mailto:e1minst3r@.gmail.com>>
> wrote in message news:OJgWJBoNGHA.3936@.TK2MSFTNGP10.phx.gbl...
> What are you talking about if not the MCDBA requirements? The
> roadmap is simply do the 3 core exams (SQL design, SQL admin & one
> of the Win Server exams) and 1 of the electives (mostly dev/design
> exams). Or do you mean MCDBA (SQL 7) -> MCDBA (SQL 2000) -> MCDBA
> (SQL 2005) -> ? etc.? If so then this may (or may not) be
> helpful: http://www.microsoft.com/learning/mcp/mcitp/dbadmin/
> --
> *mike hodgson*
> http://sqlnerd.blogspot.com
>
> Seelan Raja wrote:
>

MCDBA Roadmap

Hey Guys,
Does any 1 have the roadmap to MCDBA? If you have the document, please send
me a link where I can download or please email the document to
seelanr@.hotmail.com
Thanks
"Seelan Raja" <seelan_rd@.NOSPAMyahoo.com> wrote in message
news:%234iLarkNGHA.1716@.TK2MSFTNGP10.phx.gbl...
> Hey Guys,
> Does any 1 have the roadmap to MCDBA? If you have the document, please
> send
> me a link where I can download or please email the document to
> seelanr@.hotmail.com
> Thanks
>
http://www.microsoft.com/learning/mcp/mcdba/mcdba.asp
Rick Sawtell
MCT, MCSD, MCDBA
|||Thanks Rick
But that web page only has the requirements and NOT the ROADMAP.
"Rick Sawtell" <Quickening@.msn.com> wrote in message
news:uACCW9kNGHA.2624@.TK2MSFTNGP12.phx.gbl...
> "Seelan Raja" <seelan_rd@.NOSPAMyahoo.com> wrote in message
> news:%234iLarkNGHA.1716@.TK2MSFTNGP10.phx.gbl...
> http://www.microsoft.com/learning/mcp/mcdba/mcdba.asp
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
|||What are you talking about if not the MCDBA requirements? The roadmap
is simply do the 3 core exams (SQL design, SQL admin & one of the Win
Server exams) and 1 of the electives (mostly dev/design exams). Or do
you mean MCDBA (SQL 7) -> MCDBA (SQL 2000) -> MCDBA (SQL 2005) -> ?
etc.? If so then this may (or may not) be helpful:
http://www.microsoft.com/learning/mcp/mcitp/dbadmin/
*mike hodgson*
http://sqlnerd.blogspot.com
Seelan Raja wrote:

>Thanks Rick
>But that web page only has the requirements and NOT the ROADMAP.
>"Rick Sawtell" <Quickening@.msn.com> wrote in message
>news:uACCW9kNGHA.2624@.TK2MSFTNGP12.phx.gbl...
>
>
>
|||Hey Guys,
Thanks for the replies but What I am looking for is the steps/the order in which I take the courses/ exam.
-Seelan
"Mike Hodgson" <e1minst3r@.gmail.com> wrote in message news:OJgWJBoNGHA.3936@.TK2MSFTNGP10.phx.gbl...
What are you talking about if not the MCDBA requirements? The roadmap is simply do the 3 core exams (SQL design, SQL admin & one of the Win Server exams) and 1 of the electives (mostly dev/design exams). Or do you mean MCDBA (SQL 7) -> MCDBA (SQL 2000) -> MCDBA (SQL 2005) -> ? etc.? If so then this may (or may not) be helpful: http://www.microsoft.com/learning/mcp/mcitp/dbadmin/
mike hodgson
http://sqlnerd.blogspot.com
Seelan Raja wrote:
Thanks Rick
But that web page only has the requirements and NOT the ROADMAP.
"Rick Sawtell" <Quickening@.msn.com> wrote in message
news:uACCW9kNGHA.2624@.TK2MSFTNGP12.phx.gbl...
"Seelan Raja" <seelan_rd@.NOSPAMyahoo.com> wrote in message
news:%234iLarkNGHA.1716@.TK2MSFTNGP10.phx.gbl...
Hey Guys,
Does any 1 have the roadmap to MCDBA? If you have the document, please
send
me a link where I can download or please email the document to
seelanr@.hotmail.com
Thanks
http://www.microsoft.com/learning/mcp/mcdba/mcdba.asp
Rick Sawtell
MCT, MCSD, MCDBA
|||There are no steps. Order is unimportant. You can take them in any
order you feel like. Each exam is independent in it's own right. Many
people like to do the ones they are most comfortably with first (ie. the
ones they think they are most likely to pass) to give them a confidence
boost for the harder ones but it's all just personal preference.
*mike hodgson*
http://sqlnerd.blogspot.com
Seelan Raja wrote:
[vbcol=seagreen]
> Hey Guys,
> Thanks for the replies but What I am looking for is the steps/the
> order in which I take the courses/ exam.
> -Seelan
> "Mike Hodgson" <e1minst3r@.gmail.com <mailto:e1minst3r@.gmail.com>>
> wrote in message news:OJgWJBoNGHA.3936@.TK2MSFTNGP10.phx.gbl...
> What are you talking about if not the MCDBA requirements? The
> roadmap is simply do the 3 core exams (SQL design, SQL admin & one
> of the Win Server exams) and 1 of the electives (mostly dev/design
> exams). Or do you mean MCDBA (SQL 7) -> MCDBA (SQL 2000) -> MCDBA
> (SQL 2005) -> ? etc.? If so then this may (or may not) be
> helpful: http://www.microsoft.com/learning/mcp/mcitp/dbadmin/
> --
> *mike hodgson*
> http://sqlnerd.blogspot.com
>
> Seelan Raja wrote:
sql

MCAD free online test

Hi everyone,
I am searching for free online MCAD exam test.
I could only find ucertify online free test.
If you know any link about this, would you please inform me ?

Thanks

and also I am searching for 70-229 exam online test.

Thanks

|||

Hi, I encounter a question which make me confused.

You are a database developer for an insurance company. The insurance company has a multi-tier application that is used to enter data about its policies and the owners of the policies. The policyowner information is stored in a table named Owners. The script that was used to create this table
is shown below:
CREATE TABLE Owners
(
OwnerID int IDENTITY (1, 1) NOT NULL,
FirstName char(20) NULL,
LastName char(30) NULL,
BirthDate date NULL,
CONSTRAINT PK_Owners PRIMARY KEY (Owner ID)
)
When information about policy owners is entered, the owner’s birth date is not included; the database needs
to produce a customized error message that can be displayed by the data entry application. You need to
design a way for the database to validate that the birth date is supplied and to produce the error message if
it is not. What should you do?
A. Add a CHECK constraint on the BirthDate column.
B. Create a rule, and bind the rule to the BirthDate column.
C. Alter the Owners table so that the BirthDate column does not allow null.
D. Create a trigger on the Owners table that validates the BirthDate column
Answer:D

So I think that the answer ccan also be 'C', is not it ?

Would you please explain this to me ?

Thanks

|||

The key sentence is :

"the database needs to produce a customized error message that can be displayed by the data entry application."

You won′t get a customized error message (Because you won′t be able to create one) if you set the column no to allow NULL values.

HTH, jens Suessmeyer.

http://www.sqlserver2005.de

|||

Hi,
While inserting a record to the table, since we modified the BirtDate not to allow null, does not it also create an error ?

Thanks

|||Sure but it will only create Error Number 515, you won′t be able to customize that message. In a trigger you can catch the error and throw a custom one with raiserror.

HTH, jens Suessmeyer.

http://www.sqlserver2005.de|||

Sorry, I did not care the 'customized' meaning.
Sorry again,
Thanks,
Mert