DBMS and SQL Curriculum (30 Hours)

Module 1: Introduction to Databases and DBMS (3 hours)

  • Topics Covered:
    • Overview of Databases and Database Management Systems (DBMS)
    • Types of Databases (Relational, NoSQL, etc.)
    • Database Models and Architecture
    • Installing and Setting Up SQL Databases (MySQL/PostgreSQL)

Module 2: SQL Basics (4 hours)

  • Topics Covered:
    • Introduction to SQL
    • Basic SQL Commands: SELECT, FROM, WHERE
    • Filtering Data with WHERE Clause
    • Sorting Data with ORDER BY
    • Using DISTINCT to Remove Duplicates

Module 3: Advanced SQL Queries (4 hours)

  • Topics Covered:
    • Aggregate Functions: COUNT, SUM, AVG, MIN, MAX
    • GROUP BY and HAVING Clauses
    • Joining Tables: INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN
    • Subqueries and Nested Queries

Module 4: Database Design and Normalization (4 hours)

  • Topics Covered:
    • Principles of Database Design
    • Entity-Relationship (ER) Modeling
    • Normalization: 1NF, 2NF, 3NF
    • Designing and Creating Tables

Module 5: SQL Data Manipulation (4 hours)

  • Topics Covered:
    • Inserting Data: INSERT INTO
    • Updating Data: UPDATE
    • Deleting Data: DELETE
    • Transactions and ACID Properties

Module 6: Advanced SQL Features (4 hours)

  • Topics Covered:
    • Views: Creating and Managing Views
    • Stored Procedures and Functions
    • Triggers and Event Handling
    • Indexes and Performance Optimization

Module 7: Database Administration (4 hours)

  • Topics Covered:
    • User Management and Permissions
    • Backup and Restore Techniques
    • Monitoring and Maintaining Databases
    • Security Best Practices

Module 8: NoSQL Databases (3 hours)

  • Topics Covered:
    • Introduction to NoSQL Databases
    • Key-Value Stores, Document Stores, Column-Family Stores, Graph Databases
    • Comparing SQL and NoSQL
    • Introduction to MongoDB

Capstone Project 1: E-commerce Database Design (2 hours)

  • Objective:
    • Design and implement an E-commerce database.
    • Create tables and define relationships.
    • Populate the database with sample data.
  • Skills Applied:
    • Database Design and Normalization
    • SQL Queries and Data Manipulation

Capstone Project 2: Sales Data Analysis (2 hours)

  • Objective:
    • Analyze sales data to derive insights.
    • Write complex SQL queries to extract and aggregate data.
    • Create views and stored procedures for analysis.
  • Skills Applied:
    • Advanced SQL Queries
    • Data Analysis and Reporting