Can someone use SQL for calculating operations like that of ms excel...? If yes what are the functions and attributes...?

Answer 1

Many of the calculations you would do in Excel can be done in SQL. Do you have anything particular in mind? The variety of calculations in both makes this complicated to answer in general.

Answer 2

Yes. They are called aggregate functions. Here are a few examples....

http://www.w3schools.com/Sql/sql_functions.asp