Hello!
I'm new to this forum as my position changed within the last year from Box Office Manager to a more IT related field of Tessitura Database Manager. I've been learning a great deal through Tessitura training courses offered and the assistance of Tessitura support, however I hit a road block when it comes to anything requiring SQL knowledge which pops up very frequently. Since I didn't come from an IT background, I'm lost when it comes to this and it gets tough when I keep having to go to Consulting and present a charge to Administration to get a task completed. Do any of you have advice on how to gain basic SQL knowledge to do tasks in Tessitura. And if there are any of you who were in this same position, how did you go about learning and moving forward?
Thank you so much,
Melanie
Hi and welcome to the club. SQL can be daunting at first but with a little bit of practice it becomes much clearer to understand I promise. As already suggested I found recreating lists and just scripting out stored procedures to see if I could make sense of what they were doing and how things linked together a good place to start. I found www.udeny.com a really useful resource. They've got some good free courses that cover the basics. I definitely agree with Heath and Martin, if you aren't using any form of source control keep a note of your code (new and original) and always work in a test environment first. One thing I will say if having that front end knowledge and experience of how Tessitura works is a huge bonus. Good luck.