Relational Operations
Three specific data retrieval (or query) operations are part of the definition of a relational database management system. The relational operations allow you to tell the system exactly what data you want to see.
Projection selects columns.
Selection (also called restriction) chooses rows.
Join brings together data in related tables.
The physical and logical independence described earlier in this chapter means that you don't have to worry about where the data is physically stored, or how to find it—that's the database management system's problem. SQL is considered a nonprocedural language because it allows you to express what you want without specifying any of the details about where it's located or how to get it.
All three ...
Get Practical SQL Handbook, The: Using SQL Variants, Fourth Edition 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.
