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
**self- hosted**
Congrats!
My formal education started with learning SQL via the certificate program in the computer training wing of a local university. I had been already been using it for years though. But in that piecemeal way where you know how to do a certain thing that needs to be done, but don't understand the larger context of what you are doing. If you can find a certificate program, I would highly recommend taking a least the intro SQL classes from that program.
As for SQL in the context of Tessitura, I would highly recommend you reach out to Tom Brown (I can put you in contact with him) for some training. I have used SQL in three other database over a ten year timespan and each time I started using a new database I had to to relearn some things or learn something new (functions, commands, components) that I never needed in the previous databases.
Finally, these forums are my saving grace! Many times my coworkers want something that I cannot whip out as quickly as they would like with my knowledge of the impresario database and I come here for help. 99% of the time I get the help I need, learn something new, and make a new friend.
Ashley Elliott
Database Administrator
St. Louis Symphony Orchestra
314-286-4198
ashleye@slso.org
Melanie Boma
Over the past few months, I've been offering to friends and colleagues in the Tessitura Community some SQL introductory sessions. If others would like to take me up on the same offer. We can start another session in May. I can give you more details. Please reach out to my email address tbrown7 @ ithaca.edu .
Melanie Boma I highly recommend the intro to sql course :)