Week 8

 Week 8 (6/19-6/20)

Last week for Intro to Database Systems, what?😧

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

1. Queries, especially joins, how to merge data from different tables and subselect. As well as learning how to perform CRUD operations, including select, insert, update, and delete.

2. Reverse and forward engineering, being able to generate an ER diagram based on a database, or creating an ER diagram and generating the database are such great features. After I learned this, I saved so much time, especially in a test. I used to design ER diagrams or wireframes on Lucidchart, which is not as efficient after using this MySQL feature

3. The JDBC API to create a webapp is probably the most useful real-world project, because we get to use Spring boot (open-source framework), mySQL and MongoDB to create a web app. I did something similar before using SQLite and Tomcat but Spring was more compact to use. I also love how we use the same lab to compare the functionality of MySQL and MongoDB and were able to see the differences (pros and cons).