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 63035 39491, or email admissions@ledgermint.in.
Free
30 hours
Learn how online search is changing — from traditional SEO fundamentals to AI-driven search — and how to optimise content for both search engines and generative AI answers (Generative Engine Optimization, GEO).
50 hours
Turn business data into interactive reports and dashboards with Microsoft Power BI.
20% off
50 hours
A beginner course that teaches the fundamentals of accounting and how to record day-to-day business transactions in Tally Prime — from company creation and voucher entries to finalising ledger balances and preparing a bank reconciliation statement.