Essential Oracle 21c SQL training course

Synopsis for Oracle 21c Essential SQL training course

With quite a few Database manufacturers in the marketplace, a Developer might be forgiven for thinking that all versions of the SQL language are identical and knowing one version will give them the ability to use these skills on the other Database platforms, sadly this isn’t the case.

Wasn't it George Bernard Shaw who said that Britain and America are divided by a common language.



For example SQL in Oracle and MySQL, both owned by the Oracle Corporation have a great many similarities but the SQL syntax isn't interchangeable, even the similar programming functions have different names and indeed programming syntax, take for example the definition of a column in a table to contain alphanumeric characters, in Oracle its normal to use the Varchar2 datatype, in MySQL the Developer can choose from Char, Varchar, Binary, Varbinary, Tinytext (not to be confused with Tiny Tim), Text, Mediumtext and Longtext and a few others we can name.



We teach both MySQL and Oracle SQL and believe us they are entirely different courses, put another way think of SQL in different Databases as like pasta, of course the anticipated result is the same, a delicious meal, but think of all the different pasta types and shapes there are, at last count there are over 25 different varieties and they like SQL are recommended for different sauces and recipes, some of our favourite pastas include;

Spaghetti – Ideal for a first date to show your new friend how much ruining an expensive white shirt means little to you when it comes to splashing the sauce all over you, one of our colleagues cuts the spaghetti in half when cooking, that’s just wrong!! you just can’t wind it on your spoon and it falls back onto your plate like a pair of underwear when the elastic has finally given up !!!



Is there anyone who hasnt at some point in their life had a tin of Heinz Ravioli ? happy days spent eating with a plate on your knees watching star trek with ravioli on toast for your tea, have you tried making them yourself though ? i think we were too greedy with the amount of filling, every one burst !



Of course for ease of eating you wont beat penne pasta, easy to pick up with a spoon or a fork and you can never be in danger of loading too much for your mouth (unlike spaghetti!), think of our Oracle SQL course as being like penne pasta, we feed you small, edible portions of information over the two day duration of the course without you getting too much at any one time and then lo and behold you have had your fill of the Oracle SQL language, you walk away satisfied and knowing a lot more than you did about SQL the day before.

Of course the name 'penne' means either feather or pen, and in the modern idiom 'sql is more powerful than the sword'! Although we wouldnt run away from someone wielding SQL !! (cowards run in our family)

Everyone has heard of spaghetti and penne but have you heard of ziti ? no we hadnt heard of it either until we were researching this article, apparently its great in lasagne type dishes, who knew !!

We so like the idea of a self-winding spaghetti fork ...



Continuing on the Pasta theme, we always think that the conchi pasta looks like an ear, and again talking about the Essential Oracle SQL course, it does have a Consultant led trainer who will not only cover the techniques and examples in the very comprehensive manuals we give you but will also give you the benefit of their commercial experience so listening is essential on the course, as well as excellent presentation there are lots of exercises for you to work your way through, it could be said, we’ve given you the recipes now it’s your turn to produce the finished SQL (meal).

Now onto the business part of this page, you want to learn Oracle SQL, we can provide this course as an on-site course or the latest version is available at a series of venues throughout the UK and Ireland all the year round, start by contacting our friendly client liaison on enquiries@seercomputing.com.