The Database Management Systems course builds a strong foundation in database concepts, SQL programming, and relational data management. It covers core topics such as database architecture, relational models, and querying techniques from basic SQL operations to advanced data extraction, aggregation, and transformation. The course also emphasizes database design principles including entity-relationship modeling, normalization, and schema design, along with advanced querying through joins, views, and subqueries. Through hands-on exercises, learners gain practical skills to design efficient databases and write optimized SQL queries for real-world applications

Intended audience

̌̌̌Database Administrator (DBA), SQL Developer, Backend Developer, Data Engineer, Database Engineer, Data Analyst, Business Intelligence Developer, ETL Developer, Full Stack Developer, Cloud Database Engineer

Prerequisites

Open for all

Assessment & certification

Assessment fee: Included — no extra fee
Assessment mode: Online
Assessment type: MCQ, Coding Practices
Assessment provider: NxtWave Disruptive Technologies Private Limited
Certificate provider: SWAYAM Plus and NxtWave Disruptive Technologies Private Limited

NCrF level: 4.5 (NCrF credit-eligible)

Syllabus

Week 1: Module 1: Introduction to Database
Week 2: Module 2: Introduction To SQL
Week 3: Module 3: Querying with SQL
Week 4: Module 4: Querying with SQL - 2
Week 5: Module 5: Aggregations and Group By
Week 6: Module 6: Group By with Having
Week 7: Module 7: SQL Expressions and Functions
Week 8: Module 8: SQL Case Clause and Set Operations "
Week 9: Module 9: Modelling Databases
Week 10: Module 10: Joins
Week 11: Module 11: Querying with Joins
Week 12: Module 12: Views and Subqueries
Week 13: Module 13: SQL Course Quiz
Week 14: Tools & Technologies Covered: SQL (Structured Query Language), SQLite, Relational Database Management Systems (RDBMS), Database Modeling and Design Tools, ER Diagrams, Normalization Techniques.