SQL Authority News – Training MS SQL Server 2005/2008 Query Optimization And Performance Tuning

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.

SQL Authority News - Training MS SQL Server 2005/2008 Query Optimization And Performance Tuning MSQOPT

Reference: Pinal Dave (https://blog.sqlauthority.com)

SQL Index, SQL Server, SQL Training
Previous Post
SQLAuthority News – Data Compression Strategy Capacity Planning and Best Practices
Next Post
SQL SERVER – Sharepoint Resource Available for SQL Server

Related Posts

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,

      • 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,

  • Paresh Prajapati
    November 10, 2009 11:46 am

    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.


  • 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.


    • 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,

  • Hi pinal,

    Is there any future plans for conducting the seminar in mumbai.

  • Hi Pinal,


  • 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,

  • 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.


  • 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 ?

        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.

    Pinal Dave

  • HI Pinal

    in future there is any plan to organize similar event in mumbai

    sharad patil

  • Vinayak Rangate
    January 2, 2012 9:39 pm

    Hello Pinal

    Is there any Traning scheduled in Pune for SQL Server?

    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]

  • Rajan Mahajan
    May 23, 2017 7:49 pm

    Hi…. You have offered a useful information… thanks for sharing this.


Leave a Reply