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