Besides holding more than 1 million rows, what are the main advantages of SQL databases compared to Google spreadsheets? | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
0

Besides holding more than 1 million rows, what are the main advantages of SQL databases compared to Google spreadsheets?

what projects are best suited for Google spreadsheets and which for SQL?

25th Mar 2017, 3:27 AM
Emilie Wolf
Emilie Wolf - avatar
1 Answer
+ 1
Well, there are many but here are some of them. Database, support and give you data manipulation at greater hight then spreadsheet. Moreover, Access to a spreadsheet is sometimes limited to one person at a time. With database management systems, however, several people can access the same data set. Such systems manage editing of data so that two people cannot alter the same data values at the same time. This preserves data integrity, which is harder to manage when using spreadsheets. Output and presentation varies in spreadsheets and databases. With a spreadsheet, you can generate charts and graphs using automated software tools. With a database, such output options are normally a matter for the application providing access to the data.  Most important is that, you can internally change SQL database structure. But not in spreadsheet.
25th Mar 2017, 3:39 AM
Aditya kumar pandey
Aditya kumar pandey - avatar