sej2008 (8/1/2013)
I would like to know which algorithms is considered best for doing data mining.In which scenario clustering should be used or Neutral network should be used how to decide on that for data mining in real life data predictions.
This is quite a broad question, which simply cannot be answered in a few sentences. I recommend you pick up a book about the subject. This one might be a good start:
Data Mining with Microsoft SQL Server 2008
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP