Architecture Required

For accuracy it’s required that some processing happens in the SQL query—in many cases, having SQL do the data-related heavy lifting yields a net gain in performance characteristics. It mostly happens because round-trip latency, along with memory and bandwidth resource usage, depends directly on the size of the result sets.

The goal of this course is to provide us with new and powerful tools. Determining how and when to use them has to be done on a case-by-case basis. Still, a general approach is helpful in deciding how and where to implement application features.

Learning advanced SQL