I was asked by Brighton and Hove City Council in 2014 to write and provide a training course for developers to look at various implementations of SQL, considering both similarities and differences, to provide insights into where choices in coding patterns could and should be made and also to allow developers to move between SQL versions seamlessly. SQL implementations considered where Oracle, SQL Server, mySQL and PostgreSQL.
- Standard syntax and differences
- Departures from ANSI standards
- Data types, standard and proprietary
- Optimisation
- Meta data and information schema
- Procedural sql, t-sql overviews