Back

DBMS Roadmap - Beginner

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

1

Introduction to Databases

1 week
  • ▹What is a Database?
  • ▹DBMS vs RDBMS
  • ▹Types of Databases (Hierarchical, Network, Relational, NoSQL)
  • ▹Advantages of DBMS
  • ▹Popular DBMS Tools (MySQL, PostgreSQL, MongoDB, Oracle, SQL Server)
2

Basic SQL

2 weeks
  • ▹SQL Syntax & Commands
  • ▹CREATE, DROP, ALTER statements
  • ▹INSERT, UPDATE, DELETE
  • ▹SELECT & WHERE Clauses
  • ▹ORDER BY, LIMIT
  • ▹Mini-Project: Student Record Management
3

Relational Model

2 weeks
  • ▹Relations, Tuples, Attributes
  • ▹Keys (Primary, Foreign, Candidate, Composite)
  • ▹Constraints (NOT NULL, UNIQUE, CHECK, DEFAULT)
  • ▹Entity-Relationship (E-R) Diagrams
  • ▹Mini-Project: Library Database Schema
GeekDost - Roadmaps & Snippets for Developers