Week 4: What I Learned and More Questions

1.  I have learned how to use MySQL Workbench. We've learned how to create and modify tables and create queries using SQL
2. I have learned about Index Visualization in Lab 9. I got to see how indexes change as data is inserted into a Tree
3. I have learned how Databases and Memory in types of are correlated. It is important to understand how to use data most efficiently for speed, capacity, and cost.
4. We learned how to join tables created in MySQL Workbench. These are used if we are wanting to find all students that have specific majors that were enrolled in a specific semester
5. This week we learned Database design. We got to understand how to create our own ER diagrams and modify them depending on the relationship between entities.

Questions about Databases:

1. When we receive a prompt to write a query that requires a join, I normally write "join" as opposed to left or right join and then modify as I see fit. For exams, how can I practice using right/left joins?
2. I struggle with the Java portion of the class. Are there resources that I can use to have a better understanding of how to use databases work using Java? I assume that a future project is going to require it.
3. In what situation would normalization be better instead of using a select query to search through a whole table? I imagine that separating the data creates more work and time.