SQL for Data
SQL for Data on AI-ML Companion: Master SQL from basics to advanced queries for data analysis and ML pipelines. 11 interactive modules with live visualizations, quizzes, and hands-on Python coding.
Start free: What is SQL & Relational Databases is fully open to everyone, no account required. The other 10 modules are part of AI-ML Companion Premium; every title and summary is listed below so you can see exactly what the track covers before deciding.
Modules in this track
- What is SQL & Relational Databases (free) - Tables, rows, columns, and why SQL matters for data
- SELECT, WHERE & Filtering (premium) - Pick columns, filter rows, and match patterns
- ORDER BY, LIMIT & DISTINCT (premium) - Sort results, limit output, and remove duplicates
- JOINs - Combining Tables (premium) - INNER, LEFT, RIGHT, and FULL OUTER joins
- GROUP BY & Aggregate Functions (premium) - COUNT, SUM, AVG, MIN, MAX with grouping
- Subqueries & Nested Queries (premium) - Scalar, table, correlated subqueries and EXISTS
- Window Functions (premium) - ROW_NUMBER, RANK, LAG, LEAD, and running totals
- CTEs & Recursive Queries (premium) - Common Table Expressions for readable complex queries
- Tables, Keys & Constraints (premium) - CREATE, ALTER, DROP, primary and foreign keys
- Indexes & Query Performance (premium) - B-tree indexes, EXPLAIN plans, and optimization
- SQL for ML Pipelines (premium) - Feature engineering, data cleaning, and train/test splits in SQL