CST 363: Final Learning Journal Entry

 Three Most Important Things Learned this Course: 

1. SQL Querying and Data Manipulation:

Learning how to use SQL to create, query and manage relational databases was the number one thing I learned this course. Writing single-table queries, performing joins, working with subqueries and using view gave me the ability to extract meaningful information from large datasets. I also learned the importance of constraints to maintain data integrity. These were essential skills learned especially since SQL is heavily used in the industry. 

2. Database Design and Normalization: 

Another key takeaway was the importance of ER modeling in designing efficient databases. By learning how to normalize data and reduce redundancy, I understood how good database design not only saves storage but also improves consistency and scalability. The labs on ER diagrams made it clear how theory directly applies to practical database design. 

3. Advance Topics: Indexing, Transactions and Distributed Systems

I learned how databases handle more advance challenges. Indexing and storage strategies showed me how databases can optimized for performance. Studying transactions and concurrency control explained how multiple users can safely work with data at the same time. Exploring distributed databases, replication and MongoDB expanded my perspective beyond traditional relational systems to modern NoSWL approaches, which are critical in today's large-scale application. 

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