Job Ready SQL

Lesson 5Working with MySQL Server

Up to this point you have been learning about relational database theory. Now it is time to get your hands dirty and turn theory into practice. This lesson will walk you through installing a tool that will let you enter and run SQL code. This includes installing a database, MySQL, as well as MySQL Workbench, a database management application.

Learning Objectives

By the end of this lesson, you will be able to:

• Install the MySQL database server and client
• Use a command‐line interface to connect to MySQL Server
• Install the MySQL Workbench database management application
• Identify the main MySQL Workbench interface elements
• Use the Schemas panel to view database details
• Create a database from a SQL script
• Execute a SELECT query

MySQL INSTALLATION

MySQL is a relational database management system (RDBMS) that runs as a server providing multi‐user access to multiple databases. This section will cover the steps of installing MySQL. During installation, you will be asked to set the MySQL root user password.

IMPORTANT! Do not forget your root password. If you forget it, you won't be able to use your tools.

MySQL's installer will be used for the installation. It installs everything needed for MySQL development and makes the 32‐/64‐bit decision for you.

Step 1: Get the Download

Browse to the MySQL download page at dev.mysql.com/downloads/windows/installer. If necessary, scroll down a bit until you see the downloads, similar to what is ...