Data Presentation and Manipulation
This part of the book explores SQL techniques for extracting, transforming, and analyzing data. It begins with using SELECT expressions and filtering results to retrieve specific data based on conditions. You’ll learn how to update data, modify table structures, and apply both built-in and user-defined transformation functions. This part also covers joining tables, performing set operations, and aggregating data using GROUP BY and HAVING to uncover broader insights. Finally, it introduces window functions to analyze row positions and relationships within datasets for deeper, context-aware analysis.
This part of the book includes the following chapters:
- Chapter 5, Presenting Data with SELECT
- Chapter 6, Transforming and Updating Data
- Chapter 7, Defining Datasets from Existing Datasets
- Chapter 8, Aggregating Data with GROUP BY
- Chapter 9, Inter-Row Operation with Window Functions
