/SQL-Duke

Complete solutions to Duke University's Managing Big Data w SQL Course (2017)

SQL Duke

Answers to Duke University's Managing Big Data with MySQL Course (2017) found here.

Lecture Notes

  • 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 Assignments

  • 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 Assignments

  • Teradata Week 2 answers
  • Teradata Week 3 answers
  • No Teradata assignment for Week 4, do quiz instead
  • Teradata Week 5 FINAL EXAM ANSWERS

License

MIT.