Week 19 (5/14/2025 - 5/20/2025)

   (Click on READ MORE for better formatting)

    Hi everyone, welcome to my 19th blog! This is the Week 3 post for CST 363 Introduction to Database Systems.

  • 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)
    • Description: The way I like to describe an SQL view is a temporary read-only table. A useful application for views is data aggregation, such as joining multiple tables. 
    • Similarities: Both views and tables can hold data to be read.
    • Differences: Views are read-only. For example, you cannot insert, update, or delete data from a view directly. Views are also not physically stored in the database, they are generated from a create view query,
  • We have completed our study of SQL for this course. This is not to imply that we have studied everything in the language. There are many specialized features such as calculating rolling averages, query of spatial data (data with latitude and longitude) coordinates, and more. But take a minute to think about how SQL compares to other programming languages such as Java. What features are similar, and which are present in one language but not in the other? For example, Java has conditional if statements which are similar to SQL WHERE predicates, the SELECT clause is similar to a RETURN statement in that it specifies what data or expression values are to be returned in the query result (although it is strange that a statement should specify the RETURN as the first part of a SELECT.
    • Similarities: Both languages can be used for basic and even advanced data processing, and both languages even have built-in features out of the box that allows for this. Since SQL is specially designed for data processing, that makes it typically more efficient at data processing related tasks than Java.
    • Differences: In general, SQL and Java are used for different purposes. SQL is fundamentally designed to interact with databases using queries. On the other hand, Java is a traditional programming language that is defined as general-purpose. SQL does not really have classes or objects like Java does.

That is all for this week, see you in my Week 20 post!

Comments

Post a Comment

Popular posts from this blog

Week 32 (8/13/2025 - 8/15/2025)

     (Click on READ MORE for better formatting)      Hi everyone, welcome to my 32nd  blog!  This is the Week 8 post for CST 334 Operating Systems. Write a 1-2 paragraph journal post, of at least 250 words, summarizing what your biggest takeaways from CST334 were, including any major challenges or topics you found particularly interesting. One of the major challenges in this class (at least for me) was wrapping my head around some of the long math-style problems that have been seen throughout the course. Thankfully, I was able to get a lot of practice with these through labs, ungraded practice quizzes, Midterm Preparation Quiz, and Final Exam Preparation Quiz. In addition, members of my team were able to help me better understand what was needed to tackle these problems. For example, Wootark Kim (Tom) made a step by step video for me and the rest of Silicon Surfers that explained how to do CPU scheduling problems featuring the RoundRobin policy. V...
Read more

Weeks 41 - 48 (10/26/2025 - 12/19/2025)

     (Click on READ MORE for better formatting)      Hi everyone, welcome to my 41st-48th  blogs!  This is the Week 1-8 post for CST 336 Internet Programming. Similarly to CST 311 Introduction to Computer Networks, while journal entries were not required  for this particular course, I wanted to document the concepts and assignments from each week of class. If you would like to see some of these projects for yourself, this link acts as a homepage to visiting all of the projects described below! https://bevans34.github.io Week 1: HTML and CSS This week's primary focus was on learning/practicing creating a website using H yper T ext M arkup L anguage (HTML) and C ascading S tyle S heets (CSS). Highlights from this week included centering a <div>, which is probably one of the biggest memes to ever come out of web development. Labs: 1 - ePortfolio Site In this lab, I created a site hosted on GitHub Pages that features a homepage, about page,...
Read more

Week 24 (6/18/2025 - 6/22/2025)

       (Click on READ MORE for better formatting)      Hi everyone, welcome to my 24th  blog!  This is the Week 8 post for CST 363 Introduction to Database Systems. Briefly summarize what you consider to be the three (3) most important things you learned in this course. How to query in MySQL and MongoDB, including select, insert, update, and delete. This also includes advanced querying techniques, such as subselect. Understanding schema structure of MySQL and MongoDB. After all, for the above to work you need a schema to create/use the database and establish table structures! Creating EER diagrams can also be bundled into this section as it is related to schema creation. How to take database systems and turn them into real-world solutions. For instance, using the JDBC API to create a webapp with a MySQL or MongoDB foundation. This was explored in group labs 19 and 21. That is all for this week, see you in my Week 25  post! Onwards to CST...
Read more