STEM / applied
Databases for data science · Undergraduate · Data science
Learning objectives from the Databases for data science syllabus, grouped by unit. Click an objective for study materials.
Learning objectives
Click an objective for study materials.
Relational foundations
- Tables, keys, foreign keys, and constraints — Tables, keys, foreign keys, and constraints
- Normalization intuition for analytics schemas — Normalization intuition for analytics schemas
- SQL SELECT, WHERE, ORDER BY, and LIMIT — SQL SELECT, WHERE, ORDER BY, and LIMIT
- Joins: inner, left, anti-join patterns — Joins: inner, left, anti-join patterns
- Aggregations, GROUP BY, and HAVING — Aggregations, GROUP BY, and HAVING
Analytics SQL
- Window functions: ranking, running totals, LAG/LEAD — Window functions: ranking, running totals, LAG/LEAD
- Date/time dimensions and fiscal calendars (intro) — Date/time dimensions and fiscal calendars (intro)
- CASE expressions and conditional aggregation — CASE expressions and conditional aggregation
- Views and materialized views (survey) — Views and materialized views (survey)
- Query plans and basic index awareness — Query plans and basic index awareness
Data platforms survey
- OLTP vs OLAP / warehouse concepts — OLTP vs OLAP / warehouse concepts
- Star schemas: facts and dimensions (intro) — Star schemas: facts and dimensions (intro)
- ETL/ELT into an analytics store — ETL/ELT into an analytics store
- Access control and least privilege for analysts — Access control and least privilege for analysts
- Document vs relational stores for DS (survey) — Document vs relational stores for DS (survey)
What each unit includes
Open a unit below for full materials. Typical resources:
- Study guide
- Exam Strategy
- Common Mistakes
- Worksheets
- Word problems
- Mixed Practice
- Multi-Unit Problems
- Review
- Practice test
- Answer key
Study units
Each unit includes a study guide, worksheets, review, practice test, and answer key. One unit is free; subscribe for the full class.
- Relational foundations
Tables, keys, foreign keys, and constraints
Coming soon - Analytics SQL
Window functions: ranking, running totals, LAG/LEAD
Coming soon - Data platforms survey
OLTP vs OLAP / warehouse concepts
Coming soon
Pricing calculator
Choose materials, tutoring, or both — or book a single session as needed. Customize your plan on the subscribe page.
$1,162 · Databases for data science · 18 tutoring hrs
Study guides, worksheets, reviews, practice tests, and answer keys for 1 class. 18 tutoring hours (1 hr / week · semester). Bundle discount applied vs buying separately. Pay in full via Zelle.