Help needed to learn SQL

[Former Member]

Hi,

My new client has SQL database on Wndows2k.I am working as a Basis Consultant and new to SQL.

Can anybody help me with necessary docs,links,ebooks etc to gain mastery over SQL databse ? Any help regarding know-how of SQL db from BASIS perspective will be extremely helpful.

Points guarranteed.

Thanks,

s<i><b>A</b></i>mik.

[Former Member]

Hi Samik,

Or else you could also download Complete SQL 2000 Express server which is available for free.

You can install the documentation which is very very good and is the official document.

See the feature list here:

http://www.microsoft.com/sql/editions/express/features.mspx

And download it from here:

http://go.microsoft.com/fwlink/?LinkId=64064

While installing , select custom/advanced install and then make sure you select documentation files, it is very useful.

Regards,

Siddhesh

[Former Member]

Hi Siddhesh,

Many thanks for your reply.Just one clarification.

How useful will it be,since the express edition is of 2005,whereas I'm workin on SQL 2000?Also,we are using SQL Enterprise Manager,not Server mangment studio.

I'd like to know about the Query Analyzer,what are the useful queries for maintenance and administering SQL db.

ANy reply will be very helpful.

Thanks,

s<i><b>A</b></i>mik.

[Former Member]

Hi,

Long ago there was a SQL Server 2000 express edition also available under the name of MSDE, however they (microsoft) are discontinuing MSDE so that's all you have.

The documentation must be the same, you can check this link, its SQL SERVER 2000 specific:

http://msdn2.microsoft.com/en-us/sql/aa336280.aspx

Regards,

Siddhesh