Model Online / On-Site
Duration
Modules 5 modules

Course Objective & Scope

When business teams have to raise a ticket with the data team for every new report or filter tweak, both decision-making and engineering capacity suffer. This programme teaches relational database concepts and SQL from the ground up so participants can query the data they need directly and accurately.

Filtering, sorting, multi-table joins (INNER, LEFT, FULL JOIN), aggregation, conditional logic (CASE WHEN), and date and string functions are practiced hands-on using PostgreSQL or the organisation's own SQL dialect. Exercises run on a schema modeled after the company's domain, producing a reusable query library for common business metrics.

Who Should Attend?

  • Business and data analysts who want to pull reports and analyses directly from databases
  • Reporting specialists in marketing, finance, product and operations teams
  • Project managers and QA specialists building foundational data querying skills
  • Prerequisite: basic familiarity with spreadsheets and tabular data is sufficient

Key Takeaways

  • Read relational schemas, primary keys and foreign key relationships accurately
  • Filter and sort target datasets using SELECT, WHERE, ORDER BY and LIMIT
  • Join multiple tables with the right JOIN type without causing unintended row fan-out
  • Build summary metrics and segmented reports with GROUP BY and HAVING
  • Handle NULL values, date intervals and CASE WHEN transformations safely

Curriculum

Relational Database Concepts and First Queries
  • Tables, schemas, primary and foreign keys
  • SELECT, DISTINCT, WHERE and logical operators
Aggregation and Grouping Functions
  • Calculating metrics with COUNT, SUM, AVG, MIN/MAX
  • Difference between GROUP BY and HAVING and execution order
Joining Tables
  • INNER, LEFT, RIGHT and FULL OUTER JOIN patterns
  • Preventing row fan-out in one-to-many relationships
Data Transformation, Date and String Functions
  • CASE WHEN, COALESCE and type casting
  • Date arithmetic, period bucketing and string cleaning
Subqueries and Introduction to CTEs
  • Subqueries in WHERE and FROM clauses
  • Writing readable queries with Common Table Expressions (WITH)

Other Courses in This Category

  • Advanced SQL for Analytics and Query Optimization

    Window functions, recursive CTEs, cohort and time-series queries, semi-structured (JSON) processing and query tuning with EXPLAIN ANALYZE, for analysts and engineers working on large datasets.

    Data Science & AI-Ready Data Engineering Corporate
    Live Course
    5 modules
    View
  • AI-Ready Data Engineering

    End-to-end data engineering for RAG, LLM and machine learning systems: data contracts, medallion architecture, feature and embedding pipelines, lineage and metadata management.

    Data Science & AI-Ready Data Engineering Corporate
    Live Course
    5 modules
    View
  • Data Quality Testing and Data Contracts

    Automated data quality testing (dbt, Great Expectations, Soda) and enforceable producer-consumer data contracts to stop silent schema changes and corrupted data from breaking downstream analytics and AI.

    Data Science & AI-Ready Data Engineering Corporate
    Live Course
    5 modules
    View
  • Data Lineage, Catalogs and Data Observability

    Discovering data assets, tracking column-level lineage and catching pipeline delays or distribution drift early using OpenLineage, DataHub/OpenMetadata and data observability practices.

    Data Science & AI-Ready Data Engineering Corporate
    Live Course
    5 modules
    View
  • Unstructured Data Pipelines for Documents, Audio and Images

    Scalable data pipelines that turn PDFs, Office files, scanned documents, call-centre audio and images into parsed, chunked, metadata-enriched and indexed assets for RAG and multimodal AI.

    Data Science & AI-Ready Data Engineering Corporate
    Live Course
    5 modules
    View
  • The Modern Data Stack: dbt, Apache Airflow and Apache Iceberg

    Lakehouse storage on Apache Iceberg, modular tested transformations with dbt and orchestration with Apache Airflow, for engineers building scalable, open-standard data platforms.

    Data Science & AI-Ready Data Engineering Corporate
    Live Course
    5 modules
    View

Get in touch