DS Curriculum 4: Databases
Model data, build pipelines and a warehouse, and work with document databases.
Model data, build pipelines and a warehouse, and work with document databases. Free courses, a free self-check for each, and real work confirmed by 3 people. Part of the Varsity Curriculum: Data Science, adapted from OSSU Data Science (CC BY-SA 4.0).
Path outcomes
Model Data for Databases
Database Management Essentials — reuses an outcome Powstik already has.
Take this Challenge →2 milestones
- 1Do the course work in public
- 2Design the database for a real app
Master SQL for Data Analysis
Database Management Essentials — reuses an outcome Powstik already has.
Take this Challenge →4 milestones
- 1Query a real database and answer a question
- 2Write JOIN queries across multiple tables
- 3Aggregate, group, and transform data with CTEs and window functions
- 4Answer a real business question end-to-end
Build a Data Pipeline (Data Integration)
Data Warehouse Concepts, Design, and Data Integration
Take this Challenge →2 milestones
- 1Do the course work in public
- 2Pipe a public dataset into a database
2 milestones
- 1Do the course work in public
- 2Make slow questions fast
Turn Warehouse Data into a Dashboard
Business Intelligence Concepts, Tools, and Applications
Take this Challenge →2 milestones
- 1Do the course work in public
- 2Build a dashboard someone uses
Build a Data Warehouse End to End
Design and Build a Data Warehouse for Business Intelligence Implementation
Take this Challenge →2 milestones
- 1Do the course work in public
- 2Write up your warehouse design
Build with a Document Database (MongoDB)
MongoDB for Developers Learning Path
Take this Challenge →2 milestones
- 1Do the course work in public
- 2Store and query real documents
Resources for this path
No affiliate links. No sponsored placements.
The course map this path is adapted from (CC BY-SA 4.0).