MySQL Workbench is default IDE for MySQL and it is available to download for free on MySQL’s website. It is a fully featured IDE with three major sections. 1) SQL Development 2) SQL Administration and 3) Data Modeling. Each section is quite big on its own. There are plenty of different shortcuts to do various tasks in MySQL Workbench. I have decided to build a cheat sheet for MySQL Workbench which contains all the workbench shortcuts for the MySQL Workbench. You can print it and keep it in your work desk-wall and refer to it whenever you are using Workbench. Initially, it will be difficult to remember all the shortcuts, but as you keep on using them, you will remember the major shortcuts which you use in your daily life. This will be indeed productivity boost for your daily database tasks.
SQL Server Cheatsheet has been extremely popular download from my blog. There are plenty of request for me to update it with SQL Server 2012 features. I have finally upgraded the cheatsheet with SQL Server 2012 features. The new cheatsheet has following updates
SQL Server 2012 Datetime Functions
SQL Server Ranking Functions
SQL Server 2012 Analytic functions
It has been excellent experience to upgrade the cheatsheet. However, as the new cheatsheet contains way more information than earlier version of the cheatsheet, the size of the page is also increased. The page size is now no more A4 size, it has been increased to A3 size. When printed on A3 page it looks very clean and easy to read. If you print that on A4, you will find the pages are bit small.
Cheatsheet is free for anybody and everybody to download and print it, as long as you do not modify it. However, it is now allowed to store, host or upload anywhere without prior permission.
Previous cheatsheet was very popular and I have received many good comments. I am eagerly waiting for your feedback about this new updated cheatsheet.