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
Melanie,
There are a number of great online tools; W3Schools is good as a reference. The single most basic way to learn your SELECT statements as well as how the tables in Tessitura work is to take all of your lists, and look at the query it forms. Looking at the "Show Query" is where I started.
John
One thing about this that confused me was how Tessitura creates aliases. When you see those a., b., c., etc before information, just know that those are the aliases for the tables. They aren't really intuitive, especially when first learning. :)