Cert. exam #70-229 (Designing and Implementing SQL Server 2000)

[DayLaborer]

Is there any SQL on the exam - it doesn't seem like it from the book I'm using - Exam Cram 2 by T. Moore.

Is that possible?

Thanks!

 

[DayLaborer]

I slightly retract the question. I see that there is SQL on the exam - but it's not as much as I'd have expected.

How much (rough %) "regular SQL" - SELECTs, INSERTs, JOINs, etc. are on this exam?

Thanks!

 

[mrdenny]

I remember about 10% was actual SQL. Plus some logical and physical database design.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[icemel]

I just took it - can't remember a thing! There *might* be some sql, just not very much... but don't hold me liable if I'm wrong!

 

[DayLaborer]

I just took it yesterday also - and didn't pass. I used the Exam Cram 2 book to study.

What do you recommend I use now - Transcenders? I must pass this exam and get it over with already...

Thanks!

 

[icemel]

uCertify exams got me an 839 on this test - not as good as I thought, but I passed

 

[SpyroA]

Of course there is T-SQL on this exam, I remember quite a bit of DDL & DML.

However, T-SQL is a only part of the exam.

Logical DB Design, Physical DB Design, Optimization, Security & etc are all sections of the exam.


Spyro

PMP, Project+, MCAD, MCSD, MCDBA, SCJP and currently working on 70-291 for MCSA