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

Agenda - SQL Tutorial

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

Start my 1-month free trial

Agenda

“

- [Ami] I suggest you get yourself some coffee, tea, water, soda, scotch, or snacks, whatever floats your boat. We have a long way to go and I need you fully focused and undistracted. The introduction is what we're doing right now. Hi, nice to meet you. I'm Ami. I think we've met before, didn't we? I'll give you three guesses what will be in our first chapter? You got it. Subqueries are the epitome of SQL composability. We will learn about scalar row and table expression subqueries and I'll show you a neat trick that'll help you remember how correlations work. Set operators are one of my favorite features of SQL, extremely powerful yet easy. And unfortunately, I don't see them used often for reasons that are beyond me. Our second chapter will be about advanced joins. You'll learn about self joins and how they're used to traverse graphs. We'll cover some non-equality predicates and see some practical use cases. Lateral joins are somewhat of an exception to the normal processing operation of join but nothing groundbreaking. After the subquery chapter, they should not be too much of a challenge. Chapter three will blow your mind with a feature called grouping sets, yet another extremely powerful feature that I rarely see used. Ordered set functions are standard aggregate functions with a twist. Their main use is for statistical analysis. So they may not appeal to the less stats-savvy among you. Recursions are considered black magic by many. So we'll break these apart and reveal their essential simplicity and efficiency. I will spend the last section ranting about cursors and how ANSI would have done the world a whole lot of good by banning them from SQL. It will be fun. For dessert, we will briefly review what we've learned. I'll solicit your feedback and give you some advice about which of my other courses to watch. And if you'll be nice, maybe, maybe I'll even recommend some other authors. We'll see about that.

Contents