Course Title: Beginner SQL for Data Management

📅 Duration: 4 Weeks (Twice a Week)
🖥 Format: Online Live Sessions + Hands-on Assignments

Week 1: Introduction to SQL & Database Basics

📌 Session 1:

• Introduction to Databases & SQL

• Understanding Relational Databases

• Setting Up a Database (MySQL/PostgreSQL)

• Exploring SQL Interfaces (MySQL Workbench, pgAdmin)

• Mini Project: Setting Up a Sample Database

📌 Session 2:

• Writing Basic SQL Queries (SELECT, FROM, WHERE)

• Using Comparison and Logical Operators

• Sorting Data with ORDER BY

• Mini Project: Simple Data Retrieval Queries

Week 2: Data Filtering, Aggregation & Joins

📌 Session 3:

• Filtering Data with LIKE, IN, BETWEEN

• Aggregating Data with COUNT, SUM, AVG, MAX, MIN

• Grouping Data with GROUP BY and Filtering with HAVING

• Mini Project: Sales Report Generation

📌 Session 4:

• Understanding Table Relationships

• Working with INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN

• Combining Queries with UNION and UNION ALL

• Mini Project: Combining Data from Multiple Tables

Week 3: Data Manipulation & Subqueries

📌 Session 5:

• Inserting Data (INSERT INTO)

• Updating and Deleting Records (UPDATE, DELETE)

• Using Transactions (COMMIT, ROLLBACK) for Data Integrity

• Mini Project: Inventory Management System

📌 Session 6:

• Understanding Subqueries (SELECT inside SELECT)

• Using Correlated Subqueries for Advanced Filtering

• Nested Queries for Complex Data Analysis

• Mini Project: Customer Order Analysis

Week 4: Database Design, Security & Final Project

📌 Session 7:

• Introduction to Database Design & Normalization

• Understanding Primary Keys, Foreign Keys & Indexes

• Basic Security Best Practices (GRANT, REVOKE, User Permissions)

• Mini Project: Designing a Simple Database Schema

📌 Session 8:

• Final Project Implementation & Query Optimization Basics

• Review of Best Practices for Writing Efficient SQL

• Final Project Showcase & Code Review

• Next Steps: Advanced SQL, Data Analysis, or Backend Development