Data + Foundation
Track
A nine-module deep dive into the SQL that powers production FinTech platforms. You'll work directly against a 240,000-row B2B dataset — querying transactions, mapping spend controls, and engineering audit-ready reports the way analysts at Brex and Ramp do every day.
Curriculum Details
Introduction to the Data Lab
Welcome to the AI-Augmented era. Learn the semantic gap in AI-generated SQL and set up your 240,000-row B2B simulation environment.
Identity & Relational Structures
Understand rows, columns, and the network of connected entities. Mastering Primary and Foreign Keys in complex B2B ecosystems like Brex or Ramp.
Precision Data Extraction
The bread and butter of data analysis. Master SELECT, complex WHERE filtering, and organizing high-volume transaction sets for audit-ready reports.
Aggregation & Financial Metrics
Summarizing thousands of rows into actionable metrics. Using GROUP BY and HAVING to identify merchant volume and monitor average fraud latency.
Relational Joins & Data Merging
Connecting the dots across normalized tables. Learn INNER, LEFT, and FULL joins to map employees to corporate cards and multi-rail transactions.
Data Cleaning & Transformation
Handling messy raw data with CASE statements and COALESCE. Categorizing market segments and managing missing compliance or risk scores.
Advanced Analytics & Window Functions
Solving high-level business problems with CTEs and Window Functions. Calculating 7-day rolling spend and detecting 'low and slow' fraud patterns.
Specialized Operations
Mastering string operations, advanced date math (Intervals), and JSONB extraction for modern API-driven financial platforms.
Risk Strategy & Capstone Projects
Transition from queries to business solutions. Perform full-pipeline fraud audits and measure onboarding efficiency using Precision and Recall metrics.
Course Info
Duration
9 Professional Modules
Database
240k-Row B2B Simulation
Cohorts
Cohorts of 20
Best For
- 01Students building data fluency for an early fintech career.
- 02Career switchers who need theory and reps in one place.
- 03Non-technical pros done waiting on engineering for answers.
Prerequisites
No prior SQL experience required. Comfort with finance spreadsheets (Excel or Google Sheets) is recommended.