SQL_Optimized
Contains SQL queries and their optimized versions (using indexing and CTEs)
Time breakdown analysis of parts of the queries and their runtimes -> used to guide optimization decisions
AWS
Created a server on pgadmin housed on AWS's Redshift and inserted data using PostGreSQL
Monitored performance metrics on pgadmin and AWS's CloudWatch dashboards
T7
Geosptial data analysis using MongoDB -> data stored in dictionary/JSON format
Data housed on a virtual machine on Azure -> SSH Bitnami connections shown
Various JavaScript queries (built stage-by-stage) written on MongoDB's Compass GUI