2/05/2005 11:03:53 AM
SQL querying problems, especially the tough ones, have very much in common with pure logical puzzles and brainteasers. Some SQL problems seem too hard, or impossible to solve; however, by applying pure logic you can often come up with short, efficient set-based queries.
By practicing logical problems that seem unrelated to SQL at first glance, you can improve your "outside the box" thinking, and your ability to solve tough querying problems.
In this session you will be presented with pure logical puzzles and brainteasers that require outside the box thinking, and also tough practical T-SQL problems that require logical deductions. The session will cover solution in both SQL Server 2000 and SQL Server 2005.
Itzik Ben-Gan is one of the founders of Solid Quality Learning. A SQL Server MVP since 1999, Itzik has delivered dozens of training events across the US and Europe focused on T-SQL Programming, Performance Tuning and Internals, Administration, Implementation, Data Warehousing and OLAP. An accomplished author, Itzik has written many articles for SQL Server Magazine as well as articles and whitepapers for MSDN and co-authored the book Advanced Transact-SQL for SQL Server 2000 (APress). In 1999 Itzik founded the Israeli SQL Server and OLAP Users Group and has been managing it since. Itzik makes his home outside Tel-Aviv with his wife Lilach.
Venue: Brisbane |
Duration 1.5 hrs |
On: Thursday, 19 May 2005