🗄️ SQL_NoSQL_Explorer

A comprehensive database repository for learning MongoDB (NoSQL) and SQL (RDBMS).
Includes tutorials, best practices, and hands-on examples for CRUD, aggregation, indexing, transactions, security, replication, and database DevOps.

---

🎯 Goals

• Learn MongoDB and SQL fundamentals and advanced concepts
• Perform CRUD operations, data modeling, and indexing
• Understand replication, sharding, and high availability
• Apply security best practices and role-based access
• Optimize queries and database performance
• Explore ORM, ETL, and DevOps practices

---

📚 Topics Covered

🟢 MongoDB (NoSQL)

• MongoDB Overview & Use Cases
• Installation and Setup
• Databases, Collections, Documents
• CRUD Operations (Mongo Shell & Drivers)
• Schema vs Schema-less, ObjectId Structure
• Queries: find, filter, projection
• Inserting, Updating, Deleting Documents
• Indexes: Single-field & Compound
• Aggregation Framework & Pipelines
• Map-Reduce Operations
• Data Modeling Principles
• Arrays, Sub-documents, and Pagination
• Bulk Operations, Change Streams
• Sharding, Replica Sets, Replication & Consistency
• Transactions, TTL Indexes, Geospatial Queries
• GridFS File Storage
• Encryption at Rest & In Transit
• Query Performance Profiling & Index Optimization
• Caching Patterns
• Monitoring, Backup & Restore
• Security: Authentication, Authorization, Auditing, RBAC
• Best Practices for Security & Performance

🔵 SQL (Relational Databases)

• RDBMS Overview & Use Cases
• SQL Basics: DDL (CREATE, ALTER, DROP) & DML (SELECT, INSERT, UPDATE, DELETE)
• Data Types & Constraints (Primary Key, Foreign Key)
• Joins (INNER, LEFT, RIGHT, FULL)
• Aggregate Functions: COUNT, SUM, AVG
• GROUP BY, HAVING, ORDER BY, DISTINCT
• Subqueries, Nested Queries, Views, Materialized Views
• Stored Procedures, Functions, Triggers
• Transactions & ACID Properties
• Indexes, Execution Plans, Query Profiling, Optimization
• Window Functions, Common Table Expressions (CTE)
• Partitioning & Temporal Tables
• Full-Text Search
• Replication, Sharding, High Availability
• Database Migrations & Schema Versioning
• Data Warehousing & ETL Processes
• Backup, Restore, Monitoring, Alerting
• ORM Overview & SQL Injection Prevention
• DevOps & Data Governance for Databases
• Compliance & Auditing

---

🧾 Folder Structure

SQL_NoSQL_Explorer/
├── MongoDB/
│   ├── CRUD/
│   ├── Aggregation/
│   ├── Indexes/
│   ├── Transactions/
│   └── Security/
├── SQL/
│   ├── Basics/
│   ├── Joins_Aggregates/
│   ├── Stored_Procedures/
│   ├── Transactions/
│   └── Optimization/
└── README.md