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?
Yes there are, however the schedule is not yet decided.
I suggest to attend the Pune one if possible.
Kind Regards,
Pinal
Hello Sir,
I am a 2 year experiene dot net developer .I wish to learn and get certified for Sql server (latest version).Can you suggest on this as where should i join the classes in Pune. and which track should i follow developer track or DBA track
Is there any future plan to organize similar event in South india?
Hi Vijay,
Yes, we do have plan for leading city in South India. However, we may not offer our next course till Jan 2010.
I strongly suggest to take advantage of the event of Pune.
Kind Regards,
Pinal
Hi Pinal,
Please Schedule event for same in Ahmedabad.
We Ahmedabad guys are very eager for same event.
Hi Paresh,
I live in Ahmedabad and there is no issue doing this course in Ahmedabad.
However, see if you can make it to event of Pune.
Kind Regards,
Pinal
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,
Hi Krunal,
This is not online event, it will be in person training delivery.
See if you can make it the event. Please register in advance.
Kind Regards,
Pinal
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 Imran,
This is great that you are coming to India. We are currently planning the session series and not sure at this moment, what will be our schedule.
However, I will sure send you email when I know more details about the same.
Additionally, do let me know where will be located in India. I would like to meet you in person if possible.
Kind Regards,
Pinal
Hi pinal,
Is there any future plans for conducting the seminar in mumbai.
Hi Deepak,
Absolutely, we do have plan for Mumbai but it will be sometime next year.
I strongly suggest that you register for the event in Pune.
Kind Regards,
Pinal
Hi Pinal,
Thanks…
Class is getting filled up.
Please let me know quickly if any of you want to reserve the place in the class. If it is from your company, please ask your company coordinator to talk to me with your reference.
Kind Regards,
Pinal
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
Hi Ganesh,
After announcing the session that session was booked by one company. We will have new session planned soon for everyone.
Kind Regards,
Pinal
do you have any online training class sir of performance and tuning class ?
no online class as of now. Only physical course.
Hi Pinal
HAPPY NEW YEAR – 2010
i want to do mcitp but there are some problems about mcitp that MCITP and MCDBA both are same. some technical person reply is both same i.e true please help me.
and Is there any future plan to organize event in delhi ?
thanks
dilip singh
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.