any good books on SQL queries?

can anyone recommend a good book to teach myself SQL queries? I have a basic understanding but want to improve

You might start out with Bob Beauchemin's excellent book: A Developer's Guide to SQL Server 2005.

Eventually, you will graduate to Itzik Ben-Gan's (and others) two excellent books: T-SQL Programming and T-SQL Querying.

There are several other excellent books, those come to the top of my list.

|||

Mandy1,

I suggest to add this book to Arnie's list.

Pro SQL Server 2005 Database Design and Optimization

http://www.amazon.com/Server-2005-Database-Design-Optimization/dp/1590595297/ref=sr_1_1/105-0322821-1919616?ie=UTF8&s=books&qid=1180705710&sr=1-1

AMB

|||

Ken Henderson is also worth to read...

The Guru's Guide to Transact-SQL

ISBN 0-201-61576-2

regards

Andreas

any good books on SQL queries?

can anyone recommend a good book to teach myself SQL queries? I have a basic understanding but want to improve

You might start out with Bob Beauchemin's excellent book: A Developer's Guide to SQL Server 2005.

Eventually, you will graduate to Itzik Ben-Gan's (and others) two excellent books: T-SQL Programming and T-SQL Querying.

There are several other excellent books, those come to the top of my list.

|||

Mandy1,

I suggest to add this book to Arnie's list.

Pro SQL Server 2005 Database Design and Optimization

http://www.amazon.com/Server-2005-Database-Design-Optimization/dp/1590595297/ref=sr_1_1/105-0322821-1919616?ie=UTF8&s=books&qid=1180705710&sr=1-1

AMB

|||

Ken Henderson is also worth to read...

The Guru's Guide to Transact-SQL

ISBN 0-201-61576-2

regards

Andreas

Any Good Book Recommendations?

I know basic SQL and have passed two Oracle Exams, SQL and PL/SQL Programming. Ironically, my first (and only job unfortunately) was in MS SQL Server 2000. I want to know of a good overall SQL Book that is beyond beginner level. Something that answers questions like "How do you get rid of duplicate records in a table?", etc and other practical, real world issues. Is there such a text? It can be Oracle or MS or whatever as long as the theory is sound. Thanks.

ddaveWhile not a book, here are some good SQL sites:

Introduction to Structured Query Language
http://w3.one.net/~jhoffman/sqltut.htm
"Comprehensive SQL tutorial."

SQL Intrepreter & Tutorial With Live Practice Database
http://www.sqlcourse.com

SQL Tutorial
http://www.w3schools.com/sql/

aboutSQL by John Ashenfelter
http://www.oreillynet.com/pub/ct/19
"Provides information on SQL keywords, functions, tricks, and hacks"

SQLTeam.com
http://www.sqlteam.com
Site is mostly about SQL Server and includes forums.|||paul, the jim hoffman tutorial used to be the only decent sql tutorial on the web

but jim hoffman disappeared, and so did his site, a couple years ago

you can still get it at archive.org (http://web.archive.org/), where the latest version is November 2001, 4.76 (http://web.archive.org/web/20011116021648/http://w3.one.net/~jhoffman/sqltut.htm)

ddave, you may find some more tutorials on my SQL Links (http://r937.com/sqllinks.cfm) page

Any free reporting tool you recommend?

dun need sophisticated interactive reports, but just simple basic rigid reporting will do :D
looking for a simple tool for my end users. Crystal Reports a bit overkill....MS Access?
MS Excel?|||How about Reporting Services on SQL Server 2005

Regards
Kris Zywczyk|||yah, still trying out to set up the report server in SQL 2005, initial trial on the BI visio studio failed, dunno why.

Is the reporting services included in SQL 2005 express?|||What do you mean you want this for your users?

"are those rocks up ahead?"

"I don't know, but if they are, we all be dead"

OK, what movie.|||"No more rhymes now. I mean it!"

"Does anyone want a peanut?"|||"aaaaaaaaarrrrrrrrrrrrrgggggggggggggghhhhhhhhhh"

"What are you doing?"

"I think someone is following us"

"That would be inconcceivable"|||I personally love it when non-developers write production sql. I have project managers who do it for word merges. i have report writers who do not understand group by. It gives me plenty of things to fix and server slow downs to diagnose.|||"I'm not left-handed either."|||"How do you write women so well?"
"I think of a man, and I take away reason and accountability."|||"How do you write women so well?"
"I think of a man, and I take away reason and accountability."
Great !! :D