Chapter 29
SQL traps, Part 2
Joins
The next overall feature/problem of SQL is joins. It was one of the reasons NoSQL emerged. Because imagine if you have quadzillions of pieces of data distributed across tens of tables and you are running a query across these tables.
Recap
Just as a recap. No need to memorize.
These are types of JOINs:
INNER JOIN
Returns only rows that have a match in both tables.
Part of the full course
Unlock this chapter
This one is part of the paid course. Everything before the interview, the free sampler articles, the Core Java drills, and mock interviews stay open either way.