Relational Database Basics for Finance

SQL Foundations

Master SQL fundamentals using real financial datasets. Query equity prices, filter trade ledgers, and aggregate portfolio data with SELECT, WHERE, GROUP BY, and JOINs.

8 lessons ~1h total 0 completed+800 XP available

Start Track

Curriculum

👋

Module 1: Getting Started

0/2

Your very first SQL queries - no experience needed.

Your First Query

Beginner4 minSELECTFROM

Counting Rows with COUNT(*) and WHERE

Beginner5 minCOUNT(*)WHERE

🔍

Module 2: SELECT & Filtering

0/1

Query and filter financial data with precision.

SELECT, WHERE and ORDER BY Basics

Beginner8 minSELECTFROM

∑

Module 3: Aggregation

0/1

Summarise portfolio data with GROUP BY.

GROUP BY: Portfolio Summary by Ticker

Beginner10 minGROUP BYCOUNT

🔗

Module 4: JOINs

0/1

Combine price and macro data across tables.

Joining Prices to Trades

Intermediate12 minINNER JOINON clause

🏗️

Module 5: Common Table Expressions

0/1

Structure complex queries with CTEs.

CTEs · Structured SQL

Intermediate14 minCTEWITH clause

🔀

Module 6: Conditional Logic

0/1

Classify trades with CASE WHEN expressions.

CASE WHEN: Conditional Logic in SQL

Intermediate10 minCASE WHENTHEN

🔍

Module 7: Subqueries

0/1

Find above-average stocks with nested queries.

Subqueries: Find Above-Average Stocks

Intermediate12 minsubqueryscalar subquery

Certificate of Completion

Finish all 8 lessons to earn a SQL Foundations certificate you can add to your LinkedIn and CV.

8 lessons remaining

What You'll Be Able To Do

Query any financial database with confidence
Extract KPIs for dashboards & analysis
Impress interviewers with clean SQL

Difficulty Breakdown

beginner4 lessons

intermediate4 lessons