Adaptive Pathway

Same 9 outcomes. Different paths through the graph based on prior knowledge.

Amir

Business major, zero SQL, strong spreadsheets

Full SQL path, accelerated on data concepts

Core concepts remaining169 / 169

Weeks with content8

Week Progress

Week 10%

Week 20%

Week 30%

Week 40%

Week 50%

Week 60%

Week 70%

Week 80%

Week 1

36 concepts to cover

DataInformationDatabaseDBMSRelational ModelTablesRowsColumnsData TypesPrimary KeyForeign KeyComposite KeyRelationshipsOne-to-One RelationshipOne-to-Many RelationshipMany-to-Many RelationshipSchemaConstraintsSQLDDLCREATE TABLEALTER TABLEDROP TABLEDMLINSERTUPDATEDELETESELECTWHEREComparison OperatorsAND / OR / NOTORDER BYDISTINCTLIMITNULL ValuesIS NULL / IS NOT NULL

Week 2

26 concepts to cover

Aggregate FunctionsCOUNTSUMAVGMIN / MAXGROUP BYHAVINGINNER JOINLEFT JOINRIGHT JOINCROSS JOINSelf JoinSubqueriesCorrelated SubqueryEXISTS / NOT EXISTSIN / NOT INBETWEENLIKE / Pattern MatchingCASE StatementCOALESCECommon Table ExpressionWindow FunctionsROW_NUMBERRANK / DENSE_RANKLEAD / LAGPARTITION BY

Week 3

20 concepts to cover

Entity-Relationship ModelER DiagramsEntitiesAttributesEntity RelationshipsCardinalityParticipation ConstraintsWeak EntityEnhanced ER ModelSpecialization / GeneralizationER to Relational MappingData RedundancyFunctional DependencyFirst Normal Form (1NF)Atomic ValuesSecond Normal Form (2NF)Third Normal Form (3NF)BCNFDenormalizationNormalization Trade-offs

Week 4

19 concepts to cover

Python for DataVariables and Data TypesLists and DictionariesFunctionsLoops and ComprehensionsFile I/OJupyter NotebooksGoogle Colabpandas LibrarySeriesDataFrameReading CSVData Selection (loc, iloc)Filtering DataFramesGroupBy in pandasMerge / Join DataFramesData Types and ConversionMissing Data HandlingPandas vs SQL

Week 5

19 concepts to cover

ETL ConceptExtract PhaseCSV Data SourcesDatabase SourcesAPI Data SourcesTransform PhaseData CleaningData StandardizationData ValidationLoad PhaseSQLAlchemycreate_engineDataFrame to SQLSQL to DataFrameError Handling (try-except)LoggingPipeline ArchitectureRetry LogicIdempotent Operations

Week 6

21 concepts to cover

REST APIsHTTP MethodsAPI AuthenticationAPI KeysJSONJSON ObjectsJSON ArraysNested JSONrequests LibraryAPI Data ExtractionNoSQL DatabasesNoSQL MotivationCAP TheoremDocument DatabaseKey-Value StoreMongoDBMongoDB CRUDMongoDB Query LanguageNoSQL vs SQLOAuthRate Limiting

Week 7

16 concepts to cover

Cloud DatabasesAWS RDSDatabase Instance ConfigSecurity GroupsConnection from PythonIndexesB-Tree IndexQuery OptimizationEXPLAIN / Query PlansIndex StrategyAutomated JobsCron JobsAWS LambdaCloud Cost AwarenessConnection PoolingRead Replicas

Week 8

12 concepts to cover

Data QualityAccuracyCompletenessConsistencyTimelinessData GovernanceData PrivacyFERPA / PIIACID PropertiesTransactionsData EthicsData Lineage

Same Outcomes, Different Journeys

Amir

169 / 169 core concepts

Priya

133 / 169 core concepts

21% shorter path

Carlos

107 / 169 core concepts

37% shorter path

All three students must meet identical competency thresholds on all 9 outcomes. The rigor is the same — the route is personalized.