Heads up! To view this whole video, sign in with your Courses account or enroll in your free 7-day trial. Sign In Enroll
Well done!
You have completed SQL Basics!
You have completed SQL Basics!
Preview
In this video, we'll discuss what data and databases are and review some real-world applications for databases.
This video doesn't have any notes.
Related Discussions
Have questions about this video? Start a discussion with the community and Treehouse staff.
Sign upRelated Discussions
Have questions about this video? Start a discussion with the community and Treehouse staff.
Sign up
Databases.
0:00
They are everywhere.
0:01
They drive the mobile applications and
the websites you use everyday.
0:03
In today's data driven world,
databases and the data inside them
0:07
power business decisions through
data analysis like never before.
0:12
Have you ever wondered how you get such
accurate shopping recommendations?
0:17
How do services, such as Netflix and Hulu,
know which show or movie to suggest next?
0:20
Through the use of databases.
0:26
To understand what data is,
0:29
let's take a brief look at a real world
object and how that relates to data.
0:31
You may have seen things like this
rotary card file on someone's desk.
0:37
They're commonly used to
store contact information.
0:41
Contacts are alphabetically sorted and
store important information
0:44
about each contact, such as a person's
name, phone number, and address.
0:49
Each piece of information on
the cards can be added into the file,
0:54
accessed at a later point, updated when
someone's contact information changes and
0:59
removed if information
is no longer needed.
1:04
Information is data.
1:08
In a way,
the rotary file is a database for
1:10
storing data,
it's just not a computerized one.
1:13
Hello.
1:18
I'm Andrew, a treehouse teacher,
database user and lifelong learner.
1:18
In this course, we'll get to understand
the fundamentals of computerized databases
1:23
and the structures inside of them.
1:28
Most importantly, we'll learn how to
retrieve information out of a database.
1:30
Let's take a look at some real world
implementations of computerized databases
1:36
and how they're used.
1:41
Amazon uses databases to store information
or data on products they sell.
1:43
Amazon stores customer order information
with details such as shipping and
1:48
billing addresses and
customer payment information.
1:52
Customers can also save wish
list containing gift ideas for
1:56
friends and relatives.
2:00
Facebook stores information
about user's friendships,
2:03
likes, private messages, and
wall posts all in a database.
2:06
FedEx has location data for
every package they deliver.
2:12
They use tacking numbers to retrieve
the current location from a database.
2:16
All of FedEx depots and
locations are in the database too.
2:21
Sports leagues around the world,
like the Premier League in the UK,
2:26
use databases to keep track of teams,
players, matches, and other statistics.
2:30
Here, we can see what position
the team is in the league,
2:35
how many games they've played,
how many games they've won and lost.
2:39
All of this is stored in a database.
2:43
As you can see, without databases
2:46
many of the services we rely on wouldn't
be able to operate as they do today.
2:48
Put simply, a database is a tool for
storing massive amounts of information
2:53
that can be retrieved at
a later point in time.
2:57
Software engineers have worked tirelessly
to make information storage and
3:00
retrieval as fast and
efficient as possible,
3:04
making databases the go to solution for
storing information of all types.
3:07
Whether you're a budding developer, a
marketing professional, or just beginning
3:13
your journey into data science, this
course is a great place for you to start.
3:17
You need to sign up for Treehouse in order to download course files.
Sign upYou need to sign up for Treehouse in order to set up Workspace
Sign up