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

The following concepts are important to keep in mind when learning advanced SQL.

Relational database management system (RDMS)

PostgreSQL is a relational database management system, and as ...