Database vs Spreadsheet - Advantages and Disadvantages
views
comments
Related Media
๐๐ป Download Our Free Data Science Career Guide: https://bit.ly/2POLaN8
๐๐ป Sign up for Our Complete Data Science Training with 57% OFF: https://bit.ly/3iKD0lv
In this video, we will focus on the advantages and disadvantages of spreadsheets vs databases.
What is a spreadsheet? It is an electronic ledger, an electronic version of paper accounting worksheets. It was created to facilitate people who needed to store their accounting information in tabular form digitally. So, it is possible to create tables in a spreadsheet. This is one reason some people believe spreadsheets and databases are interchangeable, while, in reality, they arenโt.
There are similarities between the two. Both can contain a large amount of tabular data and can use existing data to make calculations. Third, neither spreadsheets nor databases are typically used by a single person, so many users will work with the data. The differences between the two forms of data storage lie in the way these three characteristics are implemented.
Ok. Imagine a spreadsheet. Every cell is treated as a unique entity. It can store any type of information โ a date, an integer value, a string name. And then, not only can we have different types of values in various cells, but we can also apply a specific format to these cells.
This is not inherent to databases. They contain only raw data. Each cell is a container of a single data value. It is the smallest piece of information there is. You must pre-set the type of data contained in a certain field. This feature prevents inadvertent mistakes โ for example, in a field containing date values, should the user try to insert a string, the software will show an error and she will have the chance to correct herself. This wonโt happen in Excel โ if you insert a string in the column with date values, you wouldnโt obtain an error message, and Excel will store the string value.
โบ Consider hitting the SUBSCRIBE button if you LIKE the content: https://www.youtube.com/c/365DataScience?sub_confirmation=1
โบ VISIT our website: https://bit.ly/365ds
๐ค Connect with us LinkedIn: https://www.linkedin.com/company/365datascience/
365 Data Science is an online educational career website that offers the incredible opportunity to find your way into the data science world no matter your previous knowledge and experience. We have prepared numerous courses that suit the needs of aspiring BI analysts, Data analysts and Data scientists.
We at 365 Data Science are committed educators who believe that curiosity should not be hindered by inability to access good learning resources. This is why we focus all our efforts on creating high-quality educational content which anyone can access online.
Check out our Data Science Career guides: https://www.youtube.com/playlist?list=PLaFfQroTgZnyQFq4nUfb-w2vEopN3ULMb
#Database #Spreadsheet #DataScience
๐๐ป Sign up for Our Complete Data Science Training with 57% OFF: https://bit.ly/3iKD0lv
In this video, we will focus on the advantages and disadvantages of spreadsheets vs databases.
What is a spreadsheet? It is an electronic ledger, an electronic version of paper accounting worksheets. It was created to facilitate people who needed to store their accounting information in tabular form digitally. So, it is possible to create tables in a spreadsheet. This is one reason some people believe spreadsheets and databases are interchangeable, while, in reality, they arenโt.
There are similarities between the two. Both can contain a large amount of tabular data and can use existing data to make calculations. Third, neither spreadsheets nor databases are typically used by a single person, so many users will work with the data. The differences between the two forms of data storage lie in the way these three characteristics are implemented.
Ok. Imagine a spreadsheet. Every cell is treated as a unique entity. It can store any type of information โ a date, an integer value, a string name. And then, not only can we have different types of values in various cells, but we can also apply a specific format to these cells.
This is not inherent to databases. They contain only raw data. Each cell is a container of a single data value. It is the smallest piece of information there is. You must pre-set the type of data contained in a certain field. This feature prevents inadvertent mistakes โ for example, in a field containing date values, should the user try to insert a string, the software will show an error and she will have the chance to correct herself. This wonโt happen in Excel โ if you insert a string in the column with date values, you wouldnโt obtain an error message, and Excel will store the string value.
โบ Consider hitting the SUBSCRIBE button if you LIKE the content: https://www.youtube.com/c/365DataScience?sub_confirmation=1
โบ VISIT our website: https://bit.ly/365ds
๐ค Connect with us LinkedIn: https://www.linkedin.com/company/365datascience/
365 Data Science is an online educational career website that offers the incredible opportunity to find your way into the data science world no matter your previous knowledge and experience. We have prepared numerous courses that suit the needs of aspiring BI analysts, Data analysts and Data scientists.
We at 365 Data Science are committed educators who believe that curiosity should not be hindered by inability to access good learning resources. This is why we focus all our efforts on creating high-quality educational content which anyone can access online.
Check out our Data Science Career guides: https://www.youtube.com/playlist?list=PLaFfQroTgZnyQFq4nUfb-w2vEopN3ULMb
#Database #Spreadsheet #DataScience
- Tags
-