Skip to content

VermaDeepali/DATABASES

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

34 Commits
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Database Query Repository:

Welcome to the Database Query Repository! This repository serves as a comprehensive collection of queries and examples related to various databases that I have utilized throughout my experience.

The covered databases include:

MongoDB: A NoSQL database known for its flexibility and scalability.

MySQL: A powerful relational database management system widely used for structured data.

DynamoDB: A fully managed NoSQL database service provided by Amazon Web Services (AWS), offering seamless scalability.

Redis: An in-memory data structure store used as a database, cache, and message broker.

PostgreSQL : It is a powerful, open source object-relational database system that uses and extends the SQL language combined with many features that safely store and scale the most complicated data workloads.

Query Examples Explore the queries and examples provided for each database:

MongoDB (In-progress)

-- Basic Queries

-- Aggregation Pipeline (Will be adding soon)

MySQL (Completed)

-- SELECT Statements

-- JOIN Operations

DynamoDB (In progress)

-- Setup DynamoDB Locally --> https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/DynamoDBLocal.DownloadingAndRunning.html

-- Querying by Partition Key

-- Secondary Index Query

Redis (Not yet added)

-- Setting and Retrieving Key-Value Pairs

-- Using Pub/Sub for Messaging

PostgresSQL (Not yet added)

Feel free to explore and adapt these queries for your specific needs. Happy querying!