Standard syllabus
Databases for data science · Undergraduate · Data science
Topics
Relational foundations
- Tables, keys, foreign keys, and constraints
- Normalization intuition for analytics schemas
- SQL SELECT, WHERE, ORDER BY, and LIMIT
- Joins: inner, left, anti-join patterns
- Aggregations, GROUP BY, and HAVING
- Subqueries and common table expressions (CTEs)
Analytics SQL
- Window functions: ranking, running totals, LAG/LEAD
- Date/time dimensions and fiscal calendars (intro)
- CASE expressions and conditional aggregation
- Views and materialized views (survey)
- Query plans and basic index awareness
- Avoiding fan-out mistakes in joins
Data platforms survey
- OLTP vs OLAP / warehouse concepts
- Star schemas: facts and dimensions (intro)
- ETL/ELT into an analytics store
- Access control and least privilege for analysts
- Document vs relational stores for DS (survey)
- Connecting notebooks to databases safely
Pricing calculator
Choose materials, tutoring, or both — or book a single session as needed. Customize your plan on the subscribe page.
Estimates use 15-minute steps (15 minutes to 4 hours). The invoice is based on actual Zoom time (online) or actual session time (in-person), rounded to the nearest 15 minutes. No subscription required.
$60.00 · 60 min · Undergraduate · Online ($60/hr)
New families get started; confirmed families can book tutoring.