Learning Journal Week 3 - CST363-30_2253

 Flavio Cervantes

05/18/2025

CST 363

Professor Das


  1. What is an SQL view.  How is it similar to a table? In what ways is it different (think about primary keys,  insert, update, delete operations) ?

A SQL view is different to tables because views are stored virtually while tables are static values unless modified. This affects the performance of the two, tables are more efficient compared to views because they don’t rely on tables and fetch within them to gather a result.  

Regarding the similarities, one is able to setup security permissions on both tables and views. This is important because one might not want another user to edit or delete their configuration without the proper permissions intact. Both tables and view are able to be used in sub queries, %JOINS and responds to the respective query.  Regarding INSERT, UPDATE, and DELETE they can both be utilized in this manner in the same query in a complex sub query or can be used individually in their own query.  

2. What features are similar? 

SQL compares to other programming languages such as Java by having inner loops that must meet certain conditions (Integers) used as values that once reached, exits out of the loop. 

Another similarity is that both support values that modify that data accordingly. In SQL: SELECT, DELETE, INSERT, AS data in a database. 

In Java we utilize such as setters, getters, append, delete, to perform certain functions in ArrayList, Arrays, Tuples, Maps, lists that also store data and can modified accordingly.

3. Which are present in one language but not in the other? 

- The main principles that is present in SQL but not JAVA, is that SQL is a specialized language strictly developed for managing relational databases and queries. 

- Java is a language that development is focuses around object-oriented design, with this we are able create apps for desktops, phones, web site design. As far as syntax, SQL is simpler since it is developed around relational features. On the other hand, Java can be used with inheritances, polymorphism in an object-oriented approach. 

They also both have their own specialties, if one is working with properly structured or relational data, complex query based, bulk modification on data, and efficient stability then go with SQL. If one needs to build a mobile app from start to finish, then Java is the recommended approach due to the ability to work with separate classes, xml, config files, main activity, sub modules and activities within the application. 





Comments

Post a Comment

Popular posts from this blog

Learning Journal - CSUMB - January 6, 2025

 Greetings,     This week I learned about the campus of CSUMB, and how it was a military base before officially becoming a CSU in the mid 90's. The vision of our school is based on collaboration, teaching us skills that are essential for the modern workforce, and to provide the best possible curriculum with relevant technologies that will help us excel in our future, if we do our part and endeavor the challenges that Computer Science conveys. I also learned about the different ways to format APA style, depending if it is a website, book, or personal interview. At my previous schools, we would utilize MLA, so this is a great learning experience.  I also refreshed on the importance of plagiarism, and why it is extremely important to do on our work, even with all the tools we have such as AI, 3rd party websites, etc. The challenge I overcame this week was to have a deeper understanding of how Dynatrace operates, and all the different components that shape a successf...
Read more

Learning Journal - Week IV

     Educational Goals My education goals in the CS program are to strengthen my engineering foundational skills. I also want to strengthen my programming skills by expanding my knowledge in python and Unix. I am working on obtaining a stronger understanding in machine learning, artificial intelligence and software engineering. This will be accomplished by working on small scale assignments or projects that introduce me into these respective technologies.  Career Goals My career goal is to continue to promote within the company I am currently working at or to move to another company and take on a more challenging engineer related role such as an Architect III or  Software Engineer. Wild guess of your percentile of the ETS Computer Science test After viewing the ETS page, test description and sample test I feel that this test will challenge me greatly but is a great standard as a computer science major. The percentile that I feel I will obtain is arou...
Read more

Learning Journal - CSUMB - January 15, 2025

Image
      Lecture: Week 2 Learning Journal Post      Part 1: Review and Reflect Learning Strategy       The tops three areas that I am good at is to stick to my schedule, unless an emergency comes up, I like to stick to my schedule from the beginning of the day, until the end of the day. I am also good at studying when I have "planned" for it, I usually plan my studies in the evening and over my online educational journey, I have been disciplined enough to stay on track. Lastly, I am good at thinking skills, I can think critically, and come up with ideas or a desire to research something and learn about it. This ability is used in our everyday life’s, at home, while studying, and at work.  The top three areas that I feel I am weak in is where to study, sometimes it is easier to study at home but that is where I can easily get distracted at. I also feel that I am weak in is reading, sometimes when I am tired, it is hard to read all the m...
Read more