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
Video Player
00:00
00:00
00:00
- 2x 2x
- 1.75x 1.75x
- 1.5x 1.5x
- 1.25x 1.25x
- 1.1x 1.1x
- 1x 1x
- 0.75x 0.75x
- 0.5x 0.5x
At this point, we have laid the theoretical groundwork for this course. We will have a brief review before the next stage.
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
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 upYou need to sign up for Treehouse in order to set up Workspace
Sign up