CST 363 - Week 3 Learning Journal

 1. An SQL view is a virtual table that is created from the result of a query. Similar to a regular table, it can be queried with SELECT statements, and shows data in rows and columns, making it similar to working with actual tables. A view does not physically store any data, it simply displays the data stored in underlying tables. Views also no not have their own primary keys, indexes or constraints. Views can also not be modified with INSERT, UPDATE or DELETE operations. View's main purpose is to simplify complex queries and encapsulate logic. 


2. SQL and Java are very different languages, but do have some similarities. Some examples of similar features are: 

- SQL's WHERE statements serve the same purpose as Java's if statements in controlling conditional logic. 

- SQL's SELECT statements are similar to Java's return statement such that they both specify what values should be produced. 

- Both SQL and Java rely on data types, functions, and expressions to manipulate values

Examples of their differences: 

- SQL is designed to work with stored data using set-based operations.

- SQL has unique capabilities such as joins, aggregate functions and transaction handling. 

- Java process data step by step with loops and control flow.

- Java is object-oriented features like inheritance, encapsulation and polymorphism. 


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