top of page

Database Management Systems

The Database Track covers both SQL and NoSQL systems in depth. It begins with Fundamentals of MySQL (5 weeks), focusing on SQL operations, joins, indexing, and design principles. This is followed by Database Administration in MySQL (6 weeks), which dives into user management, backups, performance tuning, and security. The track concludes with an 8-week NoSQL course, exploring non-relational databases, MongoDB, JSON data handling, replication, and real-world use cases.

01

Fundamentals of MySQL - 5 weeks

Modules:
​

  1. Introduction to MySQL

  2. SQL Basics: DDL, DML, DCL

  3. Joins, Subqueries, Indexing

  4. Views, Triggers

  5. Basic Database Design Principles

02

Database Administration in MySQL - 6 weeks

Modules:

​

  • Users, Roles, and Permissions

  • Backups, Restores, Migration

  • Performance Tuning

  • Security Practices

  • Monitoring Tools

03

NoSQL - 6 weeks

Modules:

​

  • Introduction to NoSQL Concepts

  • Types of NoSQL Databases

  • MongoDB Fundamentals (CRUD, Aggregation, Indexing)

  • Working with JSON Data

  • CAP Theorem, Replication, Sharding

  • Use Cases and Projects

bottom of page