/mysql-instagram-clone

MySQL Instagram Dataset clone - Challenges to play with the data. Learned from

MySQL Instagram Clone

This repo is a MySQL Instagram Dataset clone and includes some Challenges to play with the data.

Credits: I learned this at The Ultimate MySQL Bootcamp at Udemy.

Usage Instructions

Running it first time

  1. Download MySQL 8 Software. I recommend you to select legacy when the download prompt ask you for connector as it will later allow you to use things like Node.js which as of today isn't supported with standard connector.
  2. Download MySQL 8 Workbench.
  3. Start MySQL Server & Open MySQL Workbench
  4. Run run.sql via File => Run SQL Script
  5. File => Open SQL Script and open use.sql and execute it. Now we are using instagram_clone_db schema.
  6. File => Open SQL Script and open set_sql_mode.sql and execute it to avoid SQL Error 1055.
  7. Create these below queries with File => New Query Tab (or, use MySQL Workbench UI for the same)
    • SELECT * FROM users;
    • SELECT * FROM photos;
    • SELECT * FROM comments;
    • SELECT * FROM likes;
    • SELECT * FROM follows;
    • SELECT * FROM tags;
    • SELECT * FROM photo_tags;

Now you have all the data to play with! Use challenges folder to play with some 🙌 🔥

Playing with data later on after restarting software/system

  1. Start MySQL Server.
  2. Start MySQL Workbench.
  3. File => Open SQL Script and open use.sql and execute it. Now we are using instagram_clone_db schema.
  4. Create these below queries with File => New Query Tab (or, use MySQL Workbench UI for the same)
    • SELECT * FROM users;
    • SELECT * FROM photos;
    • SELECT * FROM comments;
    • SELECT * FROM likes;
    • SELECT * FROM follows;
    • SELECT * FROM tags;
    • SELECT * FROM photo_tags;

Now you have all the data to play with! Use challenges folder to play with some 🙌 🔥