Bummer! This is just a preview. You need to be signed in with a Basic account to view the entire video.

Preview

Start a free Basic trial
to watch this video

Sign up for Treehouse

Theoretical Groundwork

0:54 with Andrew Chalkley and Kevin Nahm

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