Learning SQL

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

Parents
  • Hi Melanie, welcome!  

    I have totally been in your shoes. I started out as a box office manager, and quickly made my way towards database work. I agree with others that w3schools is great.  I'd personally recommend a class though.  I found an inexpensive one that I could take on Udemy (search for T-SQL there), and that helped so much! That way you can focus on the things you actually want and envision yourself using while having a teacher's support, but without having to put a ton of money into it. I also wouldn't hesitate to search the forums for what you want. A lot of help with code has been provided here, so your solution might already exist. 

    Is there anything in particular that you want to be able to do with SQL and Tessitura?

    I'm always happy to help as well! Don't hesitate to reach out. I'm definitely no SQL veteran, but I can hold my own, and having started my learning journey in the past 3 years, some problems you run into might be fresh in my brain, haha. 

Reply
  • Hi Melanie, welcome!  

    I have totally been in your shoes. I started out as a box office manager, and quickly made my way towards database work. I agree with others that w3schools is great.  I'd personally recommend a class though.  I found an inexpensive one that I could take on Udemy (search for T-SQL there), and that helped so much! That way you can focus on the things you actually want and envision yourself using while having a teacher's support, but without having to put a ton of money into it. I also wouldn't hesitate to search the forums for what you want. A lot of help with code has been provided here, so your solution might already exist. 

    Is there anything in particular that you want to be able to do with SQL and Tessitura?

    I'm always happy to help as well! Don't hesitate to reach out. I'm definitely no SQL veteran, but I can hold my own, and having started my learning journey in the past 3 years, some problems you run into might be fresh in my brain, haha. 

Children
No Data