Part II

Building Databases and Working with Data

In This Part

Chapter 6

Introducing Basic Query Flow

Chapter 7

Relational Database Design and Creating the Physical Database Schema

Chapter 8

Data Types, Expressions, and Scalar Functions

Chapter 9

Merging Data with Joins, Subqueries, and CTE's

Chapter 10

Aggregating, Windowing, and Ranking Data

Chapter 11

Projecting Data Through Views

Chapter 12

Modifying Data in SQL Server

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.