Week 20 (5/21/2025 - 5/27/2025)

  (Click on READ MORE for better formatting)

    Hi everyone, welcome to my 20th blog! This is the Week 4 post for CST 363 Introduction to Database Systems. This week also officially marks being one fifth of the way to my Computer Science, B.S. degree!
  • Briefly summarize 5 things what you have learned in the course so far.
    • How to utilize MySQL Workbench to select, insert, update, and delete from a table and by extension a database.
    • How to use ranges in a query (example: select column_name from table_name where column_name between v1 and v2)
    • How to use aggregation to display operations on data such as count, avg, min, and max.
    • How to utilize the different types of join (such as natural, left, right, inner, outer) to select data from more than one table in a database.
    • How to understand the efficiency of query calls. These can be visualized using MySQL Workbench by running a query, then going to the visual explain plan diagram. The slowest type of query call is called a Full Table Scan.
  • List at least 3 questions you still have about databases. I realize that some of these topics get covered later in the course, but I am still curious about them nonetheless.
    • How to properly analyze a B+ tree? For example, when a node splits, if there is one new node does that mean the initial node is modified or is that also now considered a new node?
    • How does SQL interact with other programming languages? So far, we have just been implementing certain aspects of SQL using Java but that interaction is different from what this question entails.
    • What are the differences between SQL/MySQL, NoSQL, and MongoDB?

    That is all for this week, see you in my Week 21 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