Module 1 - Introduction to Analytics & Business Domains
Session 1: Introduction to Data Analytics
Session 2: Types of Analytics
Session 3: Role of a Data Analyst
Session 4: Finance, Retail, Insurance & Accounting Domains
Session 5: KPIs & Business Metrics
Module 2 - Database Design Fundamentals
Session 6: Context Level DFD
Session 7: HLD & LLD Diagrams
Session 8: Entity Relationship Diagrams (ERD)
Session 9: Relationships & Cardinality
Session 10: Relational Schema Design
Module 3 - MySQL Fundamentals
Session 11: DDL Commands (CREATE, ALTER, DROP)
Session 12: Constraints
Session 13: DML Operations (INSERT, UPDATE, DELETE)
Session 14: TCL Commands (COMMIT, ROLLBACK, SAVEPOINT)
Session 15: Database Creation Projects
Module 4 - SQL Querying Basics
Session 16: SELECT, WHERE, ORDER BY
Session 17: DISTINCT, LIMIT, OFFSET
Session 18: String Functions
Session 19: Numeric Functions
Session 20: Date & Conversion Functions
Session 21: Aggregate Functions (COUNT, SUM, AVG, MIN, MAX)
Session 22: GROUP BY & HAVING
Module 5 - SQL Joins & Subqueries
Session 23: INNER, LEFT & RIGHT JOIN
Session 24: FULL OUTER, CROSS & SELF JOIN
Session 25: Single-row & Multi-row Subqueries
Session 26: Correlated Subqueries
Session 27: EXISTS & NOT EXISTS
Module 6 - Advanced SQL & Analytics Functions
Session 28: Window Functions Overview
Session 29: RANK, DENSE_RANK & ROW_NUMBER
Session 30: LAG & LEAD
Session 31: FIRST_VALUE & LAST_VALUE
Session 32: NTILE Function
Module 7 - Data Warehousing & Data Cleaning
Session 33: OLTP vs OLAP
Session 34: ETL Process
Session 35: Star Schema & Snowflake Schema
Session 36: Facts & Dimensions
Session 37: Data Cleaning Techniques
Module 8 - Intermediate SQL Concepts
Session 38: Temporary Tables
Session 39: CTE (Common Table Expressions)
Session 40: Recursive CTE
Session 41: ACID Properties
Session 42: Indexing
Session 43: Views
Module 9 - Database Normalization & PL/SQL
Session 44: Normalization (1NF, 2NF, 3NF, BCNF)
Session 45: PL/SQL Basics
Session 46: Variables & Loops
Session 47: Cursors
Session 48: Procedures & Functions
Session 49: Packages & Exception Handling
Module 10 - Data Pipelines & Ingestion
Session 50: ETL vs ELT
Session 51: Batch & Streaming Pipelines
Session 52: Data Validation
Session 53: Pipeline Architecture
Session 54: Data Quality Concepts
Module 11 - Database Administration & Optimization
Session 55: Triggers
Session 56: Table Partitioning
Session 57: Query Optimization Techniques
Session 58: EXPLAIN Analysis
Session 59: Index Optimization
Module 12 - Cloud Data Warehousing Platforms
Session 60: Snowflake - Architecture & Usage
Session 61: Databricks - Lakehouse Platform
Session 62: Amazon Redshift - Cloud DW
Session 63: Cloud Architecture Concepts
Module 13 - Advanced Databases
Session 64: PostgreSQL Deep Dive
Session 65: Oracle Database
Session 66: MVCC (Multi-Version Concurrency Control)
Session 67: PL/SQL Enterprise Features
Session 68: Database Maintenance & Best Practices
Module 14 - Database Selection & Real-World Projects
Session 69: Database Selection Strategies
Session 70: OLTP vs OLAP - Choosing Right
Session 71: Lakehouse Architecture
Session 72: Real-World Case Studies
Session 73: End-to-End Retail Database Project
