SQL-Portfolio

This portfolio is intended for learning purposes and demonstrates my SQL experience to be included in my CV.

Contents

1. Supermart Grocery Sales - Retail Analytics Dataset

Data on orders placed by customers on a grocery app.

Dataset source: Kaggle
Language used for querying: PostgreSQL
Use this file to import the tables
See my queries here

2. OVO Technical Test - Business Intelligence Internship 2021

Merchant data and transaction data from OVO for Business Intelligence internship recruitment selection.

Dataset source: OVO
Language used for querying: PostgreSQL
Use these files (transaction, merchant) to import the tables
See my queries here
See my analysis and finding in this report file

3. FARMAKAMI: A simple web-DBMS

A database management system for database course group project. The database is integrated with Django framework and deployed on Heroku. The database system can be used by end-user for CRUD purposes.

Dataset source: Database (CSGE602070) course at Fasilkom UI
Language and tools used for project: PostgreSQL, Python (Django), HTML+CSS, Heroku