Tuesday, 30 May 2017
Task Pane 
Login
username:
password:
Remember Me
|Signup
Our Sponsors
Current Poll
SQL Server 2008
Are you ready for the upcoming SQL Server 2008 release?







[show results]
Full day seminar: Advanced T-SQL Programming in SQL Server 2000 and 2005
Author: Greg Linwood Date Posted: 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:
http://www.solidqualitylearning.com.au/course.aspx?coursecode=FDS0001IBG

Cost: AUS$300
SQL Server User Group members: AUS$250

Agenda:

Understanding Query Logical Processing
.Query logical processing phases
.Controlling logical order of join processing
Query Tuning
.Set-based solutions
.Iterative solutions
.Tuning examples
Advanced Querying Techniques and applying them to Solve Common Problems
.Optimizing aggregate calculations
.Pivoting
.Relational Division
.Unpivoting
.Auditing changes
.Using an auxiliary table of numbers
.Separating Elements
.Calculating row numbers
.Paging
.Custom Sequences
.Other ranking and window functions
.Tie breakers
.Reverse logic
.Relational Division
.Grouping Ranges (existing and missing)
.Custom Aggregations
Hierarchies
.Iterative solutions
.Path enumeration
.Nested sets
.Recursive queries
.Detecting cycles
.Sorting siblings
Exception Handling
New isolation levels
.Row versioning
.SNAPSHOT
.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