Bummer! This is just a preview. You need to be signed in with a Basic account to view the entire 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
what's to come in the remainder of this course.
Let's review a little before moving on.
We learnt that relational databases are how we organize data
in a structured manner.
Structuring data in a well thought out manner reduces disk space,
eliminates redundant data, removes the possibility of updates anomalies, and
boosts query performance.
We learnt about normalization.
This is the process of identifying and eliminating things in our database design,
that would make our database perform poorly or have inconsistent data.
Last, we learnt about sets.
And how that applies to relational data.
We saw how intersect union and except might look in a very simple example.
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