Need some practice

[Water Cooler v2]

Please point me to a web resource from where I can study:

1) writing complex queries such as those involving HAVING, mult-level
nested queries, GROUP BY, T-SQL functions

2) Joins - a lot of practice

3) Stored Procedures, transactions, cursors and triggers - I need some
heavy-duty practice


Where can I get some good practice of the above? Also, please recommend
a good SQL Server/T-SQL book in the light of the above requirement.

[das]

Re: Need some practice

Here's a good one for joins. I like the colors for the join tables:

http://www.tek-tips.com/faqs.cfm?fid=4785

[--CELKO--]

Re: Need some practice

Have you gotten a copy of SQL FOR SMARTIES yet? It is required for
working SQL programmers. And my house payment :)

[Tony Rogerson]

Re: Need some practice

> Have you gotten a copy of SQL FOR SMARTIES yet? It is required for[color=blue]
> working SQL programmers. And my house payment :)[/color]

The book is of little use to working SQL programmers, a lot of the examples
aren't directly useable in SQL Server nor do they scale into the real world.

People are better off spending a couple of minutes searching GOOGLE for the
answers.

--
Tony Rogerson
SQL Server MVP
http://sqlserverfaq.com - free video tutorials

"--CELKO--" <jcelko212@eart hlink.net> wrote in message
news:1144801857 .130733.158410@ i40g2000cwc.goo glegroups.com.. .[color=blue]
> Have you gotten a copy of SQL FOR SMARTIES yet? It is required for
> working SQL programmers. And my house payment :)
>[/color]