• Replies 11 replies
  • Subscribers 340 subscribers
  • Views 210 views
  • Users 0 members are here
Related

Would an Oracle SQL training class be useful for Tessitura?

Anne M Robichaux
$organization

Hello,

I've done some short, relatively simple online SQL classes and have been able to put some of it to good use in Tessitura. But I'd like to up my skill set. I know that Tessitura uses SSMS, but would an Oracle SQL course be useful? Or are there enough differences to confuse matters. Here's the course I'm looking at requesting funds for: https://careertraining.ed2go.com/delgadocc/training-programs/oracle-sql-training/?Category=computer-science-programming.

Thanks!
Anne

Parents
  • $organization
    Hi Anne,
     
    Microsoft SQL Server and Oracle are completely different database systems. The SQL Language in SQL Server and Oracle are similar or the same in some respects but not identical. Microsoft has always supported ANSI SQL, but not Oracle. Here’s what Oracle says about it:
     
    Oracle 9i now supports the ANSI/ISO SQL: 1999 standards. This allows easier product migration and a reduced learning curve when cross-training, but there is no performance increase compared to the existing syntax.
     
    Learning Oracle won’t help with Tessitura, but it’s definitely valuable to learn for your career, as is MySQL, MongoDB, NoSQL, PostgreSQL, etc.
     
    Cheers,
     
    Jerry Boutot | Manager, Information Technology - Data
    O: 813.222.1097 C: 352-428-4199
     
Reply
  • $organization
    Hi Anne,
     
    Microsoft SQL Server and Oracle are completely different database systems. The SQL Language in SQL Server and Oracle are similar or the same in some respects but not identical. Microsoft has always supported ANSI SQL, but not Oracle. Here’s what Oracle says about it:
     
    Oracle 9i now supports the ANSI/ISO SQL: 1999 standards. This allows easier product migration and a reduced learning curve when cross-training, but there is no performance increase compared to the existing syntax.
     
    Learning Oracle won’t help with Tessitura, but it’s definitely valuable to learn for your career, as is MySQL, MongoDB, NoSQL, PostgreSQL, etc.
     
    Cheers,
     
    Jerry Boutot | Manager, Information Technology - Data
    O: 813.222.1097 C: 352-428-4199
     
Children