need sql project - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

need sql project

Author

Topic

poornima
Starting Member

32 Posts

Posted - 2006-11-11 : 06:01:00

I need a simple SQL project,like pay rolls of a company,etc so that i acn improve in SQL,i feel its d best way to learn a language

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2006-11-11 : 06:23:02

Check out the following site, they have couple of sample projects I believe:

http://www.dotnetspider.com/

Also, to learn more about SQL, check out following links:

[url]sql.2000trainers.com/[/url]
[url]http://www.techtutorials.info/dataSQL.html[/url]
[url]http://www.1keydata.com/sql/sql.html[/url]

and of course, your best friend is Books Online!

Harsh Athalye
India.
"Nothing is Impossible"

poornima
Starting Member

32 Posts

Posted - 2006-11-11 : 06:30:07

Thanks Harsh.
Can u tell me how sql can be useful in payrolls,
n basically wht is a payroll

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2006-11-11 : 06:37:07

Payroll in simple terms means the system for calculation of the salary/wages of employees for certain period. It also encompasses keeping track of employees's leave record, deductions, bonus and taxes.

quote:
Can u tell me how sql can be useful in payrolls

Well, if you are building client-server app and making use of front-end/back-end model, you definitely need sql to do all the calculations and storing the records. Basically all the processing is done at the server-end and client is responsible to present the results in neat way.

Harsh Athalye
India.
"Nothing is Impossible"

chiragkhabaria
Master Smack Fu Yak Hacker

1907 Posts

Posted - 2006-11-11 : 07:43:55

quote:
Originally posted by poornima

Thanks Harsh.
Can u tell me how sql can be useful in payrolls,
n basically wht is a payroll

Seems to me some home work project on payroll?

Chirag

http://chirikworld.blogspot.com/

chiragkhabaria
Master Smack Fu Yak Hacker

1907 Posts

Posted - 2006-11-11 : 07:49:27

quote:
Originally posted by poornima

I need a simple SQL project,like pay rolls of a company,etc so that i acn improve in SQL,i feel its d best way to learn a language

Payroll is not at all an simple application, it requires lots of calculation when its comes costing.... distribution of the cost cost center wise....

for learning SQL you can start from the following stuff..
http://www.sql-tutorial.net/
http://www.firstsql.com/tutor.htm
http://www.w3schools.com/sql/default.asp

Chirag

http://chirikworld.blogspot.com/

pootle_flump

1064 Posts

Posted - 2006-11-12 : 06:45:19

quote:
Originally posted by poornima

I need a simple SQL project,like pay rolls of a company,etc so that i acn improve in SQL,i feel its d best way to learn a language