9. The Unary Operators

One relation as input

• 9.1. Unary Operator Introduction
  • 9.1.1. Drawing Charts
• 9.2. Filter
  • 9.2.1. Examples
  • 9.2.2. The Scope and Nature of Filter
  • 9.2.3. Date datatype in DBMS
  • 9.2.4. A word about phrasing
  • 9.2.5. Exercises
• 9.3. Project
  • 9.3.1. Examples
  • 9.3.2. Some notes about the project operator
  • 9.3.3. Exercises
• 9.4. Reduce
  • 9.4.1. Example
  • 9.4.2. Let’s think about this operator
  • 9.4.3. Comparing Reduce to Project
  • 9.4.4. Naming the result relation
  • 9.4.5. Bad Case: Reduce is dangerous!
  • 9.4.6. Bad Case: Computed columns in Reduce are dangerous.
  • 9.4.7. Exercises
• 9.5. Group
  • 9.5.1. Example 1: Group over one column
  • 9.5.2. Example 2: Group over multiple columns
  • 9.5.3. Example 3: Group over no columns
  • 9.5.4. Summary of Group Characteristics
  • 9.5.5. Bad Cases: Group, like Reduce, is dangerous!
  • 9.5.6. Exercises
• 9.6. Summary of Unary Operators
• 9.7. Exercises for Unary Operators
  • 9.7.1. Filter
  • 9.7.2. Project
  • 9.7.3. Reduce
  • 9.7.4. Group

You have attempted of activities on this page