Heads up! To view this whole video, sign in with your Courses account or enroll in your free 7-day trial. Sign In Enroll
Well done!
You have completed Querying Relational Databases!
You have completed Querying Relational Databases!
Preview
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