MySQL Resources

MySQL websites

MySQL Official website – official MySQL website. You can download MySQL, patches, and other tools that help you work with MySQL more efficiently.

MySQL Community Server – provides MySQL Community server download links, which are available on various platforms e.g., Linux, Windows, Sun Solaris, and Mac OS X.

The Art of SQL Tuning for MySQL – a very interesting slide about SQL tuning for MySQL.

MySQL Optimization – the official manual MySQL Optimization with various techniques including optimizing SELECT statements, locking, and disk usage issues.

MariaDB tutorial – MariaDB is a compatible drop-in of MySQL. The MariaDB tutorial website provides you with useful and practical MariaDB tutorials.

MySQL GUI Tools

MySQL Workbench – a database design tool for MySQL developers. It has quite a lot of features such as visual database design, forward and reverse engineering, changes management, and database documentation. MySQL database workbench has a community version that you can download and use for free.

HeidiSQL – one of the most popular tools for MySQL and MariaDB. Besides MySQL and MariaDB, it works well with PostgreSQL and Microsoft SQL Server.

phpMyAdmin – a free MySQL database administration tool over the web. It is written in PHP and is widely used by the community to manage MySQL databases.

MySQL GUI tool – MySQL GUI tool allows you to manage MySQL databases. It combines features of almost MySQL GUI tools such as query browser, and MySQL administrator. It has both community and enterprise versions.

SQL related websites

SQL Tutorial – a comprehensive SQL tutorial that helps you learn basic to advanced SQL with practical examples.

PL/SQL Tutorial – an easy-to-follow PL/SQL tutorial that teaches you about PL/SQL in Oracle Database.

PostgreSQL Tutorial – A practical PostgreSQL tutorial.

SQLite Tutorial –  an excellent SQLite tutorial that gives you step-by-step of how to work with SQLite from beginner to advanced level.

Oracle Tutorial – a great website for learning Oracle Database 12c.

SQL Server Tutorial – an awesome website for learning SQL Server.

Db2 tutorial – an essential guide to IBM Db2 database.