70-229 SQL

Hello,

Can someone suggest a "FREE" online site where I can
get some questions and explanations for the 70-229 exam.
I have failed this exam twice already, even though I have
mastered everything in the Microsoft Press book for the
exam. I have encountered quite a few things that are not
covered in the book, such as determining when to use
stored procedures, user-defined functions, or views.
There were many questions like this that were not covered
in the book. Can someone recommend me a reliable source.
Thank you.

Session

Session

>I have failed this exam twice already, even though I have
>mastered everything in the Microsoft Press book for the
>exam.

Two good books are: -

Professional SQL Server 2000 Programming, Wrox Press

Inside SQL server 2000 MS press.

Don't forget BOL & MSDN.

Kline Sphere (Chalk) MCNGP #3

The Poster Formerly Known as Kline Sphere

The Poster Formerly Known as Kline Sphere <.> wrote:


>Professional SQL Server 2000 Programming, Wrox Press

Which, after the demise of Wrox Press, has found a new home
with Wiley

http://www.wiley.com/WileyCDA/WileyT...764543792.html

I am curious though what happened to the 2nd Edition:
http://www.amazon.com/exec/obidos/ASIN/1861006063

(amazon vaporbook?)

UAError

>Which, after the demise of Wrox Press, has found a new home
>with Wiley

Many title's are still being published under the Wrox banner. I wonder
if that is anything to do with pre-existing agreements with the
authors. In any case, Wiley are an excellent publisher as well, but it
makes sense on their part to continue to use the Wrox 'brand' name.

Kline Sphere (Chalk) MCNGP #3

The Poster Formerly Known as Kline Sphere

"Session" <> wrote:

>Hello,
>
> Can someone suggest a "FREE" online site where I can
>get some questions and explanations for the 70-229 exam.
>I have failed this exam twice already, even though I have
>mastered everything in the Microsoft Press book for the
>exam. I have encountered quite a few things that are not
>covered in the book, such as determining when to use
>stored procedures, user-defined functions, or views.
>There were many questions like this that were not covered
>in the book. Can someone recommend me a reliable source.
> Thank you.
>
>Session
>

Get a copy of the code clinics links:
http://www.codeclinic.com/70-229skills.htm

and follow the links

get the Books On-line (BOL):

SQL Server 2000 Books Online (Updated 2004)
http://www.microsoft.com/sql/techinf...2000/books.asp

You'll probably want to review "Optimizing Database
Performance" in detail, both design of the database itself
and application design.

Practice with:
Microsoft SQL Server 2000 Desktop Engine (MSDE 2000)
Release A
http://www.microsoft.com/downloads/d...DisplayLang=en

or even better (if 120 days are enough)
SQL Server 2000 Evaluation Edition Release A
(Protects Against the Slammer Worm)
http://www.microsoft.com/downloads/d...displaylang=en

UAError

The Poster Formerly Known as Kline Sphere <.> wrote:

>>Which, after the demise of Wrox Press, has found a new home
>>with Wiley
>
>Many title's are still being published under the Wrox banner. I wonder
>if that is anything to do with pre-existing agreements with the
>authors. In any case, Wiley are an excellent publisher as well, but it
>makes sense on their part to continue to use the Wrox 'brand' name.

A significant number Wrox titles have been taken over by
Apress (a subsidiary of Springer-Verlag) but they actually
replace the cover - Wiley may have rights to the Wrox brand.

>
>Kline Sphere (Chalk) MCNGP #3

UAError

I recommend this book:

http://www.amazon.com/exec/obidos/AS...316772-5208930

I have it...it's very good...

--
FF
www.francofigun.com.ar
www.microsofties.com.ar
UIN: 305336919
MSN:

"Session" <> escribió en el mensaje
news:371c01c4295e$9d60d4d0$...
> Hello,
>
> Can someone suggest a "FREE" online site where I can
> get some questions and explanations for the 70-229 exam.
> I have failed this exam twice already, even though I have
> mastered everything in the Microsoft Press book for the
> exam. I have encountered quite a few things that are not
> covered in the book, such as determining when to use
> stored procedures, user-defined functions, or views.
> There were many questions like this that were not covered
> in the book. Can someone recommend me a reliable source.
> Thank you.
>
> Session
>
>

Franco Figun

"Franco Figun" <> wrote:

>I recommend this book:
>
>http://www.amazon.com/exec/obidos/AS...316772-5208930
>
>I have it...it's very good...

... the reviews paint quite the opposite picture (i.e.
avoid like the plague). And I doubt that a reader who "gets"
Vieira's book, is such a novice that he/she is just venting
frustation because of the challenge that its technical
content presents.

But YMMV...

UAError

Hello Session
My experience is exactly like you. I tried, all the books, that many have
suggested you in this newsgroup, but even though, it is still going bad. The
reason is simple, I don't know about you, but I am MCAD, with 70-316,
70-315, 70-320. All these exams are having 56 - 58 questions and 2 hrs time.
Now then calculation is this, if you have 100 q's the you can do 20 wrong,
but if you have only 5 q's then in that case it is very, very difficult to
do only 1 wrong. And that is what happening, I am having good skill on SQL
Server 2000, but still the questions are very, very tricky, specially, very
descriptive, which make you very confuse when you reach the last lines of
the question, you will forget, lost what you have read at the top of the
question. For first MCAD exams, questions are like maths, means, 2 + 2 = 4,
so you are able to score, but in descriptive, it is difficult, specially MS
select the question, and then re-create that question to make you confuse,
and that is what it is happening, Anyway, I wish you best luck. You have
already spend, $250. and I understand its value.

"Session" <> wrote in message
news:371c01c4295e$9d60d4d0$...
> Hello,
>
> Can someone suggest a "FREE" online site where I can
> get some questions and explanations for the 70-229 exam.
> I have failed this exam twice already, even though I have
> mastered everything in the Microsoft Press book for the
> exam. I have encountered quite a few things that are not
> covered in the book, such as determining when to use
> stored procedures, user-defined functions, or views.
> There were many questions like this that were not covered
> in the book. Can someone recommend me a reliable source.
> Thank you.
>
> Session
>
>

Lord2702

and don't forget to mine this resource:

http://groups.google.com/groups?as_e...ic.*&lr=&hl=en

Looking at this group you'd think using Google Groups is
some kind of trade-secret

Maybe this should become the #1 IT interview question

What is Google Groups?

UAError