Week 4 learning journal CST 363

Briefly summarize 5 things what you have learned in the course so far.  

  • What a database is, why we use a them instead of spreadsheets
  • Basic SQL terms like table/row/column and how they relate
  • How primary/foreign keys work
  • How to join tables, group data, and use subqueries to answer questions.
  • How to make ER diagrams, turn them into tables, and reduce duplication with normalization.

List at least 3 questions you still have about databases.

  • When is a join better than a subquery, and when is HAVING better than WHERE?
  • How do I know when to stop normalizing (1NF, 2NF, 3NF) for a real project?
  • Which columns should I index first, and how do I check if the index is actually used?

Comments

Post a Comment

Popular posts from this blog

Week 4 Learning Journal

Part 1: My goal is to graduate from the CS program with a strong foundation in software development, cybersecurity, and data systems so I can confidently land a full-time job as a cybersecurity engineer for the Department of Defense or a private defense contractor. I want to be skilled enough to pass security clearances, earn industry certifications like CompTIA Security+ and CISSP, and contribute to building secure, innovative technology that protects people and critical infrastructure. I see myself walking across the stage at graduation, proud of the hard work I've put in, and excited to step into a role where I can grow, learn, and make a real impact. Part 2: My goal is to become a cybersecurity engineer working with the Department of Defense or a top defense contractor like Lockheed Martin, where I can help design and protect mission-critical systems. I want to be part of projects that make a real difference in national security, using my skills to prevent cyber threats and bui...
Read more

Week 2 Learning Journal

Image
 Part 1: After reading the Effective Study Skills paper, I think the top 3 skills I am good at are developing a weekly schedule, making sure to read instructions to properly complete assignments, and ensuring I always have a quiet study space with no distractions. Some of these skills come with trial and error but they have proven to be most beneficial in studying successfully. I think 3 skills I need to work on are organizing my notes when researching, the SQ3R method, and making every hour count. These study skills and methods are important to practice because they will be a big step up in being efficient with studying.  Part 2: Activity log Part 3: Watching the three video presentations provided offered a lot of helpful tools that will boost my knowledge on project management. The first explained the five main phases of project management and the role of a project manager. The second showed how a Work Breakdown Structure (WBS) helps organize tasks into smaller parts for bet...
Read more

Week 7 Learning Journal

Part 1: For our team’s final research video project, we’ve been using Discord to communicate, and it’s worked really well. We chat frequently, ask each other questions, and keep everyone updated on progress. It’s been a smooth way to stay connected and make sure no one feels out of the loop. We’re using Google Slides to build our presentation and OBS Studio to record and edit the final video. So far, the process has been going pretty smoothly, but if I had to improve anything for next time, I’d suggest setting deadlines a little earlier to give ourselves more buffer room. Overall, the collaboration has been solid and productive. Part 2: This week’s materials made me think about how little things can have huge effects. I chose a TED talk on cybersecurity, I realized how something as simple as clicking a link can lead to serious consequences. It was a good reminder to stay alert online. A TED talk I was interested in was by Amy Cuddy. It was on body language and it was really interesting...
Read more