7/05/2005 8:51:29 AM
If you're a developer or DBA who has developed some experience working with T-SQL for some time now by learning from the seat of your pants and want to upgrade your skills, this full-day seminar is for you.
In this seminar, Solid Quality Learning Mentor Itzik Ben-Gan tackles common problems you're probably dealing with in your day-to-day work and shows you how to deal with them using simplified, highly efficient, optimized solutions in both SQL Server 2000 and SQL Server 2005. Learn how to think set-based and apply logic resulting in unique outside the box solutions.
The seminar also covers the important T-SQL enhancements in SQL Server 2005, showing how these can be used to optimize solutions to existing problems.
To register, visit the Solid Quality Learning website at:
SQL Server User Group members: AUS$250
Understanding Query Logical Processing
.Query logical processing phases
.Controlling logical order of join processing
Advanced Querying Techniques and applying them to Solve Common Problems
.Optimizing aggregate calculations
.Using an auxiliary table of numbers
.Calculating row numbers
.Other ranking and window functions
.Grouping Ranges (existing and missing)
New isolation levels
.READ COMMITTED with SNAPSHOT
Venue: Cliftons & Associates - 255 Adelaide Street, Brisbane |
Duration 8:30am arrival & coffee. 9:00am start. 4:30pm finish |
On: Wednesday, 18 May 2005