Post reply

Sql Training course teaching materials help

  • July 24, 2012 at 9:39 am

    #73361

    I have been tasked to find introductory training course materials so myself and one of our developers can teach another department very basic SQL skills. This department has limited interaction with SQL databases only dealing with select statements working with a custom in house program to take the Select statement and turn it into a csv file.

    While I could write up a course we would prefer a ready built course with handouts and a database ready to deploy (Even if it is Adventurworks) as i am rather busy with other projects right now. I have been working google but so far have only found teach your self books or online training programs for a single person, both of which are less than ideal.

    the topics covered should include at least basic SELECT and JOIN, CASE, and the major built in functions (MIN, MAX, AVG, DATEADD, DATEDIFF, SUBSTRING etc.).

    EDIT: Knowing that good training costs money, its not an issue if the materials cost something.

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

  • July 24, 2012 at 5:08 pm

    #1517120

    w3schools.com

    It even let's folks try things.

    --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)

Viewing 2 posts - 1 through 1 (of 1 total)

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