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
"Accidental SQL" is such a perfect description... I've always found that the piece I was missing from my uni courses were the how all of the data works in the impresario database. The system admin docs help a lot there (Screen Ref/Table Reference)... PORD, PCONT, PBOOK are your friends too. I've reviewed a couple of courses from edx which I liked a lot, but they only run them from time to time (Querying with Transact SQL DAT201). Linkedin Learning has a lot... or the Mimo app (duolingo for code, basically) are all good places to start. There's another fun tip about BEGIN TRAN... remember you either have to commit or rollback as it will create a lock on the table which prevents other processes from accessing it until you do. If it's a busy/important table *cough* T_CUSTOMER *cough* then no one can use it until you're done... which is something I think we've all learned the hard way at some point. Other things I find helpful to keep in mind... everyone is new to SQL at some point, most of us google solutions all the time (if even just to copy/paste syntax), there are multiple -correct- ways to accomplish what you are trying to do, done is better than perfect, if it works-it works... and there are loads of people willing to help.