• Replies 5 replies
  • Subscribers 336 subscribers
  • Views 75 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

Parents
  • $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

Reply
  • $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

Children
No Data