Advance from SQL reporting queries to analytic windows, performance tuning and reusable data marts. 1. Who can join Suitable for: Data analysts, developers and BI practitioners Mandatory prerequisites: Able to write basic SELECT, WHERE, GROUP BY and JOIN queries 2. Duration 36 live hours • Approximately 6 weeks at 6 hours per week; actual timetable to be confirmed. 3. Mode Classroom - Thaiyur / Kelambakkam, OMR Chennai (subject to schedule) Live Online (subject to schedule)
4. Syllabus — five modules
Module 1: SQL Foundations Refresher & Complex Filtering / Grouping Strategies Learning outcome: Write efficient filtering and aggregation queries. Module 2: Advanced JOINs, Subqueries, CTEs & Temporary Tables Learning outcome: Combine datasets using joins, subqueries and CTEs. Module 3: Analytics Power Tools: SQL Window Functions & Aggregations Learning outcome: Calculate running totals, ranks and cohorts with window functions. Module 4: Database Performance Optimization, Query Execution Plans & Indexing Learning outcome: Read execution plans and improve slow sample queries. Module 5: Data Mart Design & Analytical Query Patterns Learning outcome: Design reusable tables or views for analytics questions. 5. Practical project Source capstone title: Write an Enterprise SQL Suite to Analyze E-Commerce User Funnels Student deliverable: A tested SQL query suite calculating e-commerce conversion funnels, repeat purchase measures and customer segments.
6. What is included Live trainer-led sessions Practical assignments Sample code or templates, as applicable Project feedback Learning assessment Perizona course-completion certificate subject to assessment 7. Upcoming batch Start date: To be announced. Students can register interest; dates are shared only after confirmation.
