Technology

SQL Query Optimization & Database Performance

Make slow queries fast: indexing strategies, execution plans and schema design for high-performance databases.

4.7★★★★★(149 reviews) 760 learners 14 modules · 113 lessons · 2,100 min Advanced English

Created by Sanjay Gupta, Analytics Manager

What you'll learn

  • Diagnosing slow queries
  • Designing effective indexes
  • Writing efficient SQL
  • Tuning database performance

Course curriculum

14 modules · 113 lessons · 2,100 min

Planned outline shown above (sample metadata). The detailed module and lesson list for this course hasn't been published yet.

Description

Make slow queries fast: indexing strategies, execution plans and schema design for high-performance databases.

What this course covers: reading execution plans, B-tree, composite and partial indexes, rewriting joins and subqueries, window functions for analytics, normalisation versus denormalisation and monitoring and tuning PostgreSQL and MySQL.

Skills you will build: diagnosing slow queries, designing effective indexes, writing efficient SQL and tuning database performance.

Practical applications: business reporting and KPIs, forecasting and trend analysis and data-driven product and marketing decisions.

Who should take this course: developers, data analysts and DBAs who work with large relational databases. It is designed for learners with solid experience in data analytics.

Learning outcomes: by the end of the course you should be able to apply reading execution plans and diagnosing slow queries in your own work, and know which areas to practise next.

Requirements

  • Solid working knowledge of data analytics
  • A computer with internet access

Your instructor

SG

Sanjay Gupta

Analytics Manager · 13+ years of experience

Sanjay Gupta is a analytics manager with 13+ years of experience in data analytics. Sanjay teaches data cleaning and preparation and exploratory data analysis with practical, step-by-step examples.

Reviews

  • N
    Nithya V. ★★★★★ 4.5/5 Sample review

    Clear structure from rewriting joins and subqueries through to window functions for analytics. I'd like a few more practice tasks, but overall very useful. The end-to-end case study tied cleaning, analysis and presentation together nicely.

  • T
    Tarun B. ★★★★★ 4.5/5 Sample review

    SQL Query Optimization & Database Performance covered B-tree, composite and partial indexes in more depth than I expected. The pace was right for my level. Finally understood which chart to use when — my reports look far more professional.

  • I
    Ishaan K. ★★★★★ 4.5/5 Sample review

    I joined to get better at diagnosing slow queries. The practical exercises on reading execution plans were exactly what I needed. The SQL practice sets were tough in a good way.

Sample reviews are illustrative demo content, not verified purchases. Ratings from learners will appear here once submitted.

Keep Exploring

More in Technology