Heads up! To view this whole video, sign in with your Courses account or enroll in your free 7-day trial. Sign In Enroll
Preview
Start a free Courses trial
to watch this video
At this point, we have laid the theoretical groundwork for this course. We will have a brief review before the next stage.
So far we've laid some of
the theoretical groundwork for
0:00
what's to come in
the remainder of this course.
0:03
Let's review a little before moving on.
0:06
We learnt that relational
databases are how we organize data
0:09
in a structured manner.
0:13
Structuring data in a well thought
out manner reduces disk space,
0:14
eliminates redundant data, removes
the possibility of updates anomalies, and
0:19
boosts query performance.
0:24
We learnt about normalization.
0:26
This is the process of identifying and
eliminating things in our database design,
0:28
that would make our database perform poorly or have inconsistent data.
0:33
Last, we learnt about sets.
0:39
And how that applies to relational data.
0:41
We saw how intersect union and except
might look in a very simple example.
0:44
I have a quick assessment for
you to get you ready for the next stage.
0:50
You need to sign up for Treehouse in order to download course files.
Sign up