Re: Getting started in IT.



Thank you.

Have ordered both books.
Just to find out, if I study 2 hours everyday for five days, how long do you
think I might complete the Admin and be ready for the test?

Thank you.
--
dpmj


"Darrilgibson@xxxxxxxxx" wrote:

You've asked a lot of questions, but in short, if you're new to SQL
Server, you'd be better served by learning SQL Server 2005 at this
point.

If you have an aptitude for databases, you might be able to pick up a
book or two and practice with the product to get some knowledge and
build some experience. I'm a little biased, but I think this is a
good book:

MCITP SQL Server 2005 Database Administration All-in-One Exam Guide
(Exams 70-431, 70-443, & 70-444) (All-in-One) (Hardcover) (ISBN
0071496092)

If you don't have a good understanding of how databases are put
together, this book includes some good introductory material on how to
design databases (in addition to covering material for the Database
Developer exams).

MCITP SQL Server 2005 Database Developer All-in-One Exam Guide (Exams
70-431, 70-441 & 70-442) (All-in-One) (Hardcover) (ISBN 0071546693)

Again, I am a little biased. I think these books are good, but there
are other books out there.

HTH,

Darril Gibson
MCT, MCDBA, MCITP, MCSE, MCSD
http://mcitpsuccess.com/
http://mcitpsuccess.blogspot.com/
Author, MCITP SQL Server 2005 Database Administration All-in-One Exam
Guide (Exams 70-431, 70-443, & 70-444)
Author, MCITP SQL Server 2005 Database Developer All-in-One Exam
Guide (Exams 70-431, 70-441, & 70-442)





On Jul 28, 10:03 am, dpmj <d...@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
Hi,
I've got similar a situation to Sam. The differennce however is that I've
already paid for an online training to take the MCDBA (70 290, 229,228 and
291) and learning at the moment.

My Concerns:

1) I learnt about the new MCITP just last week and just wondering that
should I
complete the MCDBA first then write the upgrade or swicth totally to the
MCITP. One issue here is about the new training cost. But also worried about
another re-train.

2) Knowing that MCITP has got three modules (431, 443 and 444) and reading
your responce to sam about buying just a book or two. Would this two books
cover the three modules? Any suggestions or links to good materials would be
highly appreciated.

3) Going to download the SQL Server 2005 Express Edition this evening. With
this and reading the above materials in (2), would this be sufficient towards
exam preparation as I do not have any practical experience in MCDBA before.

4) Ultimate goal is to get certified and then change career to IT. Though
work as a IT Tutor at the moment. No single hands-on practical experiene
with MCDBA. Do you think that the above should be okay to pass the test?

Many thanks.
dpmj



"Darril Gibson" wrote:
Sam gives good advice. I'd just like to add a couple of things...

Mainstream support of SQL Server 2000 ended this past April and the MCDBA
exams (70-228 and 70-229) are both due to expire in March 2009.

You'd be better suited to train in a more current version. SQL Server 2005
is popular right now but SQL Server 2008 hasn't been released yet

You can download trial versions of SQL Server 2005 here:
http://www.microsoft.com/sql/downloads/trial-software.mspx
SQL Server express certainly has its place, but if you're considering
getting certified, I'd recommend you download a trial of SQL Server 2005
Enterprise so that you can see all the capabilities.

Instead of (or in addition to) expensive training, you can pick up a book or
two on SQL Server 2005 and go through the book (and labs that most books
include) at your leisure. There are a lot of good books out there.

HTH,

Darril Gibson
MCT, MCDBA, MCITP, MCSE, MCSD
http://mcitpsuccess.com/
http://mcitpsuccess.blogspot.com/
Author, MCITP SQL Server 2005 Database Administration All-in-One Exam
Guide (Exams 70-431, 70-443, & 70-444)
Author, MCITP SQL Server 2005 Database Developer All-in-One Exam
Guide (Exams 70-431, 70-441, & 70-442)

"Sam Alex" wrote:

S P wrote:
Hi, I'm thinking of retraining into an IT discipline, but am unsure of what I
should look at.

I've been offered a home-study course for a Microsoft Certified Database
Administrator qualification (MCDA). It sounds attractive but is quite
expensive.

I'm not sure if it's suitable, or if there's another way of studying for the
qualification. Or if I should consider a different specialism.

Can anyone offer me any advice??

Many thanks

Hi...

Is your goal to get certified or to get experience working with
Microsoft SQL or databases in general? Getting a certification is often
a quick way to learn the technology plus the cert looks good on a
resume, but what I don't like is the MCDBA certification only touches on
MS SQL 2000, which is way out dated anymore. MS SQL 2005 and 2008 are
huge improvements over MS SQL 2000, so though the MS SQL 2000 content
would probably apply in 2005 and 2008, there's so much more that would
be missed.

My personal opinion is to download SQL Server 2005 Express Edition -
http://www.microsoft.com/sql/editions/express/default.mspx- and just
start working with it. There are some great tutorials online or you can
pickup any number of books that'll help you learn it.

Personally, though I've worked with MS SQL 2005 for about two years now
and MS SQL in general since version 6.5, I'm waiting until they redesign
the cert exams to focus on MS SQL 2005 and/or 2008 before I go after it.
Granted the cert will help on a resume, but with the money spent on
obtaining the cert, I want to get more then a piece of paper :)

Just my thoughts --

Sam Alex- Hide quoted text -

- Show quoted text -


.



Relevant Pages

  • Re: My Book is Incomplete Regarding SQL Commands ;-(
    ... I've spent enough $$$ on books presently and they were all ... Create a Connection object and pass in a ConnectionString to address ... manage the database table you reference. ... Hitchhiker's Guide to Visual Studio and SQL Server ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Whats My Password?
    ... To create a SQLServer database using Server Explorer in VS2005: ... This displays the Create New SQL Server Database dialog. ... books you have used as well. ... Specifically, the database connection stuff. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: SQL 7 MCDBA: Where do I go from here?
    ... I've found that people with strictly database administration ... MCITP SQL Server 2005 Database Administration All-in-One Exam ...
    (microsoft.public.cert.mcdba)
  • Re: smo class filegrowthtype bug?
    ... I would check Books Online (it's available for free download from Microsoft ... Once you generate a script to create the database, ... Hitchhiker's Guide to Visual Studio and SQL Server ...
    (microsoft.public.sqlserver.msde)
  • Re: Shrinking a SQL Server 6.5 db
    ... references for SQL Server 6.5. ... SHRINKDB to shrink his database? ... Books Online for SQL Server 2005 at ...
    (microsoft.public.sqlserver.tools)