Database Management Systems
Every Engine, From First Principles → Production
A rigorous, modern, Bengali-friendly DBMS course for technical students in Bangladesh. Covers the theory of relations, every major SQL engine (PostgreSQL, MySQL, SQLite, SQL Server, Oracle), every NoSQL family (MongoDB, Redis, Cassandra, Neo4j, Elasticsearch), and the new wave — time-series, vector and cloud databases.
🇧🇩 শূন্য থেকে শুরু করে কোর্স শেষে আপনি একজন full-spectrum database engineer হয়ে উঠবেন। Relational theory, SQL, NoSQL, distributed system, এমনকি vector ও time-series database — সবকিছু এক কোর্সে। প্রতিটি SQL কোয়েরি সরাসরি ব্রাউজারে চালিয়ে দেখা যাবে।
-- Find the top CSE student by CGPA (চলো শুরু করি)
SELECT name, dept, cgpa
FROM student
WHERE dept = 'CSE'
ORDER BY cgpa DESC
LIMIT 1;Why This Course Exists (কেন এই কোর্স?)
Most "SQL tutorials" teach syntax. This one teaches how a database actually thinks, how to design schemas that don't rot, and how to reason about query performance. Behind every fast app, every banking system, and every social network — there is a database. Learn it deeply, and you will be valuable forever.
Relational Theory
Sets, predicates, relational algebra — the math behind SQL.
SQL-এর পেছনের গণিত — সেট ও রিলেশনাল অ্যালজেব্রা।
Schema Design
ER modelling, normalization, denormalization trade-offs.
ভালো schema কীভাবে design করতে হয়।
Query Mastery
Joins, subqueries, CTEs, window functions, recursion.
Real-world SQL কোয়েরি দক্ষতার সাথে লেখা।
Production Depth
Indexes, transactions, optimization, recovery.
Production-এ database কীভাবে চালানো হয়।
Every Engine
PostgreSQL, MySQL, MongoDB, Redis, Cassandra, Neo4j, Elasticsearch.
প্রতিটি প্রধান DBMS engine — আলাদা module-এ।
Modern & Cloud
Time-series, vector DBs, DynamoDB, BigQuery, Atlas.
Time-series, vector, cloud DB — সব নতুন ধরনের database।
Prerequisites (যা জানা থাকলেই চলবে)
- Basic computer literacy & high-school math
- Familiarity with at least one programming language helps (not required)
- A modern browser (everything runs in-browser)
- No installation, no account, no setup
By The End You Will (কোর্স শেষে পারবে)
- Design a clean, normalized schema for any real application
- Write any SQL query — joins, CTEs, window functions, recursion
- Reason about indexes, query plans and performance
- Understand transactions, ACID, locking and recovery
- Use PostgreSQL, MySQL, SQLite confidently in production
- Model and query MongoDB, Redis, Cassandra, Neo4j, Elasticsearch
- Pick between time-series, vector and cloud DBs for any workload
- Wire up an ORM and a clean migration pipeline
- Build a real database-backed application end-to-end