Assessments with randomized variants
Assessments with randomized variants

Learning query processing and optimization require a understanding of how the database evaluates query execution plans and select the most optimal one. To help students learn these concepts, we designed assessments with randomized variants to allow students to practice several variants of a questions. Here are some examples. 

Estimating Query Operation Size
QryOpt-SizeEst- CS 411, Fa21 _ PrairieLearn
Query Optimization (Join Ordering)
Qry-Opt-Dynamic-Prog-CS 411, Fa21 _ PrairieLearn