Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

Databases SQL Basics Data, Databases and SQL Data is Everywhere

Sean Flanagan
Sean Flanagan
33,235 Points

Other uses for databases

Don't hospitals use databases to keep track of patients, storing information such as names, addresses, landline and mobile phone numbers, hospital numbers, national numbers?

Oziel Perez
Oziel Perez
61,321 Points

You could probably even store entire documents in a database, although such an approach is discouraged; instead you could store file paths to those documents and manage an entire record keeping system using a database.

Additionally, MySQL and similar databases store data in table structures, which means all records will have the same number of fields regardless of whether you put data in them or not, but then there are databases like MongoDB that don't use SQL and store data in JSON format, which means each record can have a completely different amounts of fields and data.

2 Answers

Absolutely! It is hard to think of an industry that does not use some way of storing information in a database system. Every time we submit a form or sign into an account it is all information being pushed or pulled from a database.

Sean Flanagan
Sean Flanagan
33,235 Points

Schools, colleges, universities? Schools and nurseries especially, to protect the kids?

Yeah, everywhere there is data to be stored a database can be used. Education systems most definitely use them for storing the tens of thousands of students information but not all companies use a database system. Where there is big data there is databases. I am not really sure what you mean by protect? Every company has some sort of authorization and authentication process.

Sean Flanagan
Sean Flanagan
33,235 Points

I guess Ethan that that just shows how much I have yet to learn about databases. I've never done SQL before but I've just completed this course which is a real New Year treat! For me, it's a genuine eye-opener! Happy New Year, by the way! :-)