Power BI
Turn business data into interactive reports and dashboards with Microsoft Power BI.
Learn SQL to query, manage and analyse data stored in relational databases.
A practical, beginner-to-intermediate SQL course for aspiring data analysts. Work with ShopKart, a realistic Indian e-commerce database, and learn to answer real business questions: retrieve and filter data with SELECT and WHERE, use text, number and date functions, summarise with GROUP BY and HAVING, combine tables with every type of JOIN, and structure complex logic with subqueries, CTEs and set operations. Master window functions for rankings, running totals and month-on-month growth, then design databases with constraints, normalisation, indexes and views. Apply everything in case studies on sales performance, RFM segmentation, cohort retention, operations and HR, prepare for SQL interviews, connect SQL to Excel, Power BI and Python, and learn to use AI assistants safely to write and verify queries. Every section includes runnable examples in the in-browser SQL Lab, hands-on exercises and practice MCQs.
10 chapters, about 45 hours
Lessons and practice for this chapter are on the student portal.
Lessons and practice for this chapter are on the student portal.
Lessons and practice for this chapter are on the student portal.
Lessons and practice for this chapter are on the student portal.
Lessons and practice for this chapter are on the student portal.
Lessons and practice for this chapter are on the student portal.
Lessons and practice for this chapter are on the student portal.
Lessons and practice for this chapter are on the student portal.
Lessons and practice for this chapter are on the student portal.
Lessons and practice for this chapter are on the student portal.
Still have a question? Call or WhatsApp +91 79070 04613, or email support@macsedu.com.