DBMS370 – Database Management Systems
DBMS370 is a comprehensive, industry-oriented course designed to build a strong foundation in Database Management Systems. This course covers core database concepts, relational models, SQL (from basics to advanced), normalization, indexing, transactions, and real-world database design. Students will learn how modern applications store, manage, and optimize data using MySQL and PostgreSQL, with a strong focus on practical queries and schema design. By the end of the course, learners will be able to design efficient databases and write optimized SQL for real projects and academic success.
Duration
4 Months
Starts
Oct 2
What You'll Learn
After completing this course, students will be able to: Understand how databases work internally Design relational database schemas from real requirements Write efficient SQL queries (basic → advanced) Use joins, subqueries, views, and aggregations confidently Apply normalization and denormalization correctly Implement indexes and improve query performance Handle transactions and concurrency issues Build a complete real-world database project
Course Curriculum
Introduction to Databases & DBMS
Database Architecture & Components
Relational Model & ER Diagrams
Keys, Attributes & Relationships
SQL Basics: SELECT, INSERT, UPDATE, DELETE
Filtering, Sorting & Conditional Logic
Aggregate Functions & GROUP BY
Joins: Inner, Left, Right
Subqueries & Nested Queries
Views & Virtual Tables
Constraints & Data Integrity
Indexes & Query Performance
Normalization (1NF–3NF & BCNF)
Denormalization & Trade-offs
Transactions & ACID Properties
Concurrency Control & Locking
Database Security Basics
Real-World Schema Design
Mini Project Discussion
Final Project Presentation
Course Includes
PDF Notes (Class-wise) Recorded Class Videos Practice SQL Problems Mini Project