HomeCourse Details

Database Management (MySQL / MongoDB)

Bridge the gap between SQL and NoSQL. Learn to manage and scale both relational (MySQL) and document (MongoDB) databases.

Back to All Courses

Syllabus

Database Management (MySQL / MongoDB) Course

  • Complex Queries

    • Advanced Joins (Self Join, Cross Join)
    • Window Functions (ROW_NUMBER, RANK)
    • Common Table Expressions (CTEs)

  • Optimization

    • Creating and analyzing Indexes
    • Query Execution Plans
    • Transactions (ACID properties)

  • NoSQL Basics

    • Relational vs Document Databases
    • Collections and Documents
    • BSON data format

  • MongoDB CRUD

    • insertMany, insertOne
    • find, findOne with complex filters
    • update, delete operations

  • Aggregation Framework

    • $match, $group, $project
    • $lookup for relational joins
    • Aggregation Pipelines

  • Scaling NoSQL

    • Creating Indexes in MongoDB
    • Replica Sets basics
    • Sharding concepts

  • SQL Data Modeling

    • Normalization vs Denormalization
    • Designing scalable schemas

  • NoSQL Data Modeling

    • Embedding vs Referencing documents
    • Schema design patterns for MongoDB
Database Management (MySQL / MongoDB)

Course Details

  • Duration2 Months
  • LevelIntermediate
  • Price₹15,000
  • Enrolled80+ Students

Skills Covered:

Advanced SQL QueriesMongoDB AggregationDatabase IndexingReplication & ShardingData Modeling
Contact Us

Previous Course

Backend Dev (Node.js / Spring Boot)

Next Course

Cloud Basics (AWS / Azure)