learning Microsoft Query Analyzer

[justinjoylife]

Hi -

I'm completely new to Microsoft Query Analyzer and I need to learn it
for work to do data mining as a Product Manager. Does anyone have any
recommendations on how to learn this and where? Which books? What
classes? What links to online tutorials?

thanks

[Erland Sommarskog]

(ju***********@gmail.com) writes:

I'm completely new to Microsoft Query Analyzer and I need to learn it
for work to do data mining as a Product Manager. Does anyone have any
recommendations on how to learn this and where? Which books? What
classes? What links to online tutorials?

Query Analyzer is not a very difficult tool to learn. Basically it is
an editor from which you can run SQL queries. "Analyzer" is a bit pompous,
but since you can look at query plans, statistics about the queries,
I guess whence the name.

Anyway, data mining is something you do with Analysis Services and MDX,
and you don't do that from Query Analyzer. At least I think so. I'm
completely ignorant of Analysis Services and OLAP myself.

You may want to try microsoft.public.sqlserver.olap instead.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp