CST 363 - Week 1 Learning Journal

 Relational database tables and spreadsheet have similarities based off their appearance, but have key differences. Spreadsheets are useful for simple tasks such as making lists, tracking deliveries or anything else that does not have much data. When the dataset gets large, spreadsheets get messy and can have errors more easily. Relational database tables are build to handle large datasets. Databases keep data organized across multiple tables and have riles that keep the information accurate. Databases also allow different tables to connect together like linking the list of products a company sells to the price of each product. 

Important reasons that make database useful investment of time are that they are reliable and secure. Multiple users can have access to a database and are able to update, search, report data at the same time. For searching within the database, they support a fast method of finding what one needs. The database can be protected through security. 

In this course, I want to learn the basics of SQL, design tables, queries, database design principles, data connectivity and data cleaning/transforming. These skills will be beneficial in the future for jobs handling data, especially when it comes to managing databases. As wanting to become a Data Engineer I will be using this work on a daily basis. 

Comments

Post a Comment

Popular posts from this blog

CST 349 - Week 4 Learning Journal

 Part One: Set your Educational Goals My primary educational goal in CS program is to develop a string and practical mastery of core CS concepts, including algorithms, programming languages, software engineering, and systems. I envision myself confidently solving algorithmic problems, understanding complex system architectures, and applying discrete mathematics to real-world challenges. I want to graduate with a skill set that allows me to design efficient software solutions, analyze problems from multiple perspectives, and communicate technical ideas clearly. I hope to excel on the capstone projects, future internships and collaborative environments by applying the knowledge I have gained. Beyond the CS program, I plan to continue to learn through a masters program and certificate programs. I also plan to continue learning in emerging areas such as AI, ML, and cybersecurity.  Part Two: Set your Career Goals A mathematical engineer / data engineer job after graduation in Sprin...
Read more

CST349 Week 2 - Learning Journal

Image
Reflecting Learning Strategy:      Top 3  Strengths:           - Keeping notes organized: I have structured my notes in a format that is clear for me and easy to                        understand.           - Time management/awareness: Since working a full time job and being a full time student, I have                   learned to manage my time effectively and in a way that has not hindered my education or work.           - Re-reading and understanding main/key points: I have learned that the most effective way to learn                   for me while reading is summarizing key points/topic/ideas in my own words.       Top 3 Weaknees          - Test-taking: ...
Read more

CST 349 - Week 5 Learning Journal

Part One: Support and Comment on Teammates' Goals https://rrh-cst349.blogspot.com/2025/09/week-4.html?sc=1759766413145#c3682610505999987379 https://annies-cs-journey.blogspot.com/2025/09/week-4-my-csumb-journey.html?sc=1759766670451#c6148798155532794758 Part 2: Possible Capstone Ideas Idea 1: Data Pipeline for Real-Time Analytics on Public Data Description: Build an end-to-end engineering pipeline that ingests, cleans and processes real-time data (ex: stock market, or sports stats). Store the data in a structured format, then build an API for real-time analytics.  Idea 2: Machine Learning-Data Cleaning Assistant Description: Create a tool that detects and corrects anomalies, duplicates or missing values in datasets using both statistical rules and machine learning models. (Ex: applying clusters to detect outliers to fill missing values). Package the tool into a library or web interface.  Idea 3: Graph Analytics Platform for Network Data Description: Build a platform to analyze...
Read more