Phase 1: Beginner Level (Days 1–5 | 10 Hours)
Day 1: Introduction to Databases & SQL (2 Hours)
- What is SQL? Why use databases?
- Relational vs non-relational databases
- Installing SQL tools, connecting to a database
- Basic SELECT queries
- Mini task: retrieve employee records
Day 2: Filtering & Sorting Data (2 Hours)
- WHERE clause, comparison operators
- Logical operators: AND, OR, NOT
- ORDER BY, LIMIT
- Mini task: filter top-selling products
Day 3: Working with Columns & Expressions (2 Hours)
- Aliases, arithmetic operations
- String functions: CONCAT, LENGTH, SUBSTRING
- Date functions: NOW, DATEPART, DATEDIFF
- Mini task: format customer contact list
Day 4: Aggregation & Grouping (2 Hours)
- COUNT, SUM, AVG, MIN, MAX
- GROUP BY, HAVING
- Mini task: sales summary by region
Day 5: Joins Basics (2 Hours)
- INNER JOIN, LEFT JOIN, RIGHT JOIN
- Joining two tables with keys
- Mini project: employee-department report
- Recap and quiz
Phase 2: Intermediate Level (Days 6–10 | 10 Hours)
Day 6: Multi-table Joins & Aliases (2 Hours)
- Joining 3+ tables
- Table aliases for readability
- Mini task: customer order history
Day 7: Subqueries & Nested SELECTs (2 Hours)
- Subqueries in WHERE, FROM, SELECT
- Correlated subqueries
- Mini task: find customers with above-average orders
Day 8: Data Modification (2 Hours)
- INSERT, UPDATE, DELETE
- Transactions and COMMIT/ROLLBACK
- Mini task: update product prices and log changes
Day 9: Constraints & Table Design (2 Hours)
- PRIMARY KEY, FOREIGN KEY, UNIQUE, NOT NULL
- Creating tables with constraints
- Mini task: design normalized schema
Day 10: Intermediate Project (2 Hours)
- Build a mini database (e.g., bookstore or HR system)
- Populate, query, and summarize data
- Recap and quiz
Phase 3: Advanced Level (Days 11–15 | 10 Hours)
Day 11: Views & Indexing (2 Hours)
- Creating and querying views
- Indexes: purpose and performance
- Mini task: create reusable views for reporting
Day 12: Stored Procedures & Functions (2 Hours)
- Creating stored procedures
- User-defined functions
- Mini task: procedure for monthly sales report
Day 13: Advanced Joins & Set Operations (2 Hours)
- FULL OUTER JOIN, CROSS JOIN
- UNION, INTERSECT, EXCEPT
- Mini task: compare customer lists across regions
Day 14: Optimization & Performance (2 Hours)
- Query optimization techniques
- EXPLAIN plans, indexing strategy
- Mini task: optimize slow queries
Day 15: Final Capstone Project & Wrap-up (2 Hours)
- Full database design + reporting dashboard
- Advanced queries, views, procedures
- Final quiz, certification roadmap, career guidance
Reviews
There are no reviews yet.