Dailysharing TechnologiesDailysharing TechnologiesSkills & Certifications
SQL and Data Modelling for Analysts
Data Analysis Skills

SQL and Data Modelling for Analysts

Query databases with confidence and model data so reports stay consistent as the business grows.

Intermediate4 daysOnline liveRolling intake

Four days covering SQL from the ground up through joins, aggregation, window functions and data modelling. You will work against a realistic reporting database.

Includes how to structure tables and views so dashboards do not contradict each other.

Course modules

  1. 1

    Relational concepts and select statements

  2. 2

    Joins, filtering and aggregation

  3. 3

    Window functions and advanced queries

  4. 4

    Data modelling for reporting

  5. 5

    Performance and query hygiene

What you will be able to do

  • Write joins and aggregations without errors
  • Use window functions for running analysis
  • Model tables for reliable reporting
  • Diagnose slow or duplicated queries

More in Data Analysis Skills

Data Analysis Foundations: Excel to Insight
Data Analysis SkillsFoundation

Data Analysis Foundations: Excel to Insight

Turn messy spreadsheets into clean analysis and clear answers, using the functions professionals actually need.

3 daysOnline liveRolling intake
From £5355View course
Dashboards, Visualisation and Data Storytelling
Data Analysis SkillsAdvanced

Dashboards, Visualisation and Data Storytelling

Design dashboards decision makers use, and turn analysis into recommendations that get acted on.

3 daysHybridRolling intake
From £11250View course