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

Well done!

You have completed Querying Relational Databases!

Sign up for Treehouse Back to Library

Join Queries

1:47 with Andrew Chalkley and Kevin Nahm

A join is the instruction to the query engine on how to relate records in one table to records in another.

ComplexVenn

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

    Such as primary keys, foreign keys, 0:00
    table relationships, normalization and set theory. 0:01
    These concepts lead the foundation of how we write more powerful SQL queries. 0:05
    We will revisit and 0:11
    expand on these topics as we progress through the rest of this course 0:12
    and get more hands on with the data. 0:16
    In previous courses, you've seen lots of examples of queries. 0:19
    However, they've all been from one table at a time. 0:23
    But, how can you combine related data for more than one table? 0:26

    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