Week 7: Comparing MongoDB and MySQL

 This week I worked on Lab 20 and Lab 21 using MySQL. I practiced creating tables, adding data, and writing SQL queries. I also learned how to use joins to connect tables. At first, it was confusing, but after more practice, it got easier.

Similarities:

  • Both store and manage data.

  • Both handle large data sets.

  • Both work with many applications.

Differences:

  • MySQL: Uses tables.

  • MongoDB: Uses documents.

  • MySQL: Fixed structure.

  • MongoDB: Flexible structure.

  • MySQL: Uses SQL.

  • MongoDB: Uses JSON-style queries.

I would choose MySQL for structured data like school or business records. I would choose MongoDB for flexible or changing data like social media.

This class is almost over, and I only have a few more homework assignments left. I feel proud of how much I learned. At first, SQL was hard, but now I feel more confident. I can apply what I learned to future IT and cybersecurity projects.

Comments

Post a Comment

Popular posts from this blog

Week 2 Learning Journal Post

Image
Part 1: Review and Reflect Learning Strategy My top 3 study skills, in which I believe I am good at, are thinking skills, getting the main idea, and extracting important details. Why do I say this?  Well, I think you develop thinking skills from experience. The article says that everyone has thinking skills, but not everyone uses them correctly. My response to this is that I cannot be scared of dead ends; I have to be scared of not thinking there is no way out. Identifying the main idea from anything is crucial, especially being around a high-paced environment. After 22 years, I believe I have learned to do a decent job when I have to figure out the central idea or concept. Meaning that I can focus on what is more relevant.  This goes hand in hand with extracting important details , good note taking is mentioned, I like to organize ideas on bullet points in a way that I organize what I hear from what I think. I believe I do a good job with that I am weak when it comes t...
Read more

Industry Expert Interview – Exploring Career Paths and Industry Trends

  Interviewee: William Kerney Institution: Clovis Community College  Interviewer: M. Camila Caicedo Date: 3 June 2025 Duration: 30 min Can you tell me about your academic and professional background? Professor Kerney attended UC San Diego and obtained his Bachelor's and Master's degrees in Computer Science from there. As for his professional career, he worked for a defense contractor developing Virtual Reality applications and video games for several years, and then worked in various departments at UC San Diego, utilizing his computer science skills. After graduation, he worked on Virtual Reality educational programs and, after traveling around the country to train teachers on its use, transitioned into full-time teacher education with his own company. He also did a lot of freelance grant writing and computer science consulting. What made you want to pursue a career in computer science? Professor Kerney has always had a passion for technology, and he has known since secon...
Read more

Week 4 Learning Journal

  Part One: Set Your Educational Goals Regarding my educational goals at CSUMB, I aim to earn my Bachelor's degree in Computer Science with a strong GPA. As I mentioned previously, I aspire to specialize in Cybersecurity and, hopefully, attend a reputable university that offers a respected Master’s degree program, such as the University of California, Berkeley. I also want to create projects to add to my GitHub portfolio. I also want to become proficient in languages such as Python, since it is commonly used, specifically in cybersecurity. Additionally, I want to pursue certifications that will help me stand out from others, like CompTIA Security+, to start. Obtaining the Certified Ethical Hacker certification will help me demonstrate my knowledge. I can picture myself obtaining all these certifications, degrees, and knowledge, and also adding my projects to my portfolio. Ultimately, I must stay on top of the constantly changing world to effectively adjust to any changes.  Par...
Read more