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

Call to register – +91 98817 95739, +91 98508 43664, +91 99229 33319

Email to register – workshop “at” seedinfotech.com

If due to any reason, you can not attend this course, please call or email on details above for future schedule for the course and location.

Click to Enlarge

Reference: Pinal Dave (http://blog.SQLAuthority.com)

About these ads

25 thoughts on “SQL Authority News – Training MS SQL Server 2005/2008 Query Optimization And Performance Tuning

      • 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

    • 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

  1. 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,

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

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

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

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

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

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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s