Live Complete SQL Course (Beginner to Advanced)

 

Format: Live online sessions with hands-on SQL practice, mini-projects, and capstone exercises by industry professionals

Audience: Beginners with no prior knowledge ,basic computer knowledge

Tools Required: MySQL Workbench / PostgreSQL / SQL Server / SQLite (any one), sample database (e.g., Sakila or Northwind), need laptop with an internet connection

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

Here you can see Important Links:-

Cv And Cover Letter Template

Graduate Resume Format

Favorite Resume For Jobs