You made it through indexing. This is basically a college course on its own. Congratulations, you made it here.

Now, we're gonna start writing some queries, which is also super fun. If you haven't gathered yet, I think all of this is super fun. In this module, we're gonna do joins, we're gonna do CTEs, recursive CTEs, window functions, series, obfuscation, we're gonna do all kinds of stuff, and here is my encouragement to you as you're watching these. As you're watching these, and you think, "Do I need a window function? I don't have any use for a window function," hear me out.

As you learn about this stuff, your brain is being primed. You're adding signposts in your brain, and then later, when you're working, you don't even have to remember how a window function works. You just have to look at the problem that you're currently working on and think, "Hang on, that feels like something that a window function might solve." Because you have watched the video, and you have learned about the thing, your brain is primed to recognize that pattern in your work.

Recursive CTEs, awesome, maybe not an immediate use case, but totally awesome, window functions, CTEs, cross joins, all of this stuff I think will be useful to you at some point, and ideally, you'll be watching it and think, "Holy cow, that is exactly the problem I have been struggling with." Fingers crossed that that happens. If that does happen, let me know. I would love to hear about it.

Let's write some queries.