helping Digitial Music Store to optimize their business practices using PostgreSQL

dbt-duckdb playground using Chinook dataset

This Repo contains - Starter files, Coursework, Programming Assignments for the course --> SQL for Data Science from University of California, Davis [COURSERA]

Business Analysis using SQL, on the chinook database.

This repository contains the projects I completed for the DFND.

A NextJS employee manager PWA based on my awesome boilerplate & Chinook DB!

This repository contains all my projects reviewed by mentors during my Nanodegree

a tkinter gui for chinook database

Turns the static Chinook DB into a living OLTP simulator. Generates daily INSERTs, UPDATEs (late-arriving data), and DELETEs (cancellations). The perfect chaotic data source for testing real-world data engineering pipelines (CDC, SCD Type 2).

SQL query practice with the Chinook database.

A Django app to interact with PostgreSQL implementation of the famous Chinook Database using Django REST Framework.

Used SQLite to explore the Chinook database with SQL queries and gain insights into this fictional music store's data, from customers to tracks and albums.

Implementation of relational algebra operations in DBMS - Project, Select, Rename, Cross join, Theta join, and Natural join

Utility to facilitate fast feedback for learning SQL on a known SQLite database.

Querying fictional business data to answer business questions.

Database for sql training

Udacity DAND project - Coming up with 4 questions that can be answered with SQL. And visualize the results and represent them in a report.

Digital Music Store Analysis: Answering key questions using SQL (MySQL) and data visualization.

In this analysis, I developed SQL queries for the Chinook Database, which contains information about a digital music store. The goal was to assist the Chinook team in better understanding their media inventory, customers, employees, and invoice data.