From the course: SQL for Testers
Join today to access over 25,300 courses taught by industry experts.
Working through an example - SQL Tutorial
From the course: SQL for Testers
Working through an example
- [Instructor] In the last video, you saw how to query data from multiple tables using inner joins. And as you might guess, there's also something called an outer join. In fact, there are actually three different kinds of outer joins. The left join, right join, and a full join. When using these, the outer part is optional, just like the inner parts optional with the inner join. Now the reality is you usually won't need to use outer joins, and in fact, SQLite hasn't even implemented the right and full joins, so you can't use them in here anyways. For the sake of completeness though, it's worth knowing that there are these kinds of joins. If you want to visualize how they work, W3 Schools has a good set of Venn diagrams here that explain how these different joins work. Now let's take a minute to pull together everything that we've learned so far. We've added join to the set of clauses that we know. So let's see if we can combine everything together into a query that uses all these…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.