maltesedba
IS-IT--Management
I am a senior SQL server DBA and would like to get certified. What would be the best way for me to prepare for the MCDBA test?
Thanks
Thanks
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
I am a senior SQL server DBA and wo
- Thread starter maltesedba
- Start date
- Status
CharlieJax
MIS
The best way to study for the MCDBA is to:
1) Setup Windows 2000 and work with it
2) Setup SQL Server 2000 and work with it
- Make sure you know the t-sql commands, the test likes to ask questions about that...
On the 228 test I faced a lot of questions about the backup and the bulk load features.
I haven't taken the 229 test yet, as 228 completed my MCSE but if you have a few months of experence working with SQL, know the commands and how the basics work you can probably pass 228 without much trouble.
Now, if you haven't worked with the Windows 2000 as an Administrator you will need to study the Active Directory features, setting up the servers, network or secuirty design, etc as you have to take several of the server tests to get your MCDBA...
You may also find some value in going after the Oracle cert.
Hope this helps ya out! CJ
- If chickens could fly would they egg ugly people?
1) Setup Windows 2000 and work with it
2) Setup SQL Server 2000 and work with it
- Make sure you know the t-sql commands, the test likes to ask questions about that...
On the 228 test I faced a lot of questions about the backup and the bulk load features.
I haven't taken the 229 test yet, as 228 completed my MCSE but if you have a few months of experence working with SQL, know the commands and how the basics work you can probably pass 228 without much trouble.
Now, if you haven't worked with the Windows 2000 as an Administrator you will need to study the Active Directory features, setting up the servers, network or secuirty design, etc as you have to take several of the server tests to get your MCDBA...
You may also find some value in going after the Oracle cert.
Hope this helps ya out! CJ
- If chickens could fly would they egg ugly people?
- Status