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
At a high level the concepts should be more or less the same, but SQL Server at least does tend to use a large number of specific extensions: I know that I use them all the time because I don't bother screening the syntax I look up for ANSI compliance, not sure how pervasive it is in Tessitura development. At least at my very middling level of expertise I shy away from other formats, as I haven't the brain space anymore for juggling things like that.
Thanks. That's what I was thinking.
Thank you! I'll keep hunting for something for Microsoft SQL Server.
Transact-SQL (T-SQL) courses can be found online on edX from time to time eg: https://www.edx.org/course/querying-data-with-transact-sql-2 and they are at a variety of levels and specific interests.
Thank you!
Echoing what others have said about PL/SQL not being super useful to T-SQL. If you like recorded training, I'm a big fan of Pluralsight's courses on T-SQL Querying, this one in particular (see also this full skill path). Quite a bit cheaper than most training courses, as well, being an easily-cancellable monthly subscription.
The literal SQL has many similarities, but in day to day work life it will be the completely different tools that you'll spend time getting comfortable with. It's been years since I've laid eyes on anything from Oracle, but when I last did so they had nothing like SSMS or SSRS.
Hi Anne, I agree an Oracle class wouldn't be useful for Tessitura. However, if you know some basic T-SQL but haven't dabbled in report building, then an SSRS course would be valuable. If you're totally new to T-SQL, then definitely stick with Microsoft SQL Server courses. In fact, there are some great (free) tutorials at sqlservercentral.com via their 'Stairways' series. Good luck!
The important part to learning any language (or application for that matter) is to understand the underlying fundamentals of what the project objective is and develop a good process to research the correct syntax. For example almost every language has some way of evaluating a boolean expression but the syntax may vary from one language to another. Being able to recognize that a boolean expression is needed is much more useful than memorizing the syntax of a specific language.
It is the same with point of sales systems, they all sell tickets, but understanding the underlying principals in how it is selling the ticket is much more useful than memorizing the steps to selling a ticket in a given application.
Pluralsight also has a 30% off sale every now and again so sign up for alerts and there will probably be something after xmas/newyear