CST 363: Week 8

Briefly summarize what you consider to be the three (3) most important things you learned in this course.

First, I would say it's very important to remember how different joins will affect the result set of a query. I found applying multiple joins to a single query nerving as I was not always confident my result set would turn out the way I intended and would have to tweak my statements at times to get it right. Secondly, I believe it's important to remember how data storage orientation affects the amount of storage we may waste or the amount of time we may add for inserts and updates. Unfortunately, we did not get the opportunity to test these differences out on a scale that significantly displays these effects, so this will need to be something I remember over time until I can simulate and visually see the differences. Lastly, I think it's important to remember how to establish connections to intelliJ (or other IDEs) from MySQL Workbench and MongoDB. I don't want to lose any progress in-between courses that implement databases so I will try and practice in the meantime.