15Manipulating Large Data Sets
15.01 Manipulate Data Using Subqueries
15.02 Describe the Features of Multitable INSERTs
15.03 Use the Following Types of Multitable INSERTs: Unconditional, Conditional, and Pivot
15.04 Merge Rows in a Table
15.05 Track the Changes to Data over a Period of Time
Q&A Self Test
This chapter looks at a variety of features and operations that are useful for working with large groups of data. Many of these features combine SQL statements we’ve already reviewed, but in this chapter we look at new combinations of these features, and new keywords and clauses to broaden capabilities ...