This section of the course walks through SQL based relational queries. This will include inner joins, outer right joins, and outer left joins. Additionally, we'll examine how to leverage subqueries to build dynamic data sets.

This lesson walks through SQL inner joins. Specifically we'll analyze how to perform queries that bring two tables together and how table aliases can be used to streamline the script code. Lastly, we'll examine how to order a joined result set.

Now that you know how to run an inner join based query in SQL, it's time to move onto more complex queries. Specifically, in this guide we'll walk through how to implement multiple conditionals from various tables to build an inner join based result set.

This guide provides a walkthrough for how to join three database tables together using a SQL inner join. Additionally, we'll examine the possible pitfalls related to running inner join queries with more than two tables.

This guide walks through the key differences between inner and outer joins in SQL. Additionally, we'll examine: inner joins, outer right joins, and outer left joins.

This comprehensive guide walks through how to join three tables and utilize the COALESCE function in order to accurately count records in each table and format the data for users.