From the course: Advanced SQL: Logical Query Processing, Part 2
Join today to access over 22,500 courses taught by industry experts or purchase this course individually.
The cursors curse - SQL Tutorial
From the course: Advanced SQL: Logical Query Processing, Part 2
The cursors curse
- [Instructor] I said once or twice before, that row processing order doesn't pose any significant logical implications. And that for our humble human brains, it is more intuitive to think of it as if it was a row by row operation. That's why I explained the processing of joins, where having and select all as if they were processed row by row. It was mostly for convenience sake. There's no row order until the order by mutilates are set and turns it into a cursor. So any discussion of row order before that isn't even relevant. Until Dr. Codd invented the relational model, data didn't exist. Just kidding. I'm trying to see if you're paying attention. Until Dr. Codd invented the relational model. Data was processed using a paradigm known as sequential access methods, or uncle SAM for short. Sequential access methods are widely used even today in many programming languages. Unfortunately, many SQL developers are still…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.