SQLAuthority News – Microsoft SQL Server 2005/2008 Query Optimization & Performance Tuning Training

After successfully delivering many corporate training as well as the private training we are launching the Public Training in Hyderabad for SQL Server 2008. I will be leading the training on Microsoft SQL Server 2005/2008 Query Optimization & Performance Tuning Training. This intensive, 3-day course intends to give attendees an in-depth look at Query Optimization and Performance Tuning in SQL Server 2005 and 2008. Designed to prepare SQL Server developers and administrators for a transition into SQL Server 2005 or 2008, the course covers the best practices for a variety of essential tasks in order to maximize the performance. At the end of the course, there would be daily discussions about your real-world problems and find appropriate solutions.

The training premises are very well-equipped as they will be having 1:1 computers. Every participant will be provided with printed course materials. I will pick up your entire lunch tab and we will have lots of SQL talk together. The best participant will receive a special gift at the end of the course.

Even though the quality of the material to be delivered together with the course will be of extremely high standard, the course fees are set at a very moderate rate.

Feel free to drop me an email at pinal “at” SQLAuthority.com for any additional information and clarification.

The details of the course are as listed below.

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

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

,
Previous Post
SQLAuthority News – Free Download – Microsoft SQL Server 2008 R2 RTM – Express with Management Tools – SQL Server 2008 R2 Books Online
Next Post
SQLAuthority News – Public Training Classes In Hyderabad 12-14 May – SQL and 10-11 May SharePoint

Related Posts

13 Comments. Leave new

  • Abd-Elrahman
    April 27, 2010 1:38 am

    One of my dreams to attend in a training with you, but unfortunately it’s impossible to travel to India. Please I would to ask you to offer the course materials where I can buy it.

    Reply
  • Hi Pinal,

    I am a frequent reader of your blogs, really excited to your contents. Is there any future events in Delhi/NCR ?

    Reply
  • Hi Pinal,

    I’m a regular reader of this blog and its been my dream to attend your sessions. This training should have been scheduled on weekends considering working professionals :(

    Still trying hard to manage the timings to attend this one.

    Best Regards,
    Amit

    Reply
  • Hi Pinal,

    Do you have any plan to conduct Public Training Classes in Mumbai?

    Thanks
    Roshan

    Reply
  • Hi Pinal Dave!

    Unfortunately, I am not able to make it in India.
    Any plane to have it in Europe (e.g. UK).

    Can you share with me Modules’ outline?

    What is the possibility to buy the course materials?

    Thank you

    Reply
  • Hi again :)

    I have a question that is not related to his post, but I did send it to you before with no answer yet.

    Would you like please share with us the job description for Principle Database or Principle Database Administrator?

    It sounds interesting and I hope to get a reply soon (by email at least).

    Thanks again :)

    Reply
  • Hi Pinal,

    I am really wanted to attend your training, but unfortunately i am not in Hyderabad. Is there any way to buy the course material, if so can you please suggest me how.

    Thanks

    Reply
  • Hi Pinal,

    I am really wanted to attend your training, but unfortunately i couldn’t aware of your last training. Is there any forthcoming training in Chennai? Is there any way to buy the course material, if so can you please suggest me how.

    Thanks,
    Barani

    Reply
  • Is anyone have Notes of this training?

    Reply
  • sir

    please tell me to learn microsoft sql server it is necessary to have knowledge in c c++ java and any other programming langauges

    Reply
  • Hey,
    Can you keep me posted for you upcoming trainings?
    Thanks, Ramon

    Reply
  • I thank you for this useful and complete post, I was looking for post like this. I like your blog

    Reply

Leave a Reply Cancel reply

Menu
Exit mobile version