sql server training course
Shared by: lestercaldwell
SQL Server Architecture, Internals and Optimisation Course Outcomes: with Microsoft author At the end of this course, the students will Kalen Delaney. be equipped with the knowledge to: • Examine details of SQL Server’s internal structures to determine their impact on Kalen will be in Australia to present this workshop in February 2008... query performance seats are strictly limited so don’t miss your opportunity to learn from • Use the SQL Server 2005 Dynamic one of the world’s leading experts in SQL Server Internals! Management Objects to determine SQL Server’s internal behaviour Course Summary: Who Should Attend: This comprehensive workshop has been developed This course is invaluable for all • Read graphical and text-based query by one of the world’s leading experts in SQL Server professionals involved in advanced plans to determine where a poorly internals. Topics to be covered include: solutions for SQL Server, including performing query needs tuning • Physical Storage Structures Database and Application • Determine if concurrency issues are • Index Design and Performance Tuning Developers, Database Administrators, causing problems with performance • Query Processing and Query Plans Architects and Database Analysts. and troubleshoot those problems • SQL Server Architecture and Metadata Kalen gives participants an in-depth • Use the SQL Server 2005 Graphical • Optimisation and Recompilation understanding of the mechanics • Concurrency Control: Locking, Blocking and Tools such as Proﬁler to determine how and internals of SQL Server in Row Level Versioning SQL Server is performing, and to use order to monitor, understand and • Query Tips and Techniques improve performance of database those tools as a basis for improving • Troubleshooting Tools applications. performance Brisbane 18th-22nd February Sydney 25th-29th February Author & Facilitator: The author of the best selling books Inside SQL Server 2000, Inside SQL Server 2005 – The Storage Engine and Inside SQL Server 2005 – Query Tuning and Optimization, Kalen has been a columnist for SQL Server Magazine since the ﬁrst issue as well as writing for MSDN and TechNet Magazines. Kalen’s SQL Server seminars have been delivered both internally for Microsoft events and as recommended training for premier Microsoft partners around the world. www.wardyit.com email@example.com Call 1300 927 394 to register for this course today as places are strictly limited.