• Replies 5 replies
  • Subscribers 336 subscribers
  • Views 72 views
  • Users 0 members are here
Related

Suggested SQL Training? (UK)

Rog Hildreth
$organization

Hi,

I'm looking into doing some SQL training, for purposes of report writing and extractions. There are quite a few SQL training courses to choose from, but can anyone suggest one that would be particularly appropriate for how this is used in Tessitura? 

(BTW, I'm based in Manchester, England.)

Thanks,
Rog

  • Former Member
    Former Member $organization

    Good day, Rog …

     

    I can’t recommend any specific classes, and there are lots of SQL books on the market.

     

    I subscribe to several SQL newsletters that are often helpful.

    You may want to check out:

    MSSQLTips newsletter@mssqltips.com

    SQLServerCentral.com subscriptions@sqlservercentral.com

    John Sansom john@johnsansom.com

     

     

    Regards

    Wendell Baskin

    Bass Hall – Fort Worth (Texas)

    wbaskin@basshall.com

     

     

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Rog Hildreth
    Sent: Friday, February 07, 2014 10:51
    To: Wendell Baskin
    Subject: [Tessitura Technical Forum] Suggested SQL Training? (UK)

     

    Hi,

    I'm looking into doing some SQL training, for purposes of report writing and extractions. There are quite a few SQL training courses to choose from, but can anyone suggest one that would be particularly appropriate for how this is used in Tessitura? 

    (BTW, I'm based in Manchester, England.)

    Thanks,
    Rog




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

  • $organization
    Don't be afraid of looking at the standard reports and reverse engineering the procedures and or the views. Creating a custom report usually stems off the standard report, so you can do a lot with those.


    --

    Regards,

    Troy Nelson



    From: "Wendell Baskin" <bounce-wendellbaskin7249@tessituranetwork.com>
    To: tnelson@smm.org
    Sent: Friday, February 7, 2014 3:06:35 PM
    Subject: RE: [Tessitura Technical Forum] Suggested SQL Training? (UK)

    Good day, Rog …

     

    I can’t recommend any specific classes, and there are lots of SQL books on the market.

     

    I subscribe to several SQL newsletters that are often helpful.

    You may want to check out:

    MSSQLTips newsletter@mssqltips.com

    SQLServerCentral.com subscriptions@sqlservercentral.com

    John Sansom john@johnsansom.com

     

     

    Regards

    Wendell Baskin

    Bass Hall – Fort Worth (Texas)

    wbaskin@basshall.com

     

     

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Rog Hildreth
    Sent: Friday, February 07, 2014 10:51
    To: Wendell Baskin
    Subject: [Tessitura Technical Forum] Suggested SQL Training? (UK)

     

    Hi,

    I'm looking into doing some SQL training, for purposes of report writing and extractions. There are quite a few SQL training courses to choose from, but can anyone suggest one that would be particularly appropriate for how this is used in Tessitura? 

    (BTW, I'm based in Manchester, England.)

    Thanks,
    Rog




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

  • $organization in reply to Troy Nelson

    Hi Rog,

    I had to teach myself SQL a few years ago when I started doing this stuff, and I found that I didn't actually need to know a lot in terms of SQL - the far more tricky part is working out how the impresario database is structured and what tables to look in to find the information you want.

    For learning the SQL, I just worked through the lessons on this website:

     

    www.sqlcourse.com

     

    Then, after that, I would make a copy of an existing stored procedure and start working through what they'd done with it. Any terms I came across I didn't understand I'd Google and read up on. The first few reports will be absolute killers, but after you've worked through a few of them, you'll start to get the logic of how the Tessitura database is structured.

     

    If I can throw in a plug for one particular book that I've found helpful for a broad overview of everything SQL that's worth having nearby, I like this one:

    http://www.amazon.co.uk/Microsoft-SQL-Server-2008-Bible/dp/0470257040/ref=sr_1_1?ie=UTF8&qid=1391988791&sr=8-1&keywords=sql+server+2008+bible

    It covers all the coding stuff, but also has a lot of sections on database administration as well, which you never know when it'll come in handy - even if you have IT guys to take care of all that.

    Cheers,

     

    Matt

  • $organization

    Hi Rog

    We have previously used http://www.nitrus.co.uk/ (previously EZE Training) and I notice they have a location in Manchester. In the past I've done an SSRS course and an SQL administration course, they seemed pretty good.

    Thanks

     

    Mark

  • $organization in reply to Mark Steel (Past Staff Member)

    We're big fans of w3schools.com over here. Personally, I used that to learn the basics of SQL several years ago. 

    Once you've got some basics, figure out how to use the SQL Profiler. You'll find out what all the interesting procedures and views and tables are that you can then take apart in your Test system.