All Events
₹99Session Ended

SQL Mastery — Queries, Joins & Optimisation Live

Write SQL that actually performs: Joins, Subqueries, Window Functions, indexing strategy, and real interview questions solved live.

Sunday, 3 May 2026
05:00 pm · 120 min
238 registered
K

Karthik T

Data Engineer

About This Session

A focused 2-hour live session on SQL — the most tested skill in data roles, backend interviews, and analyst positions alike.

We moved through SELECT fundamentals fast and spent the majority of the session on real complexity: multi-table JOINs, correlated subqueries, CTEs, and window functions like RANK, DENSE_RANK, and LAG. We also covered query optimisation fundamentals — when indexes help, when they hurt, and how to read an EXPLAIN output.

This session is now closed. Join the waitlist for the next SQL workshop.

What We'll Cover

  • 01SELECT, WHERE, GROUP BY, HAVING — the ones interviews actually test
  • 02INNER, LEFT, RIGHT, FULL JOINs with real scenarios
  • 03Subqueries and correlated subqueries
  • 04CTEs (WITH clause) — writing readable complex queries
  • 05Window Functions — ROW_NUMBER, RANK, DENSE_RANK, LAG, LEAD
  • 06Indexing fundamentals and reading EXPLAIN plans
  • 0710 real SQL interview questions solved live

What You'll Walk Away With

  • Write complex SQL queries without hesitation
  • Use window functions for analytical problems
  • Optimise slow queries with proper indexing
  • Crack SQL rounds in data and backend interviews
SQLMySQLData AnalyticsBackendPlacement PrepWindow Functions

Session Ended

₹99

Sunday, 3 May 2026 · 05:00 pm

This session has ended. Check out our upcoming events.

Browse All Events
SQL Mastery — Queries, Joins & Optimisation Live | Amend Academy