From the course: Advanced SQL: Logical Query Processing, Part 1

Course agenda - SQL Tutorial

From the course: Advanced SQL: Logical Query Processing, Part 1

Start my 1-month free trial

Course agenda

“

- [Instructor] In this chapter I'll briefly review our agenda and the tools I'll be using. I'll introduce you to the demo database and show you how to use the code files. Then we'll dive right into query processing, starting with the processing of the source data sets. You will see how single and multiple sources are processed, in what order, and why it matters a lot. Next, we'll see how row filters are applied and how to use both binary internally logic. We'll focus on the common anomalies that often deceive even the most experienced developers. In chapter four we will learn exactly what happens to the data set when it's grouped and the logical limitations that grouping brings with it for the rest of the query. In chapter five we'll leave the relational world behind to deal with ordering and paging. It is not as simple or innocent as it may seem. And lastly, we will briefly review what we've learned, I'll give you some recommendations to go, and say proper farewell.

Contents