This is very short note announcing details about my course details for ‘Training MS SQL Server 2005/2008 Query Optimization And Performance Tuning’.
The course is scheduled to be delivered from 19th Nov, 2009 and 21st Nov, 2009 in Pune, India.
This three day course is an intensive course designed to give attendees an in-depth look at the query optimization and performance tuning concepts and methods found in SQL Server 2005/2008. This course is designed to prepare the SQL Server developers and administrators for a transition to SQL Server 2005/2008 while discussing best practices for a variety of topics.
Day 1 : Strengthen the basics along with SQL Server 2005/2008 New Features
Module 01: Subqueries, Ranking Functions, Joins and Set Operations
Module 02: Table Expressions
Module 03: TOP and APPLY
Module 04: SQL Server 2008 Enhancements
Day 2: Query Optimization & Performance Tuning 1
Module 05: Logical Query Processing
Module 06: Query Tuning
Module 07:Â Introduction to the Query Processor
Module 08:Â Review of common query coding which causes poor performance
Day 3: Query Optimization & Performance Tuning 2
Module 09:Â SQL Server Indexing and index maintenance
Module 10:Â Plan Guides, query hints, UDFs, and Computed Columns
Module 11:Â Understanding SQL Server Execution Plans
Module 12: Real World Index and Optimization Tips
The space are limited and I encourage you to register as soon as possible.
If due to any reason, you cannot attend this course, please call or email on details above for future schedule for the course and location.
Reference: Pinal Dave (https://blog.sqlauthority.com)
26 Comments. Leave new
Is there any future plan to organize similar event in Ahmedabad?
Is there any future plan to organize similar event in South india?
Hi Pinal,
Please Schedule event for same in Ahmedabad.
We Ahmedabad guys are very eager for same event.
Hi Pinal,
It’s really really good that you’re doing so many events for our community. I want to know that is there any possibility to get videos if I can’t make it to attend.
Please try to do if that’s possible.
Thanks,
Hello Pinal,
I am coming to India on Nov 25, I Would love to attend your session. Is there any feasilibility for another session / .
I wish you would have posted this post atleast a week back, last week I booked tickets to India.
Thanks.
Imran.
Hi pinal,
Is there any future plans for conducting the seminar in mumbai.
Hi Pinal,
Thanks…
Hi Dave , I am new at SQL Server I just want to know how to copy data from all tables in one database to others in another database after i scripted all objects .
Hi Pinal,
Came to know, this session is dedicated for a corporate. Any luck for we individuals to join. I am regularly awaiting checking for any such great news at sqlauthority/solidqualitymentors/seedinfotech.
Please make us not to wait much.
Regards
Ganesh
do you have any online training class sir of performance and tuning class ?
Hello Dilip,
MCDBA was certification for MS SQL SERVER 2000 and earlier versions. MCITP is same certification for SQL Server 2005 and later versions.
Regards,
Pinal Dave
HI Pinal
in future there is any plan to organize similar event in mumbai
Regards
sharad patil
Hello Pinal
Is there any Traning scheduled in Pune for SQL Server?
Regards
Vinayak Rangate
Hi,
I would like to learn performance troubbleshooting in sql server 2005
Kindly let me know if any event is organising in pune,mumbai
Pravin D.
[email removed]
Hi…. You have offered a useful information… thanks for sharing this.