SQL Server T-SQL Boot Camp 3-5 days anywhere in the United States

  • I have a team of coders that I need to train how to code better in SQL 2005 and 2008. Is there a Microsoft approved partner that anyone knows about that I can send 2-4 people to train them on coding? I don't want to send them to DBA courses, because they are simply coders. I just want to beef up their coding knowledge so we can improve performance, technique, and efficiency.

  • I suppose that you're searching for something different than the Microsoft course 2778

    http://www.microsoft.com/learning/en/us/course.aspx?ID=2778A#fbid=EN0FHZ0dEvf

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2
  • You might check with Paul Randal's company, SQL Skills. If they can't help you, I'm sure they could recommend someone.

  • SQL_Enthusiast (6/21/2013)


    I have a team of coders that I need to train how to code better in SQL 2005 and 2008. Is there a Microsoft approved partner that anyone knows about that I can send 2-4 people to train them on coding? I don't want to send them to DBA courses, because they are simply coders. I just want to beef up their coding knowledge so we can improve performance, technique, and efficiency.

    I don't know what your budget is but such training can get pretty expensive.

    The things that made me a better coder were things that made me understand how SQL Server works behind the scenes. The portal into that is learning how to read and understand execution plans and some in-depth knowlege of how indexes work behind the scenes. I learned a good portion of those things by reading Grant Fritchey's book on execution plans and by watching some of Kimberly Tripp's videos on how indexes work.

    Grant's Book - http://www.red-gate.com/community/books/sql-server-execution-plans-ed-2

    My favorite "movie" on indexing - http://technet.microsoft.com/en-US/sqlserver/gg508879.aspx

    Of course, you also have to spend some time practicing or you won't remember any of it. 😀

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • This is exactly what I was looking for. Thank you

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply