IN SQL :

1.Press the command +spacebar keys to open "Spotlight Search" 2.Type "Terminal" and press enter it will open the command line; 3.Run the following command: 1.git clone https:llgithub.com/danspaes/db-sandbox.git 2.cd db-sandbox 3.docker-compose up -d Creating network "db-sandbox_default" with the default driver Creating db-sandbox_db_1 Creating db-sandbox_adminer_1 done . . . done 1.Open the Google Chrome and type: http://localhost:8080/ to access the login page System MySQL Server db 83 Username root Password Database Login Permanent login 2. 3. Put root, example and employees as Username, Password and database. Get all female employees . Get all employees hired after 01-01-1995 Get all the valid titles (with to_date equals to 01-01-9999) Get all salaries from 60000 to 90000 Get all titles where title is equal to engineer Insert a new row into course table with 1, 'CED-1250', 'Big Data Storage' Delete all male employees hired at 01-01-2009 Update the salary of employee 499984 to 100000 Delete all titles not valid (with to_date not equal to 01-01-9999) 1.Press the command +spacebar keys to open "Spotlight Search" 2.Type "Terminal" and press enter it will open the command line; 3.Run the following command: 1.git clone https:llgithub.com/danspaes/db-sandbox.git 2.cd db-sandbox 3.docker-compose up -d Creating network "db-sandbox_default" with the default driver Creating db-sandbox_db_1 Creating db-sandbox_adminer_1 done . . . done 1.Open the Google Chrome and type: http://localhost:8080/ to access the login page System MySQL Server db 83 Username root Password Database Login Permanent login 2. 3. Put root, example and employees as Username, Password and database. Get all female employees . Get all employees hired after 01-01-1995 Get all the valid titles (with to_date equals to 01-01-9999) Get all salaries from 60000 to 90000 Get all titles where title is equal to engineer Insert a new row into course table with 1, 'CED-1250', 'Big Data Storage' Delete all male employees hired at 01-01-2009 Update the salary of employee 499984 to 100000 Delete all titles not valid (with to_date not equal to 01-01-9999)