Home > Archive > microsoft.public.cert.mcdba > October 2003 > Queries/Triggers and Stored Procedures





You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author Queries/Triggers and Stored Procedures
Troy

2003-10-21, 6:24 pm

What s a good book, CD or? that I could learn the above
(subject line)from.
Peng Te

2003-10-21, 6:24 pm

SQL Server Books Online. Even if you are a beginner, this is the definitive
source that you should learn to use. It's free from Microsoft download if
you don't already have SQL Server installed. Don't get fooled into paying
money for other reference books, because they don't add much value. Books
Online has plenty of examples and explanations.

Peng

"Troy" <anonymous@discussions.microsoft.com> wrote in message
news:033e01c3981c$8c918880$a50
1280a@phx.gbl...
> What s a good book, CD or? that I could learn the above
> (subject line)from.



troy

2003-10-21, 9:24 pm

where do I go to get these books? Can I practice on a fake
SQL server or do I need to buy one. I have XP home
addition.

Thanks for your help
>-----Original Message-----
>SQL Server Books Online. Even if you are a beginner,

this is the definitive
>source that you should learn to use. It's free from

Microsoft download if
>you don't already have SQL Server installed. Don't get

fooled into paying
>money for other reference books, because they don't add

much value. Books
>Online has plenty of examples and explanations.
>
>Peng
>
>"Troy" <anonymous@discussions.microsoft.com> wrote in

message
> news:033e01c3981c$8c918880$a50
1280a@phx.gbl...
>> What s a good book, CD or? that I could learn the above
>> (subject line)from.

>
>
>.
>

Peter Koen

2003-10-21, 9:24 pm

"troy" <anonymous@discussions.microsoft.com> wrote in news:060701c39836
$0cfeffc0$a301280a@phx.gbl:

> where do I go to get these books? Can I practice on a fake
> SQL server or do I need to buy one. I have XP home
> addition.


The SQL Server Online Books are included on the SQL Server CD-ROM. If you
buy one of those MS PRESS Self Paced Learning Kits you'll not only get a
valuable book, but also the BOL. theres a trial version of SQL Server
included with the MS PRESS Trainingkit.

--
best regards

Peter Koen
-----------------------------------
MCAD, CAI/R, CAI/S, CASE/RS, CAT/RS
http://www.kema.at
troy

2003-10-21, 9:24 pm

would this be the book? "Microsoft SQL Server 2000
Resource Kit (With CD-ROM)"
>-----Original Message-----
>"troy" <anonymous@discussions.microsoft.com> wrote in

news:060701c39836
>$0cfeffc0$a301280a@phx.gbl:
>
>> where do I go to get these books? Can I practice on a

fake
>> SQL server or do I need to buy one. I have XP home
>> addition.

>
>The SQL Server Online Books are included on the SQL

Server CD-ROM. If you
>buy one of those MS PRESS Self Paced Learning Kits you'll

not only get a
>valuable book, but also the BOL. theres a trial version

of SQL Server
>included with the MS PRESS Trainingkit.
>
>--
>best regards
>
>Peter Koen
>-----------------------------------
>MCAD, CAI/R, CAI/S, CASE/RS, CAT/RS
>http://www.kema.at
>.
>

troy

2003-10-21, 9:24 pm

I am looking for stored procedures, triggers etc that I
can learn. Any MS books or CD on the market?
>-----Original Message-----
>"troy" <anonymous@discussions.microsoft.com> wrote in

news:060701c39836
>$0cfeffc0$a301280a@phx.gbl:
>
>> where do I go to get these books? Can I practice on a

fake
>> SQL server or do I need to buy one. I have XP home
>> addition.

>
>The SQL Server Online Books are included on the SQL

Server CD-ROM. If you
>buy one of those MS PRESS Self Paced Learning Kits you'll

not only get a
>valuable book, but also the BOL. theres a trial version

of SQL Server
>included with the MS PRESS Trainingkit.
>
>--
>best regards
>
>Peter Koen
>-----------------------------------
>MCAD, CAI/R, CAI/S, CASE/RS, CAT/RS
>http://www.kema.at
>.
>

Peng Te

2003-10-21, 10:25 pm

Troy,

The link to downloading SQL Server Books online can be found at:
http://www.microsoft.com/sql/downloads/default.asp

If you haven't already, you should book mark this website
http://www.microsoft.com/sql.

When I was preparing for the 70-228 and 70-229 exams, the Microsoft self
paced training kit was really helpful. Exact title for the developer
version is MCAD/MCSE/MCDBA Self-Paced Training Kit: Microsoft SQL Server
2000 Database Design and Implementation, Exam 70-229, Second Edition. I am
a bit lazy to look up the admin book, but should be something like:
Microsoft SQL Server 2000 Administration. However, as definitive reference
materials for queries, triggers, stored procedures, your best source is the
SQL Server Online Books.

Peng

"troy" <anonymous@discussions.microsoft.com> wrote in message
news:057b01c3983a$1e7fe850$a40
1280a@phx.gbl...
> would this be the book? "Microsoft SQL Server 2000
> Resource Kit (With CD-ROM)"
> >-----Original Message-----
> >"troy" <anonymous@discussions.microsoft.com> wrote in

> news:060701c39836

> >$0cfeffc0$a301280a@phx.gbl:
> >
> >> where do I go to get these books? Can I practice on a

> fake
> >> SQL server or do I need to buy one. I have XP home
> >> addition.

> >
> >The SQL Server Online Books are included on the SQL

> Server CD-ROM. If you
> >buy one of those MS PRESS Self Paced Learning Kits you'll

> not only get a
> >valuable book, but also the BOL. theres a trial version

> of SQL Server
> >included with the MS PRESS Trainingkit.
> >
> >--
> >best regards
> >
> >Peter Koen
> >-----------------------------------
> >MCAD, CAI/R, CAI/S, CASE/RS, CAT/RS
> >http://www.kema.at
> >.
> >



troy

2003-10-21, 11:24 pm

Thank you for all your infomation. I have just ordered a
few and will get the CD rom for BOL. Anyone know how long
the eval copy of SQL is good for? Can it be loaded on XP
Home? If not what do I need to buy. I need to practice
linking to databases (access) and do stored procedures and
triggers etc.
>-----Original Message-----
>I am looking for stored procedures, triggers etc that I
>can learn. Any MS books or CD on the market?
>>-----Original Message-----
>>"troy" <anonymous@discussions.microsoft.com> wrote in

> news:060701c39836

>>$0cfeffc0$a301280a@phx.gbl:
>>
>>> where do I go to get these books? Can I practice on a

> fake
>>> SQL server or do I need to buy one. I have XP home
>>> addition.

>>
>>The SQL Server Online Books are included on the SQL

>Server CD-ROM. If you
>>buy one of those MS PRESS Self Paced Learning Kits

you'll
>not only get a
>>valuable book, but also the BOL. theres a trial version

>of SQL Server
>>included with the MS PRESS Trainingkit.
>>
>>--
>>best regards
>>
>>Peter Koen
>>-----------------------------------
>>MCAD, CAI/R, CAI/S, CASE/RS, CAT/RS
>>http://www.kema.at
>>.
>>

>.
>

Sponsored Links





Free Braindumps | MCSE braindumps software forum

Copyright 2003 - 2008 examnotes.net