Develop Cloud Computing Training - Locus IT Services

Develop Cloud Computing Training

Locus IT ServicesDevelop Cloud Computing Training

Lab

Write SELECT statements using subqueries

After completing this module, students will be able to:

  • Write queries accessing data from multiple tables using JOIN operations
  • Understand the differences between type of JOIN operations: INNER JOIN, OUTER JOIN, CROSS JOIN
  • Understand how to join a table to itself with a self-join
  • Write subqueries within a SELECT statement
  • Understand the difference between scalar and multi-valued subqueries
  • Understand the difference between correlated and self-contained subqueries
Locus IT Project Management Office
What’s it?