MySQL: Lesson 1, What is MySQL and Where do I start?
Before we get to MySQL, what is exactly is SQL?
SQL stands for Structured Query Language. It is a language designed to communicate with databases.
SQL is a non-proprietary language, there is a standard committee (ISO) that established the common SQL syntax but the SQL implementation you are learning here is called MySQL which happens to be open-source and free to use.
MySQL is a client-server software, meaning that to use MySQL you need both a MySQL Server and MySQL client. The server handles all the database operations, while the client is what you, the end-user, uses to interact with the database. If it helps to visualize this take a look the featured image above, the large central gold stack is analogous to the SQL server and the smaller blue stacks are the SQL clients used to interact with the server.
Tools: MySQL Workbench & MySQL Utilities.
MySQL Workbench (recommended for beginners)
MySQL workbench is suite of GUI tools designed for Database Administrators (DBAs) and developers an integrated tools environment for:
- Database Design & Modeling
- SQL Development (replacing MySQL Query Browser)
- Database Administration (replacing MySQL Administrator)
- Database Migration
SQL Development is a client used to write and execute MySQL commands. Database Administration, as the name implies, is used to simplify the administration of the MySQL servers.
MySQL Utilities is a collection of command line tools for maintaining and administering MySQL servers
Both MySQL Workbench and MySQL Utilities are available for download on the MySQL website here.