Data Correlation and Scope

This chapter is about how to discover data by projecting it, linking it, and limiting data ranges or scopes. The chapter mainly covers the syntax and usage of the SELECT, WHERE, LIMIT, JOIN, and UNION/UNION ALL statements to operate on datasets.

In this chapter, we will cover the following topics:

• Projecting data with SELECT
• Filtering data with conditions such as WHERE and LIMIT
• Linking data with JOIN
• Combining data with UNION