Answers to Duke University's Managing Big Data with MySQL Course (2017) found here.
- Week 1 - ER Diagrams, RS, database concepts
- Week 2 - Select, where, from, order by, limit, operations
- Week 3 - Group by, having, distinct, operators
- Week 3 - Inner Joins, Outer Joins + examples
- Week 4 - Subqueries & more Operators + examples
Note: For Week 3 & 4, I chose to focus more on examples of joins instead of lengthy theoretical explanations of what joins are. Rather than paraphrasing Duke's notes, I focused on listing examples that helped me understand the concepts better.
- MySQL answers for Week 3: Ex 7
- MySQL answers for Week 3: Ex 8
- MySQL answers for Week 4: Ex 9
- MySQL answers for Week 4: Ex 10
Answers to Exercise 1-6 of Week 1 & Week 2 are not included because it's already available online as part of the course.
- Teradata Week 2 answers
- Teradata Week 3 answers
- No Teradata assignment for Week 4, do quiz instead
- Teradata Week 5 FINAL EXAM ANSWERS
MIT.