YZJun 11, 20202 min readCST363 - Week 23What is a data warehouse and why is it important? A data warehouse is a place where information is stored in a way that will be useful to...
YZJun 8, 20202 min readCST363 - Week 22In what situations would an index be helpful? not helpful? An index is helpful when a column is used frequently in search conditions and...
YZJun 2, 20202 min readCST363 - Week 21"A column depends on the key, the whole key, and nothing but the key, so help me Codd." The 3rd normal form is when every column that is...
YZMay 25, 20201 min readCST363 - Week 20What are the steps to coding a Java program that will perform a SELECT statement that returns multiple rows? Make a connection to the...
YZMay 17, 20201 min readCST363 - Week 19Most Useful SQL Feature What do you think is the most useful feature in SQL and why? Grouping, Joins, Sub-selects, something else? I...
YZMay 11, 20201 min readCST363 - Week 18Joining Tables Without Primary and Foreign Key Relationship An example of this would be to do a self-join of a table named celebrities...
YZMay 5, 20202 min readCST363 - Week 17Relational Tables VS. Spreadsheets Relational tables and spreadsheets are similar in the fact that they both have rows and columns, or...