Skip to content

SQL Instagram Project from Udemy, "The Ultimate MySQL Bootcamp: Go from SQL Beginner to Expert" by Colt Steele

Notifications You must be signed in to change notification settings

tomtranjr/instagram_db_clone_sql

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

10 Commits
 
 
 
 
 
 

Repository files navigation

SQL Instagram Project

Short SQL project based on "The Ultimate MySQL Bootcamp: Go from SQL Beginner to Expert" by Colt Steele.
Queries explore user behavior and content patterns in an Instagram-style dataset.

Questions Answered

  1. Oldest users: Find the 5 earliest account registrations.
  2. Ad timing: Which day of the week has the most registrations?
  3. Inactive users: Who never posted a photo?
  4. Top photo: Which user owns the single most-liked photo?
  5. Posting cadence: How many times does the average user post?
  6. Popular topics: What are the top 5 most-used hashtags?
  7. Potential bots: Which users liked every post?

About

SQL Instagram Project from Udemy, "The Ultimate MySQL Bootcamp: Go from SQL Beginner to Expert" by Colt Steele

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published