Month 1: Foundational Database Concepts

Module 1: Introduction to SQL

• What is SQL?
• History and importance of SQL.
• SQL dialects and standards.

Module 2: Retrieving Data

• SELECT statement basics.
• Retrieving data from a single table.
• Aliasing columns and tables.
• Filtering rows with the WHERE clause.

Module 3: Updating Data

• UPDATE statement for modifying existing data.
• Changing multiple rows with a single query.
• Using subqueries in updates.

Month 2: Data Manipulation and Querying Techniques

Module 4: Inserting Data

• INSERT statement for adding new data.
• Inserting data into specific columns.
• Copying data from one table to another.

Module 5: Deleting Data

• DELETE statement for removing data.
• Deleting specific rows based on conditions.
• Truncating a table.

Module 6: Sorting and Filtering Data

• Sorting data with ORDER BY.
• Ascending and descending order.
• Using DISTINCT to filter unique values.

Module 7: Advanced Filtering

• Combining conditions with AND and OR.
• Using parentheses for complex filtering.
• NULL values and IS NULL/IS NOT NULL.

Month 3: Advanced SQL and Practical Applications

Module 8: Grouping Data

• GROUP BY clause for data aggregation.
• Aggregating functions (SUM, COUNT, AVG, MIN, MAX).
• HAVING clause for filtering grouped data.

Module 9: SQL Functions

• Common SQL functions (e.g., CONCAT, UPPER, LOWER, SUBSTRING).
• Mathematical functions (e.g., ROUND, CEIL, FLOOR).
• Date and time functions.

Module 10: Joining Tables

• INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN.
• Self-joins and cross joins.
• Joining multiple tables.

Module 11: Managing Tables

• Creating and altering tables.
• Adding, modifying, and dropping columns.
• Renaming tables.

Final Project

• Objective: Build a fully functional database system for a small business scenario.
• Examples:
• E-commerce product database.
• Employee and payroll management system.
• Inventory and sales tracking for a retail store.
• Evaluation: Presentation and report submission.