Leveling Up with SQL: Advanced Techniques for Transforming Data into Insights

© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2023

M. SimonLeveling Up with SQLhttps://doi.org/10.1007/978-1-4842-9685-1_10

10. More Techniques: Triggers, Pivot Tables, and Variables

Mark Simon¹  

(1)

Ivanhoe VIC, VIC, Australia

 

Throughout the book, we’ve looked at pushing our knowledge and application of SQL a little further and explored a number of techniques, some new and some not so new.

When looking at some techniques, in particular, those involving aggregates and common table expressions, we also got a sense of pushing SQL deeper, with multitiered statements.

In this chapter, we’ll go a little beyond simple SQL and explore a few techniques which supplement SQL. They’re not directly related to each other, ...