Skip to Main Content
Data Analytics & Visualization All-in-One For Dummies
book

Data Analytics & Visualization All-in-One For Dummies

by Jack A. Hyman, Luca Massaron, Paul McFedries, John Paul Mueller, Lillian Pierson, Jonathan Reichental, Joseph Schmuller, Alan R. Simon, Allen G. Taylor
April 2024
Beginner content levelBeginner
832 pages
20h 32m
English
For Dummies
Content preview from Data Analytics & Visualization All-in-One For Dummies

Chapter 6

Complex Query Design

IN THIS CHAPTER

Bullet Defining subqueries

Bullet Discovering how subqueries work

Bullet Nesting subqueries

Bullet Tuning nested subqueries

Bullet Tuning correlation subqueries

Bullet Using relational operators

Relational databases have multiple tables. That’s where the word relational comes from — multiple tables that relate to each other in some way. One consequence of the distribution of data across multiple tables is that most queries need to pull data from more than one of them. There are a couple of ways to do this. One is to use relational operators, and the other method is to use subqueries. This chapter covers both methods.

In some cases, you may find that using the JOIN operator makes more sense. This operator is considerably more flexible than the relational operators covered in this chapter. Book 4, Chapter 7 covers the various joins and their operations.

What Is a Subquery?

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Data Science For Dummies

Data Science For Dummies

Lillian Pierson
Data Science For Dummies, 2nd Edition

Data Science For Dummies, 2nd Edition

Lillian Pierson, Jake Porway

Publisher Resources

ISBN: 9781394244096Purchase Link