CST-363- Intro to databases. Week 1 Learning Journal

 

1. Relational database tables vs. spreadsheets

At first glance, relational database tables and spreadsheets look alike since both use rows and columns to organize information. However, the key difference is how they handle data relationships and scalability. A spreadsheet is mostly flat — each sheet is independent, and relationships between cells or sheets must be manually set up and maintained. In contrast, relational databases allow you to link tables together using keys, enforce data integrity with rules, and handle large amounts of data more efficiently. Databases also support multiple users accessing and modifying data at the same time, which spreadsheets aren’t designed to handle reliably.

2. Why databases are worth the investment of time

Databases take more effort to install, configure, and learn than just writing to a file, but the benefits are significant. They provide structure through schemas, which helps maintain consistency and prevent errors. They allow powerful querying with SQL, making it possible to search, filter, and analyze data quickly. Databases also support security features, backups, and transaction management — all of which are essential when working with important or sensitive information. Ultimately, the investment in learning databases pays off by making data management more reliable, secure, and scalable compared to simple files.

3. What I want to learn in this course

In this course, I want to gain a solid foundation in designing and working with relational databases. Specifically, I want to learn how to design normalized schemas, write efficient SQL queries, and understand how databases are used in real-world applications. These skills will be valuable in my future career in computer science and cybersecurity, where working with structured data, securing databases, and integrating them with applications are essential. Being comfortable with databases will also make me a stronger candidate for internships and jobs in tech.

Comments

Post a Comment

Popular posts from this blog

Week 2 Learning Journal 5 Parts

  Part 1: Review and Reflect Learning Strategy Top 3 Strengths: Active Listening: I excel at fully concentrating, understanding, and responding thoughtfully during discussions, which enhances my learning and collaboration. Goal Setting: I consistently set clear, achievable goals, which helps me stay focused and motivated throughout my academic journey. Time Management: I effectively allocate my time to balance academic responsibilities, extracurricular activities, and personal commitments. Top 3 Areas for Improvement: Note-Taking Skills: I aim to develop more structured and efficient note-taking methods to better retain and review information. Critical Thinking: I seek to enhance my ability to analyze and evaluate information critically to strengthen my problem-solving skills. Public Speaking: I plan to build confidence and clarity in presenting ideas to groups, which is essential for academic and professional success. Part 2: Preview Time Management Sk...
Read more

Week 4 Journal

 Part One: Set Your Educational Goals My main academic objective at CSU Monterey Bay is to graduate with two full-stack apps designed and delivered, one individually and one jointly. These applications should have continuous deployment pipelines, automated testing suites, and version control. My goal is to obtain two industry-recognized certifications concurrently with my degree program: the CompTIA Security+ certification by December and the AWS Certified Cloud Practitioner by August. In addition to enrolling in a Security+ bootcamp and completing at least 85 percent of the practice tests and AWS modules every two weeks, I'll be keeping a strict timetable to track my progress. I will know I have accomplished this goal when I can confidently demonstrate an application that implements best-practice security measures and allocates cloud resources on AWS without consulting my notes. Part Two: Extended Career Goals To get practical experience and expand my professional network, I w...
Read more

BOOK REPORT EXTRA CREDIT

Book Report: The 21 Irrefutable Laws of Leadership: Follow Them and People Will Follow You by John C. Maxwell John C. Maxwell’s The 21 Irrefutable Laws of Leadership presents a comprehensive framework for understanding and practicing leadership across contexts—from small student organizations to large tech corporations. First published in 1998 and reissued in 2007, Maxwell’s text distills decades of research and experience into 21 guiding “laws” that promise to equip emerging leaders with the insights and habits necessary to inspire trust, drive change, and cultivate followership. As a senior in computer science preparing to transition into industry roles—where technical expertise must be matched by soft skills—Maxwell’s principles offer a structured roadmap for leading teams, managing projects, and influencing stakeholders. Structure and Organization Maxwell organizes the book into 21 chapters, each dedicated to one “law.” Every chapter follows a consistent pattern: Law Statement : ...
Read more