8.1 Briefly describe the three (3) most important things - in your opinion- you learned in this course.
1. SQL & Relational DB: For the first four weeks of the class, I've really grown and learned a lot about relational databases and the SQL language. I've learned how information is stored and retrieved in addition to what SQL does in the background when it does the reading and writing of data into the hard drive. I enjoyed working on the group projects in the beginning of the semester and wished we had more of that in the last 4 weeks because the material got very bland. I've learned how to design a database schema with my group mates using SQL. We designed a database for a drugstore/pharmacy that integrated ER relationships.
2. NoSQL: Learning about Mongo, and other non relational databases was quite interesting. It showed the other side of database storing management. Learning about how servers worked was also interesting.
3. Indexes: Learning about how to optimize query was also interesting. I liked learning about the Query planning of MySQL and how it decides which query is the most costly before doing the query in order to give a faster result. Learning about dense and clustered indexing, B+ trees and hash diagrams were all very interesting.
No comments:
Post a Comment