Learning SQL

[Skyline]

I'm wanting to learn SQL, such as writing reports from the back-end of databases using SQL Server.

I;m not sure where would be best to start for someone with absolute zero knowledge on it!

the reason i want to learn is to broaden my knowledge, i currently work in IT and know the companys systems off the back of my hand, but i now want to learn SQL as the databases we use are SQL based, and wouldnt mind going into the SQL report writing if I ever fancy a change from IT.

So any help on good websites to start would be helpful!

Oh, any "try google" type posts will be deleted and infracted if I feel likei t

 

[Zen2]

This should help mate.

http://www.it-career-coach.net/category/sql-report-writing-training/

 

[Skyline]

Ta Zen.

 

[Hazuki]

http://www.tizag.com/sqlTutorial/

Good reference site .

 

[kyndigs]

By report writing, You have to tap into SQL's reporting services? Its a pretty advanced topic to start with, you should really work your way up from the start. Although the reporting is sexy!

MSDN: http://msdn.microsoft.com/en-us/library/ms159106.aspx

 

[Skyline]

Yeah it's using SQL Reporting Services.

The reports we produce are not as advanced as that above, basically just pulling a list of names / details out of the database by different criterias.

I know how to work some basic software they use to create reports as I worked in MIS for over a year before I moved into IT, so now just need to learn the SQL language.

 

[mapadale]

SQL reporting in 2005 is so much easier to do than what it was in 2000, just a few basic commands can run a report for just about anything.

 

[jasper]

can you not try and get a copy of crystal reports?