The aim of this repo is to hold files for practice and academic purposes. Please feel free to fork this repo and try in you own
Install MySQL software from here
Each file will be the same name with different extension. For example test.sql will be the SQL statement, the text.html is the results of the related .sql file.
From the '2.world-testDB' folder and after the 'world_test' database is used.
This folder consists of the creation queries as well as the schema of the sakila database.
In order to use it from the MySQL Workbench programme choose from the menu File --> Open Model and choose the 'sakila.mdb' file. As far as the rest 2 files they make the database. First open and run the file named 'sakila-schema' run it and then open and run the file named 'sakila-data'.
It is required to have installed the MySQL software before to continue in next steps.
- Open MySQL Workbench on your personal device
- Click on the + symbol which resides next to MySQL connections
- Enter the following details:
- Connection Name = enter any text you prefer
- Username = workearly1
- Connection Method = Standard (TCP/IP)
- Hostname = 34.65.82.17
- Port = 3306
- Username = workearly1
- password = work123
Run the following queries
- USE world;
- SELECT DISTINCT(EventName) FROM Event WHERE CountryID=7 AND CategoryID=9
- USE world;
- SELECT COUNT(*) AS total_Countries,ContinentID FROM Country GROUP BY ContinentID;