CST 363 Module 4

5 things that I have learned in the course so far.

1. Database Basics:
   I have learned the importance of databases in storing, organizing, and managing data efficiently, while also learning the basics of SQL.
   
   
2. SQL & Queries:
   I have learned how to use SQL for creating, retrieving, updating, and deleting data in a relational database, while also understanding the definitions of each operation and function.
   
   
3. Relational Model:
   I have learned about tables, primary keys, foreign keys, and referential integrity, as these are the foundation of relational databases, while also learning how to use them effectively. 
   
   
4. Database Design:
   I have learned what entities, relationships, attributes, and normalization techniques (like Boyce-Codd Normal Form), while also understanding how they are used both in practice and implementation.
   
   
5. Data Storage & Indexing: 
   I have learned about multi-level indexes, tablespaces, and partitions, which improve the efficiency of a database, while also understanding how to effectively use them.

Questions I still have about databases.

1. How will different techniques dealing with indexing affect a queries performance?
   
   
2. What are the best practices in designing a database?
   
   
3. What is the difference between NoSQL databases and relational databases?
   
   
4. What has a better performance between vertical and horizontal scaling in a database?
   
   
5. What are the differences between an inner join and outer join in SQL?
   
   
6. How would the normalization process reduce data redundancy?