Summary
Chapter 7, “Relational Database Design and Creating the Physical Database Schema,” introduced the basic SELECT statement and query flow. This chapter expanded the concept with expressions and calculations that can be inserted in several places within the query, significantly improving its flexibility. In subsequent chapters, you see how expressions can receive data from subqueries and user-defined functions, further increasing the power of the query.
Chapter 9, “Merging Data with Joins, Subqueries, and CTEs,” continues the progression of adding capability to the query by joining data from multiple data sources.
Get Microsoft SQL Server 2012 Bible 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.
