CST363Week 1

Relational database tables and spreadsheets look similar with both having rows and columns.  What are some important differences between the two?

A spreadsheet is concerned with small amounts of data and calculations done manually, while databases work with massive amounts of data in an efficient manner. An important contrast between databases and spreadsheets is that the databases can enforce relationships between different tables, thus simplifying consistency maintenance. Databases also allow multiple access for various users, while providing a wide array of security features. Due to the work being shared or edited by several people, the chance of errors is high in spreadsheets.

Installing and configuration a database and learning how to use it is more complicated that just reading and writing data to a file.  What are some important reasons that makes a database a useful investment of time? 

Installing and configuring a database may seem more complicated than saving to and opening from a file, yet it is these complications upon which its usefulness is built. The database offers options for the indexing, querying, and securing of data, thereby making it more powerful than merely reading and writing data into files. The integrity of the data can be maintained through various methods of the database, which presents options for backup, and multi-user access without corruption. Accordingly, databases provide an extremely scalable and reliable solution for businesses or projects that truly value accuracy and efficiency. Therefore, learning databases has its rightful investment because it grooms you to be able to handle real-world data challenges in an enterprising way.

What do you want to learn in this course that you think will be useful in your future career? 

Upon starting this class, I quickly thought of some goals to work towards. I want to be able to implement my skills in real-world scenarios and future projects. Primary hands-on experience in writing SQL Queries, designing relational schemas, and understanding what it takes to connect databases with applications are all vital tools to do so. People in many fields consider these skills particularly useful in tech and engineering jobs, where data influences the very knowledge-based decision-making process. I would also like to be taught about the best practices for security considerations and performance-tuning of databases so I can apply them in genuine situations. Thorough training in database management will prepare me for job functions like those involving system design, software engineering, or data analysis. To say that I am looking forward to this course would be the understatement of the year. I am really looking forward to a terrific class in this semester!

Comments

Popular posts from this blog

Week 4 - Goals!

Week 2 - Second week of class!

Week 4 - Interview with Industry Expert