"My Computer Science Degree Journey" by Martin

 In this course, I learned about database design. I initially had some difficulties, but by the end, I understood the relationships and how to implement them in a database diagram. I also learned SQL using MySQL Workbench and how to use it in Java. By the end of the course, I gained an understanding of how to work with NoSQL databases, such as MongoDB, and how to implement them in Java.

In both databases, you can update, insert, delete, and perform query operations. However, MongoDB's query functions are limited compared to SQL. Additionally, MongoDB lacks a join clause for combining collections. Another difference between MongoDB and MySQL is their format: MongoDB uses JSON documents, while MySQL is a relational database. I like the simplicity of MongoDB; it looks easy to work with and handle data. However, I'm not sure if it will be as helpful as MySQL when projects become more complicated. I find that learning about joins in SQL is useful, so the lack of that option in MongoDB makes me question whether it's the best choice for me. Still, I enjoyed working with MongoDB.

 This week focused on programming with databases, specifically using SQL and the Java API (JDBC). I learned how to connect to databases and query data in Java to create applications. I also worked on improving my diagram creation skills and fixing the errors in my Lab 18.

 https://use-the-index-luke.com/sql/anatomy/slow-indexes The author suggests that slow indexes can be caused by the leaf node chain, which may lead to performance issues depending on the number of entries. Additionally, an index range scan can contribute to this slowness when it involves traversing the leaf node chain.

 The things I have learned so far in this course include using SQL Workbench and learning SQL in a way that makes me feel confident querying data. Additionally, I have learned about join queries, creating tables, entities, relationships, attributes, and how to create diagrams. I still have trouble understanding the definitions of normal forms, subqueries, and indexes. My questions are more about their definitions and why they are important.