564 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owls only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
|Wise Owl are now running a new Introduction to MySQL course|
|We've been teaching SQL to advanced level for a long time now, but it's always been using Transact SQL (T-SQL), the Microsoft SQL Server dialect. If you have a MySQL database we can now teach you using your correct dialect and coding environment (let us know if you are interested in PostgreSQL, PL/SQL for Oracle or any other dialect).|
There are a number of different dialects of SQL that you can learn. Here are the main four:
This MIcrosoft variant of standard SQL lets you create variables and run WHILE loops.
Another variant of SQL, which allows you to create variables and define objects working with Oracle databases.
This allows you to work with the open-source Postgres database (so named because it was a sequel to the original Ingres database). PL/pgSQL and PL/SQL are very similar.
This dialect allows you to work with the free and open-source MySQL (although it's actually owned by Oracle!).
Previously we've always trained only on the first one - SQL as it's written within SQL Server - but we are pleased to announce that we are now running courses in MySQL also.
You write MySQL within MySQL workbench. Any similarity between this and SQL Server Management Studio is surely intentional ...
Here's a simple MySQL query:
Still struggling to see the differences between T-SQL and MySQL? There aren't many!
We are amenable to the idea of adding the other two dialects of SQL to our course list (the different versions of SQL are very similar to each other). Let us know if you're a frustrated Postgres or Oracle database user who would love to book a Wise Owl SQL course, but can't!
Some other pages relevant to the above blog include:
25 Aytoun Street