Heads up! To view this whole video, sign in with your Courses account or enroll in your free 7-day trial. Sign In Enroll

Querying Relational Databases

Preview

Start a free Courses trial
to watch this video

Sign up for Treehouse

Why We Make Databases "Relational"

2:31 with Andrew Chalkley and Kevin Nahm

Introducing the concept of "relational" databases.

If you’d like to learn more about Relational Databases, here are a few handy links:

There is a lot of information in these links. We will be touching on quite a bit of it in future videos.

Related Discussions

Have questions about this video? Start a discussion with the community and Treehouse staff.

Sign up

    Related Discussions

    Have questions about this video? Start a discussion with the community and Treehouse staff.

    Sign up

    [MUSIC] 0:00
    In this modern competitive business environment, the companies that learn how 0:04
    to use the mountains of data they've captured have a competitive advantage. 0:08
    Knowledge is power and the databases are the foundation of that knowledge. 0:13
    For the purposes of our SQL courses, 0:19
    the databases that we've been using have been small, with only hundreds of rows. 0:21
    In the real world, databases are very large, 0:27
    having millions of rows in a single table. 0:30
    These commonly used databases are called relational databases. 0:33
    This term came about from structuring databases 0:38
    in a way that tables are linked to each other by shared attributes. 0:41
    These links are the relationships between tables. 0:46
    As an organization's data needs grow, 0:49
    they need a database that can grow and scale with them. 0:54
    How a database schema is designed has a tremendous impact on the types of 0:58
    reports that they can generate and the performance of that database. 1:03
    There are many reasons why relational databases became the standard for 1:08
    application data storage. 1:12
    A few of which are eliminating redundant data reduces storage requirements on disk. 1:14
    Well structured and properly segmented data can be accessed and modified quickly. 1:20
    Bad data leads to bad reports. 1:26
    Relational databases allow schema designers to enforce 1:29
    good data principles which lead to better data quality and better reports. 1:32
    If you imagine unstructured data in a poorly designed database schema, 1:37
    it might look like this. 1:41
    But if you picture organizing your data with a more thoughtful approach, 1:43
    it might start to look like this. 1:48
    This is what relational databases do, they organize data into related tables 1:51
    that give context and meaning to the words and numbers contained within. 1:57
    Hi, I'm Andrew, 2:02
    a database user, a lifelong learner and teacher here at Treehouse. 2:03
    In this course, we're going to be learning a lot about relational databases and 2:08
    writing complex SQL queries and joining relational data together. 2:12
    In the upcoming videos, 2:18
    we'll be taking a look at the concepts that make relational databases work. 2:19
    And start thinking about data in terms of sets 2:24
    as opposed to individual values or rows. 2:28

    You need to sign up for Treehouse in order to download course files.

    Sign up

      You need to sign up for Treehouse in order to set up Workspace

      Sign up