Languages · Learning guide

SQL

Asked for in 28 job posts at 16 companies across Canada, and 1 people here are learning it.

No job posts in Columbus yet, so we're showing all of Canada.

Demand over time

Job posts asking for SQL, by week, last 16 weeks

in the last 4 weeks · 8 the 4 before

Job posts asking for this skill, by week
Week of	Job posts
Jul 20	1
Jul 27	0
Aug 3	1
Aug 10	1
Aug 17	2
Aug 24	0
Aug 31	0
Sep 7	0
Sep 14	3
Sep 21	0
Sep 28	3
Oct 5	2
Oct 12	3
Oct 19	2
Oct 26	0
Nov 2	5

Who's hiring

Companies with posts that ask for it

LLightspeed5
CCohere3
WWealthsimple3
11Password3
CClutch2
HHopper2
ddatabricks1

Newest job posts

Learn next

Asked for in the same posts

Python Tableau Looker AWS Airflow R dbt BigQuery

Impact projects

Real problems in Canada, from public data. Build something that helps, and prove SQL while you do it.

AI-suggestedUN SDG 11

Average asking rent for a 2-bedroom apartment, Calgary (quarterly, dollars per month) shifted from 1700 in 2022 Q3 to 1890 in 2026 Q2, burdening tenants searching for housing in Calgary.

Average asking rent for a 2-bedroom apartment, Calgary (quarterly, dollars per month)

Average asking rent for a 2-bedroom apartment, Calgary (quarterly, dollars per month)
Period	Value
2022 Q3	$1,700
2022 Q4	$1,760
2023 Q1	$1,790
2023 Q2	$1,840
2023 Q3	$2,010
2023 Q4	$2,130
2024 Q1	$2,090
2024 Q2	$2,150
2024 Q3	$2,050
2024 Q4	$1,950
2025 Q1	$1,920
2025 Q2	$2,020
2025 Q3	$2,010
2025 Q4	$1,930
2026 Q1	$1,900
2026 Q2	$1,890

What to build: Create a SQL database and query dashboard for housing advocates to analyze quarterly rental price trends.
How it practises SQL: Practice writing complex SQL queries with window functions and aggregations to analyze time-series housing data.
Proof to submit: Submit a public GitHub repository containing the database schema, SQL migration scripts, and query documentation.

Data: Statistics Canada table 46-10-0092-01

AI-suggestedUN SDG 13

Greenhouse gas emissions from industries and households, Alberta (yearly, kilotonnes of CO2 equivalent) shifted from 265130 in 2009 to 271415 in 2023, impacting environmental policy planners in Alberta.

Greenhouse gas emissions from industries and households, Alberta (yearly, kilotonnes of CO2 equivalent)

Greenhouse gas emissions from industries and households, Alberta (yearly, kilotonnes of CO2 equivalent)
Period	Value
2009	265,130 kilotonnes
2010	273,996 kilotonnes
2011	285,154 kilotonnes
2012	290,700 kilotonnes
2013	300,770 kilotonnes
2014	303,757 kilotonnes
2015	295,870 kilotonnes
2016	278,406 kilotonnes
2017	291,330 kilotonnes
2018	291,567 kilotonnes
2019	292,346 kilotonnes
2020	271,006 kilotonnes
2021	275,547 kilotonnes
2022	273,636 kilotonnes
2023	271,415 kilotonnes

What to build: Build a relational database and reporting queries to help environmental nonprofits track industrial emissions.
How it practises SQL: Practice writing advanced SQL joins, grouping sets, and performance tuning for large environmental datasets.
Proof to submit: Submit a public GitHub repository with the database dump, schema creation scripts, and analysis queries.

Data: Statistics Canada table 38-10-0097-01

Best resources

Free, and hand-picked. Start with the first one.

Projects to prove it AI-suggested

B2B SaaS Churn Risk Attribution Model
An analytics database model that aggregates user product events and subscription lifecycle telemetry into customer health scores. It empowers customer success teams to pinpoint accounts at risk of non-renewal.
E-Commerce Marketing Channel Attribution Mart
An analytics pipeline converting multichannel digital advertising clicks and shopping cart sessions into unified conversion funnels. It helps digital marketing leads evaluate return on ad spend across campaigns.
Public Transit Reliability Analytics Suite
A warehouse transformation schema that ingests public transit arrival events to identify bottlenecks and chronic route delays. It assists urban planners in presenting operational performance reviews to municipal transit boards.