Although you saw in the my previous article that there are standards for SQL, that is not to say that all DBMSs are the same. The Web site DB-Engines collects and presents information on DBMSs and provides a monthly listing of them, ranked by their current popularity, at this link.
For many months now, their rankings have presented six DBMSs as consistently the most popular, listed in alphabetical order here (the versions that we used for our testing are in parentheses):
- IBM DB2 (DB2 for Linux, UNIX, and Windows v10.5.700.368)
- Microsoft Access (Microsoft Access 2007—also compatible with versions 2010, 2013, 2016, and later)
- Microsoft SQL Server (Microsoft SQL Server 2012—11.0.5343.0 or 2017)
- MySQL or MariaDb (MySQL Community Server 5.7.11 or 10)
- Oracle Database (Oracle Database 11g Express Edition Release 126.96.36.199.0 or 12c)
- PostgreSQL (PostgreSQL 9.5.2)
That does not mean that the material presented in this blog will not work on a DBMS not in that list of six. It simply means that we have not tested the material on other DBMSs or for different versions of the DBMSs listed. As you read my blog, you will see that we have included advice (as Notes) when it is necessary to make changes. Those Notes apply only to the six DBMSs listed here. If you are using a different DBMS, check your documentation for compliance if you run into issues with any of our samples. Reead this blog to choosing database for your project.