Giter Club home page Giter Club logo

project-mysql-all-for-one's Introduction

Project MySQL All For One

This project was developed while I was studying SQL at Trybe Programming School.

Skills I needed for this project:

  • Finding data in an SQL database;

  • Filter data specifically;

  • Manipulate tables;

Regular deadline: May 9, 2023 at 2:00 pm

๐Ÿ— Project structure

At the root of the project, there are files called desafioN.sql, each N equals the number of the challenge I performed.

๐Ÿ—’๏ธ Instructions for restoring the `Northwind` database
  1. Download the northwind.sql file and select "Save" to save the file to your computer.

  2. Open the file with some text editor and select the entire contents of the file using CTRL-A.

  3. Open the MySQL Workbench.

  4. Open a new query window and paste the entire contents of the northwind.sql file into it.

  5. Select all the code with the shortcut CTRL-A and then click on the lightning icon to run the query.

  6. Wait a few seconds (wait around 30 seconds before trying to do something).

  7. Click the MySQL Workbench button to refresh the database listing.

  8. Verify that the restored database has all of the following tables:

tables

  1. Right click on each table and select "Select Rows" and make sure all tables have records. If any are missing, proceed with the next step. Otherwise, you can copy each SQL command from the desafioN.sql files and see what they do.

  2. If there are tables missing, drop the database by right-clicking on the northwind database and selecting "Drop Schema" and redo the steps again, this time waiting for a longer time when running the restore script.

๐Ÿ–ฅ๏ธ To access

1 - Clone the repository: git clone [email protected]:VicSales28/project-mysql-all-for-one.git

2 - Enter the repository folder you just cloned.

You must be using node version 16 (or higher).

To check your version, use the command: nvm --version

3 - With the required version, install the dependencies: npm install

๐Ÿ—ฃ Feedbacks

Give me feedbacks, I'm open to new ideas ๐Ÿ˜‰

project-mysql-all-for-one's People

Contributors

trybe-tech-ops avatar vicsales28 avatar

Watchers

 avatar

project-mysql-all-for-one's Issues

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. ๐Ÿ“Š๐Ÿ“ˆ๐ŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.