© 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_6

6. Using Views and Friends

Mark Simon1  
(1)
Ivanhoe VIC, VIC, Australia
 

This isn’t the first time you’ve looked at views in this book, and it won’t be the last time.

This chapter consolidates what you may have already picked up about views and related concepts and gives a few ideas about working with them in general.

You can spend the rest of your life writing SQL statements, and the job would get done. However, you might get to the point where writing the same thing over and over again loses its charm, and so you’ll want to find ways of reusing previous queries.

First, let’s have a look ...

Get Leveling Up with SQL: Advanced Techniques for Transforming Data into Insights now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.