How to Upgrade T-SQL Skills

  • Super Cat

    SSCertifiable

    Points: 7316

    Thanks all.

  • Eric M Russell

    SSC Guru

    Points: 125089

    Grant Fritchey (9/27/2016)


    Eric M Russell (9/27/2016)


    Talib123 (9/27/2016)


    Hi All,

    I'm a production DBA and have been for a good while.

    I can query, join filters but how do I get my T-sql skills to a developer\Report writer level.

    Books don't do it for me, links to useful youtube sights will be most usefull.

    Are an MVP to follow. I have been putting this off for years now.

    Thanks

    The vast majority of good T-SQL learning material will be in the from reading (books, blogs, and forums) and also practicing. However, since you're specifically asking for good video related material, I'd say search YouTube for:

    T-SQL AND ("Kevin Kline" OR "Itzik Ben-Gan" OR "Grant Fritchey" OR "Adam Mechanic" OR "Brent Ozar")

    ooh, not me. I don't write T-SQL like those other people. I teach mechanisms & processes and some internals. That hard core coding stuff, I leave that to the smart people.

    From what he says, it sounds like he knows basic T-SQL (the easy stuff) and now as a developer wants to take it to the next level, analyzing execution plans and optimzing SQL (the hard core stuff). That's where you and the other guys I mentioned come in.

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • Wayne West

    SSC-Insane

    Points: 22586

    edX has a course that might work for you, Querying Transact-SQL. You'll set up an Azure VM with a sample database, link it in to your local SSMS, and do all sorts of stuff with an abbreviated copy of AdventureWorks. Lots of good info in it.

    I completed it a couple of months ago and picked up a number of little things that I didn't need but might prove useful.

    The best part is that it's free, unless you decided to pop $50ish for a certificate.

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • Super Cat

    SSCertifiable

    Points: 7316

    Thanks Wayne.

  • Jeff Moden

    SSC Guru

    Points: 996676

    Talib123 (9/27/2016)


    Hi All,

    I'm a production DBA and have been for a good while.

    I can query, join filters but how do I get my T-sql skills to a developer\Report writer level.

    Books don't do it for me, links to useful youtube sights will be most usefull.

    Are an MVP to follow. I have been putting this off for years now.

    Thanks

    Step 1 is to download a free copy of SQL Server Developer's Edition. It works on your desktop or laptop without having to install Windows Server and is the same as the Enterprise Edition but with special limited licensing.

    Step 2 is to teach yourself how to correctly make a shedload of test data at the drop of a hat... any hat. The following articles can help there.

    http://www.sqlservercentral.com/articles/Data+Generation/87901/

    http://www.sqlservercentral.com/articles/Test+Data/88964/

    Step 3 is to learn about how to count without using loops. The articles in Step 2 above can help there.

    Step 4 is as has already been suggested... start reading posts on this forum and then start working some of the problems. Read how some of the heavy hitters solve the problems. Unlike that what you might find in books, most of the problems are real life problems with real life solutions.

    The more you repeat step 4, the more you'll learn because it's a huge subject with a never ending and changing supply of fascinating problems even if the questions are simple.

    --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".
    "If "pre-optimization" is the root of all evil, then what does the resulting no optimization lead to?"

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

Viewing 5 posts - 16 through 20 (of 20 total)

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