cst 363: week 4

 what i've learned so far:

1. Primary keys vs foreign keys - I learned that a primary key uniquely identifies a single record within a table, while a foreign key in one table references the primary key of another table.

2. I learned how to navigate through databases using Java, with applying knowledge from all of the labs we've done so far.

3. I learned that INSERT adds data, WHERE filters data, SELECT retrieves data, and UPDATE modifies data.

4. I learned the difference between SQL as a database, and just using a standard table or spreadsheet view. I know that services like Google Sheets and Airtable can be used as databases, but the relational aspect is what sets SQL apart.

5. I learned how to use JOIN comfortably, which used to combine rows from two or more tables - this is something I used to struggle with. 

some questions i have:

1. I'd love to learn more about the differences between SQL and mySQL vs noSQL, this is something I still have questions about.

2. What is concurrency control in SQL, and why is this important?

3. When designing the architecture of a project or program, how is the decision to use SQL vs noSQL made?