I’ve been a SQL developer since 1989. In that time I’ve written numerous systems, solved many logic and performance issues and been able to compare and contrast different SQL flavours.
I’ve often been responsible for establishing development patterns that have been adopted as best practice within an organisation.
I have written and presented various training courses detailing and comparing Oracle, SQL Server, MySQL and PostGreSQL. For specific comparison training I have contrasted the following areas:
- Syntax
- Data Types and Limits
- Meta data
- Optimisation
- Procedural SQL