Advanced MySQL Projects, M265, Fall 2022

Course Syllabus: https://www.mat.ucsb.edu/~g.legrady/academic/courses/22f265/22f265.html

Student Forum Works Access: https://w2.mat.ucsb.edu/forum/viewforum.php?f=87

Searching a database can involve exploring any of the following:

1) Search for content performance of a data

2) Search for correlation between various data

3) Study the classification structure

4) Discover patterns

5) System errors

6) Outlier data

Single longest and shortest borrow time | Queries (Shaokang)

Books about war (Brianna)

Vinyls & Stephen King (Natalia)

HotSpot & Fees (Shaokang)

Compare 2012 & 2022 (Brianna)

Seasonal trends (Ilia)

Patterns (Natalia)

Legacy storage (Shaokang)

Frequency pattern | queries (Brianna)

Seasonal trends II (Ilia)

Discography (Shaokang)

Aggregate | MySQL Tutorial (Brianna)

String functions | MySQL Tutorial (Ilia)

Data / Time (Natalia)

Palindrome, BIT XOR (Shaokang)

Outliers rock CDs horror DVDs (Brianna)

Outliers incorrect classifications (Ilia)

Outliers pandemic (Natalia)

Outliers popularity (Shaokang)

Random sampling Checkins/outs (Brianna)

Sampling (Ilia)

Random sampling blind (Natalia)

Patterns in random sampling (Shaokang)

Linear regression (Ilia)

Prediction (Natalia)

Clustering dimensionality reduction (Shaokang)