In this chapter, you will learn how to use advanced querying techniques and how to use two different kinds of subqueries, correlated and non-correlated. Then, you will learn about two different types of common table expressions, recursive and non-recursive. Next, you will learn about query hints and how to choose which index your query will use. Finally, you will learn about isolation levels and concepts related to how data is read from, and written to, tables.
In this chapter, we will cover the following topics:
- Using subqueries
- Using common table expressions
- Using query hints and transaction isolation levels
Let's get started!
