Week 18 - Joining More Than Just Concepts

-

This week I expanded on the skills learned from week one. I also want to note that I’m starting to see that our online zybooks textbook is quite resourceful. It can be a bit time consuming but getting through it definitely helps me understand the concepts better.

Homework 2 helped strengthen my skills in SQL and aimed to better my understanding of key SQL concepts like joins, groupings, aggregations, and subqueries, while applying these skills to manage and analyze data within databases. It also challenged me to deal with SQL errors like missing tables.

Lab 10 focused on implementing a natural join using a nested loop. Rows from two tables are combined based on matching values in their common columns. This way we merge tables that without duplicate columns. This involved manipulating schemas and tuples to form the one set from multiple data sources. Tuple merging is important because it allows us to combine related data from multiple tables into a single database without having to deal with redundancies and extra gibberish. 

Labs 5, 6, and 7 focused on SQL aggregation, joins, and subqueries with views. I learned how to use functions like SUM and AVG to summarize data and practiced grouping results with GROUP BY and HAVING. I was also introduced into different types of joins like inner join and left join. I also used subqueries to simplify complex SQL operations.

Prompt:

1. English query: Find all video games products where the customer’s age is greater than the minimum age to be able to purchase it.

SQL Query: SELECT c.customer_name, c.age, vg.product_name, vg.age_requirement FROM customers c JOIN video_games vg ON c.age > vg.age_requirement;

2. SQL is relatively straightforward and intuitive. However sometimes, more complex English questions into SQL can sometimes be a bit thought provoking. Like when they involve multiple joins and nested subqueries. These require a little more familiarity with the syntax but I I think the language as a whole is easy to learn, it’s just the “translation”, so-to-speak, that requires attention. I'm looking forward to expanding on these idea next week and hopefully I won't procrastinate so much next time:)


Comments

Post a Comment

Popular posts from this blog

The End of the Byte Trail

-
Image
Time really does fly. This will be my final journal entry, and it marks the end of Gerek’s “byte trail” and undergraduate journey in Computer Science at CSUMB. Looking back, I can see how much I’ve grown both technically and professionally. I’m glad I was encouraged to keep a journal because now I’m able to look back on my past entries to reflect on my growth. Throughout the program, I’ve developed a strong foundation in core computer science concepts like algorithms, data structures, databases, operating systems, networking, and software engineering. I learned important concepts for being a competent software engineer like documentation, testing, and clean code habits. I plan to carry these forward into my career. As I close out my chapter at Cal State Monterey Bay, I’m excited about the opportunity to step into the tech workforce. It seems learning in this field never truly stops, and I expect my education to continue evolving throughout my career as technology advances. I’m partic...
Read more

Reflections on Algorithms

-
On this week’s exam, I felt confident with core topics like merge sort’s Θ(n log n), and dense graph adjacency matrices. I know I'm able to apply some foundational techniques under pressure. However, I also made some mistakes that came from missing small but important details like carefully identifying the basic operation or following traversal conventions. I need to take a step back and think about both the big picture strategy and the fine details of implementation. This week also marks the halfway point of Algorithms, and I feel like my thinking has grown. It's been both challenging and rewarding because it pushes me to break problems down logically instead of leaning on my intuition - which I often do. I need to strategize more on how I analyze loops, recurrences, and data structures. It also helps to find solutions using precise mathematical notation. Even when I get questions wrong, I view it as an opportunity to sharpen my reasoning and improve my problem solving.
Read more

Refining Documentation and Planning Final Deliverables

-
This week, our team met with our clients Tian & Shuhe to go over the remaining parts of the project as we move toward final submission. During the meeting, we discussed the two different types of tests that will be conducted: a user test performed by Shuhe and a deployment test conducted by Tian himself. This meeting helped us understand what each evaluation will focus on and what we need to prepare for. Tian also requested that we create documentation for the project, specifically a README with a developer-oriented quickstart guide. I contributed to planning the structure and content of that documentation and began outlining what developers will need to quickly understand and run our system. Next week, our main focus will be making the README file, including setting up clear quickstart instructions. I will help consolidate our existing notes, scripts, and architecture explanations into a clean and easy-to-follow document. At the same time, we will begin preparing material for the ...
Read more