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