SQL for Data Analytics & Business Intelligence

মডিউল – ১ : SQL পরিচিতি ও ডেটাবেজ বেসিক

• ডেটাবেজ কী এবং কেন ব্যবহার করা হয়
  
• ডেটাবেজের প্রকারভেদ (OLTP vs OLAP)
  
• SQL কী এবং কেন এটি Data Analytics এ গুরুত্বপূর্ণ
  
• BI ও Data Warehouse এ SQL এর ভূমিকা
  
• টেবিল, রিলেশনশিপ, Primary Key, Foreign Key

মডিউল – ২ : SQL মৌলিক সিনট্যাক্স (Basics of SQL Queries)

• SELECT, FROM, WHERE
  
• ORDER BY, LIMIT
  
• Data Filtering Techniques
  
• Comparisons & Logical Operators
  
• DISTINCT ব্যবহার

মডিউল – ৩ : Data Aggregation & Summary Analytics

• GROUP BY
  
• HAVING
  
• SUM, COUNT, AVG, MIN, MAX
  
• KPI Reporting with Aggregations
  
• Business Metrics তৈরি (DAU, MAU, WAU ,ARPU, Retention, Conversion etc.)

মডিউল – ৪ : SQL Joins for Analysts

• INNER JOIN
  
• LEFT JOIN
  
• RIGHT JOIN
  
• FULL JOIN
  
• CROSS JOIN
  
• BI Use Cases:
  • Orphan customers
    
  • Missing transactions
    
  • Category → Product → Sales mapping

মডিউল – ৫ : Subqueries & Advanced Filtering

• Scalar Subquery
  
• EXISTS / NOT EXISTS
  
• IN / NOT IN
  
• Derived Tables & CTE (WITH clause)
  
• BI Use Case:
  • Top N products by category
    
  • Active vs Inactive users

মডিউল – ৬ : Window Functions for Data Analytics

• ROW_NUMBER, RANK, DENSE_RANK
  
• LAG, LEAD
  
• Moving Averages
  
• Partitioning & Ordering
  
• Period-over-Period Analysis (Month-over-Month, WoW)

মডিউল – ৭ : Time Series & Date Functions

• DATE_PART, DATE_TRUNC
  
• EXTRACT
  
• Time Series Aggregations
  
• Daily, Weekly, Monthly Reporting
  
• Cohort & Retention Analysis

মডিউল – ৮ : Data Cleaning & Transformation with SQL

• CASE WHEN
  
• COALESCE / NULL Handling
  
• String Functions
  
• Data Normalization
  
• ETL–Like Transformations with SQL (Staging → Clean → Final)

মডিউল – ৯ : Business Intelligence SQL (Real Use Cases)

• Sales Analytics SQL
  
• Marketing Funnel SQL
  
• Customer Segmentation SQL
  
• Financial Metrics SQL
  
• Logistic & Inventory SQL
  
• KPI Dashboard SQL Logic

মডিউল – ১০ : Data Warehouse & BI Concepts

• Star Schema, Snowflake
  
• Fact & Dimension Tables
  
• Slowly Changing Dimensions (SCD)
  
• OLAP vs OLTP
  
• BI Tools Integration (Power BI, Tableau, Looker Studio)

মডিউল – ১১ : SQL Performance Optimization

• Index Basics
  
• Query Execution Plan
  
• Why query becomes slow
  
• Optimization checklist

মডিউল – ১২ : 50+ Real-World SQL Problems & Projects

• Industry-level scenarios
  
• Ad-hoc analytics questions
  
• Business case assignments
  
• Mini-capstone: Build an analytics-ready dataset

মডিউল – ১৩ : Final Capstone – BI Dashboard Using SQL

• Prepare dataset using SQL
  
• Export to BI Tool
  
• Build KPI Dashboard (Sales/Finance/Marketing)
  
• Present insights & storytelling