← Back to Curriculum

Beginner

Introduction to SQL for Storing and Querying Market Data

A first course in SQL built entirely around Indian market data, for engineering graduates, working coders and traders who want to store and query price history properly instead of wrestling with spreadsheets. Sets up a free local database with SQLite and DB Browser, then teaches SELECT, WHERE, sorting, aggregation and GROUP BY by working directly with NSE and BSE bhavcopy data. Moves on to real schema design, primary keys, and joins across stocks, prices and sector tables, finishing with subqueries and CTEs for the kind of multi-step questions a quant or systematic trader actually asks of their data.

MODULES

4

DURATION

4 Hours

TRACK

Quantitative Finance

Access Level

LEARNER

Start Learning Now →Sign in to resume

Everything included

Full Text Playbooks

Actionable Exercises

Mobile Reading Mode

Lifetime Updates

Curriculum Breakdown

Chapter 1: Why SQL Matters for Market Data

4 Lessons

What a Database Actually Is, and Why Spreadsheets Break Down9 min read

SQL vs Excel vs Python: Picking the Right Tool for Storing Market Data10 min read

Setting Up Your First Database: SQLite and DB Browser10 min read

Your First Query: Loading and Viewing an NSE Bhavcopy9 min read

Chapter 2: Reading Data with SELECT

4 Lessons

The SELECT Statement: Columns, Rows and Basic Syntax9 min read

Filtering Rows with WHERE: Finding Stocks That Match a Condition10 min read

Sorting and Limiting Results: Today's Top Gainers and Losers9 min read

Aggregate Functions: COUNT, SUM, AVG, MIN and MAX on Price Data10 min read

Chapter 3: Designing Tables for Market Data

4 Lessons

Tables, Columns and Data Types: Modelling OHLC Price Data10 min read

Primary Keys and Why Every Table Needs One9 min read

Loading Real NSE and BSE Data into Your Database11 min read

GROUP BY: Aggregating Volume and Returns by Stock or Sector11 min read

Chapter 4: Joining Tables and Writing Real Queries

4 Lessons

Why One Table Is Never Enough: Splitting Stocks, Prices and Sectors9 min read

INNER JOIN: Combining Stock Info with Price History11 min read

LEFT JOIN and Handling Missing Trading Days10 min read

Subqueries and CTEs: Answering Multi-Step Questions in One Query12 min read