review

Module 01 Self-Test (cover answers, try first)

  1. What's the SQL execution order?
  2. Why is set lookup O(1) but list lookup O(n)?
  3. P(A or B) when A and B are NOT mutually exclusive?
  4. What does ETL stand for?
  5. How do you find customers with no orders using SQL?
  6. What does STAR stand for?

Practice Questions

Q: What's the SQL execution order?
Q: Why is set lookup O(1) but list lookup O(n)?
Q: P(A or B) when A and B are NOT mutually exclusive?
Q: What does ETL stand for?
Q: How do you find customers with no orders using SQL?
Q: What does STAR stand for?