Skip to content

sundar911/aws_postgres_mongodb

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

13 Commits
 
 
 
 
 
 
 
 

Repository files navigation

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

About

This repository houses three of my projects for the class: Database Administration & Scaling.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published