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 Melanie - I was in the same boat as you about 15 years ago! I ended up taking a night school course through a local college to learn SQL. It gave me a good foundation for understanding a database and all the different statements. I would highly recommend some form of formal training rather than doing it on your own.
Also, something that is invaluable to me is a layout that someone from our org put together when we went live of how all the tables join together. I still use it to this day.
Are you able to share the layout? I've been teaching SQL to members of the community, and I'd appreciate being able to share any good tools that can be made available.
Stratford Festival Tessitura ERD mapping diagram.pdf
Here you go! I have this printed out at my desk and refer to it constantly. There is a error on one of the relationships but it's marked on the physical copy at my work office so I don't have it at home to correct the ERD.
The "Pmap" links need updating for price layers, at least.
Yes, for sure. I have some saved code that I use for those. We've been meaning to update this over the years, but it's one of those things that we never seem to find the time to do.
Wow! Thanks.
I hate creating ERD's - I had to do them in one of the classes I took - but I LOVE using one someone else created, lol
Ashley
All, here's a CTE for the joins to get back to the olde time-y T_PMAP - in case anyone wants/needs. --pmap= WITH pmap(pmap_no, price_category)AS ( SELECT a.id, c.price_category_id FROM [dbo].T_PERF_PRICE_TYPE a JOIN [dbo].T_PERF_PRICE_LAYER b ON a.perf_price_layer = b.id JOIN [dbo].TR_PRICE_LAYER_TYPE c ON b.price_layer_type = c.id )