krishnarohitreddy/MySQL-Exercises

Exercise in MySQL commands through the sakila sample database

MySQL Exercises

This project consisted of:

1. Importing a prepopulated database sakila into MySQL server by downloading MySQL Community Edition and MySql Workbench
2. Writing SQL to view and query data from the database
3. Writing SQL to insert, update and delete records in the database

Getting Started

Clone this repository by running the following command in your terminal:

git clone git@github.com:christiangallego/MySQL-Exercises.git

Then download the project dependencies by running this command in your terminal:

npm install

In the project directory, you can run:

npm start

Downloading MySQL

Make sure you have checked off the following tasks:

-Download and install MySQL Community Edition and MySQL Workbench

-Reference this documentation as it describes the prepopulated database called sakila that are used as the basis for these SQL exercises.

https://dev.mysql.com/doc/sakila/en/sakila-introduction.html

-Follow these instructions to load a sample database called sakila into your MySQL server.

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