MYSQL Setup

To learn SQL queries, we will be using Mysql database and a sample employee database to perform SQL operations.

Let’s set it up

  • Install Mysql database: Follow

https://dev.mysql.com/downloads/installer/

You can refer to this video link for easy installation steps

https://www.youtube.com/watch?v=u96rVINbAUI

  • Setup employees test database: Follow

https://dev.mysql.com/doc/employee/en/employees-installation.html

You can refer this video link for easy set up

https://www.youtube.com/watch?v=eP_W-nbpYIo


Once the employees test database is set up and accessible through command line or Workbench, we are all set to go ahead.

This is how our set up database looks like

Employees test database