Back

DBMS Roadmap - Advanced

Follow this step-by-step roadmap to master dbms at Advanced level

1

Distributed Databases

3 weeks
  • ▹Centralized vs Distributed DB
  • ▹Data Fragmentation, Replication, Allocation
  • ▹Distributed Query Processing
  • ▹CAP Theorem
  • ▹Mini-Project: Distributed Student Database
2

NoSQL Databases

3 weeks
  • ▹Types of NoSQL (Document, Key-Value, Column, Graph)
  • ▹MongoDB Basics
  • ▹Cassandra Basics
  • ▹When to Use SQL vs NoSQL
  • ▹Mini-Project: Blog Platform with MongoDB
3

Big Data & New Trends

4 weeks
  • ▹Introduction to Big Data
  • ▹Hadoop & HDFS
  • ▹Spark SQL
  • ▹Cloud Databases (AWS RDS, Google BigQuery, Azure CosmosDB)
  • ▹Mini-Project: Analytics Dashboard with BigQuery
4

DBMS Security

2 weeks
  • ▹Authentication & Authorization
  • ▹Encryption (At-Rest & In-Transit)
  • ▹SQL Injection Prevention
  • ▹Backup & Recovery
  • ▹Audit Trails
  • ▹Mini-Project: Secure E-commerce Database
GeekDost - Roadmaps & Snippets for Developers