Data Science · Level 2

SQL for Data Professionals

By SRTR Academy Faculty

4 modules · 16 lessons · 8 videos · 10 hrs

Queries, joins, subqueries, window functions, database design, PostgreSQL hands-on

What you will learn

Module 1: SQL Fundamentals
- 🎬 Relational databases and SQL basics — free preview
- 📄 SELECT, WHERE, ORDER BY, LIMIT
- 🎬 Aggregate functions: COUNT, SUM, AVG, GROUP BY
- 📄 Filtering with HAVING and CASE
Module 2: Joins & Subqueries
- 🎬 INNER, LEFT, RIGHT, FULL OUTER joins — free preview
- 📄 Self-joins and cross joins
- 🎬 Subqueries: scalar, correlated, EXISTS
- 📄 Common Table Expressions (CTEs)
Module 3: Advanced SQL
- 🎬 Window functions: ROW_NUMBER, RANK, LAG, LEAD — free preview
- 📄 PARTITION BY and running totals
- 🎬 PostgreSQL-specific features (JSONB, arrays)
- 📄 Query performance and EXPLAIN ANALYZE
Module 4: Database Design
- 🎬 Normalization (1NF through 3NF) — free preview
- 📄 Primary keys, foreign keys, indexes
- 🎬 Schema design for analytics
- 📄 Hands-on: designing a real-world schema