Question Re: Help needed to learn SQL in Technology Q&A

Help needed to learn SQL

Former Member — Mon, 15 Jan 2007 12:16:51 GMT

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,

sAmik.

Re: Help needed to learn SQL

Former Member — Mon, 15 Jan 2007 16:02:39 GMT

Hi Samir,

You can start by learning , how SAP Tools can control MSSQL database.

http://help.sap.com/saphelp_erp2005vp/helpdata/en/25/1a47363d088e7be10000009b38f889/frameset.htm

Regards,

Siddhesh

Re: Help needed to learn SQL

Former Member — Mon, 15 Jan 2007 21:12:10 GMT

Samik,

There are some great websites out there that SQL Professionals use. I would recommend the following:

www.sswug.org (This one has a great list server that is reviewed by a number of SQL Server MVP’s)

www.SQLServerCentral.com

www.sqlpass.org/ (number one professional association)

I would also look to see if there is a local user group.

Regards,

Chris

Re: Help needed to learn SQL

Former Member — Tue, 16 Jan 2007 09:53:46 GMT

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

Re: Help needed to learn SQL

Former Member — Tue, 16 Jan 2007 12:02:16 GMT

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,

sAmik.

Re: Help needed to learn SQL

Former Member — Tue, 16 Jan 2007 12:06:03 GMT

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

Re: Help needed to learn SQL

Former Member — Tue, 16 Jan 2007 12:07:04 GMT

Yes from the SAP standpoint only Architecture Details , Optimization / Performance and Backup / Recovery procedures are required.

Regards,

Siddhesh

Re: Help needed to learn SQL

Former Member — Tue, 16 Jan 2007 12:39:14 GMT

Hi Siddhesh,

Any link on "important SQl queries" that can be run from Query Analyzer,some basic queries,e.g. how to check version of a database etc.

Thanks,

sAmik.

Re: Help needed to learn SQL

Former Member — Tue, 16 Jan 2007 12:41:38 GMT

Hi,

Start SQL Query Analyzer with admin privledges and give this query:

SELECT @@VERSION

Or else, check this link, for another way:

http://support.microsoft.com/default.aspx?scid=kb;en-us;q321185

Regards,

Siddhesh

Message was edited by:

Siddhesh Ghag

Re: Help needed to learn SQL

Former Member — Tue, 16 Jan 2007 12:45:10 GMT

Another suggestion is that with the current information you have , you should go on exploring on your own , I am sure you will find lot of interesting stuff available on various websites provided by me and others.

Regards,

Siddhesh

Re: Help needed to learn SQL

Former Member — Tue, 16 Jan 2007 12:52:28 GMT

Hi,

Thanks for the query.It worked.

Regards,

sAmik.

Re: Help needed to learn SQL

Former Member — Tue, 16 Jan 2007 12:54:20 GMT

Hi Samik,

Glad it worked, if your question is answered, you should mark this question as answered.

Regards,

Siddhesh