Preview
Video Player
00:00
00:00
Why We Make Databases "Relational"
2:31Introducing the concept of "relational" databases.
[MUSIC]
0:00
In this modern competitive business
environment, the companies that learn how
0:04
to use the mountains of data they've
captured have a competitive advantage.
0:08
Knowledge is power and the databases
are the foundation of that knowledge.
0:13
For the purposes of our SQL courses,
0:19
the databases that we've been using have
been small, with only hundreds of rows.
0:21
In the real world,
databases are very large,
0:27
having millions of rows in a single table.
0:30
These commonly used databases
are called relational databases.
0:33
This term came about from
structuring databases
0:38
in a way that tables are linked to
each other by shared attributes.
0:41
These links are the relationships
between tables.
0:46
As an organization's data needs grow,
0:49
they need a database that can grow and
scale with them.
0:54
How a database schema is designed has
a tremendous impact on the types of
0:58
reports that they can generate and
the performance of that database.
1:03
There are many reasons why relational
databases became the standard for
1:08
application data storage.
1:12
A few of which are eliminating redundant
data reduces storage requirements on disk.
1:14
Well structured and properly segmented
data can be accessed and modified quickly.
1:20
Bad data leads to bad reports.
1:26
Relational databases allow
schema designers to enforce
1:29
good data principles which lead to
better data quality and better reports.
1:32
If you imagine unstructured data in
a poorly designed database schema,
1:37
it might look like this.
1:41
But if you picture organizing your
data with a more thoughtful approach,
1:43
it might start to look like this.
1:48
This is what relational databases do,
they organize data into related tables
1:51
that give context and meaning to
the words and numbers contained within.
1:57
Hi, I'm Andrew,
2:02
a database user, a lifelong learner and
teacher here at Treehouse.
2:03
In this course, we're going to be learning
a lot about relational databases and
2:08
writing complex SQL queries and
joining relational data together.
2:12
In the upcoming videos,
2:18
we'll be taking a look at the concepts
that make relational databases work.
2:19
And start thinking about
data in terms of sets
2:24
as opposed to individual values or rows.
2:28