Flavio's Blog

 Flavio Cervantes 05/25/2025 We are already halfway done with this course; I have learned great information regarding how databases operate. At first, I thought databases were strictly utilities houses to store data, but throughout these last 4 weeks I have learned that there is more that goes into it. Such as "normal Forms", these forms are designed to remove anomalies such as duplicate values or redundancy. I also learned how to communicate with business units if I even have to get pre-requisite for a specific database project. One can achieve this by understanding the business needs, and converting that into a production database that runs reliability, ensuring that it is compliant with   the least privilege principles. I have also learned the importance of "keys" such as primary keys or foreign keys. Only one primary key can exist, this is to ID the key and reference it in a foreign key when it is called.  - How much do Azure online databases cost for a sm...

 Flavio Cervantes 05/18/2025 CST 363 Professor Das 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 individu...

 Flavio Cervantes 05/23/2035 CST363-30-2253 Weekly Journal 02 1. SQL has the flexibility to join tables on any column(s) using any predicate (=, >, < ).    Most of the time the join will use equality between a primary and foreign key.   Think of example where joining on something other than keys would be needed.  Write the query both as an English sentence and in SQL.  If you can't think of your own example, search the textbook or internet for an example. - English sentence: Assuming there’s an online car dealership website similar to CarMax, you’re searching to buy a daily driver, but need to filter a min and max price range. That way it’s not too old, but at the same time it’s not a new release that’s out of budget.   - The cars table stores info such as price, model, make.  - The customer_search table stores MIN/MAX per individual customer. - SQL:  SELECT  c.id, c.price, c.model, c.make, c.price, cust.customer_id...

 Flavio Cervantes May 6th, 2025  CST363-30-2253 Learning Journal Week 01 Relational database tables and spreadsheets look similar with both having rows and columns.  What are some important differences between the two? The important differences between the two is that databases have the ability for more robust queries, designed for enterprise level entries, can handle concurrent users connected and writing data more efficiently and reliability compared to a spreadsheet. As an example, regarding to how data is structured/relationships, in a DB, data is stored between tables using primary keys and foreign keys. (eg: A "ClassRegistered” can reference a "student" table through a foreign key.) vs. in Spreadsheets, they do not have native configuration to manage relationships between each sheet and require manually inserted formulas (eg: xlookup, vlookup, etc..) Installing and configuration a database and learning how...