In the last section of the course, we introduced CRUD. So we walk through how to implement transactional behavior into your database, to be able to create, read, update, and delete items. We implemented all of those and now you should be able to perform all those tasks.

In this section, we’re going to take it up a little bit and we're going to focus on more advanced queries. As great as it is to perform those basic ones usually you're going to be asked to implement some non-trivial behavior into your queries. That's what we're going to get into in this section.

We're going to spend quite a bit of time talking about topics such as subqueries. Which is up to this point we've covered only running a single query at a time. When you're working with elements such as dynamic data, so, in other words, a situation where you may not know what an ID is.

You’ll need to be able to query and find that. That's what a subquery allows us to do and we're going to have multiple episodes where we go through that. We're also going to talk about querying for ranges. Instead of just hard coding a single value in a query we're going to see how we can actually set up a dynamic range, that allows us to find all kinds of values.

We're going to have a few other topics such as being able to set up your own collection of data, and then be able to search through that for multiple parameters instead of just one. So now they have a good idea on what type of advanced queries we're going to get into. Let's dive into the code.