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