🧠

SQL

  • Structured Query Language
  • Comprehensive relational database language
  • Used for data manipulation and queries

Math Operations

  • Operations are incorporated in an algebra defined for accessing and manipulating data
  • The operations:
    • Select
      • Identify records in a table
    • Project
      • Product a subset of the columns in a table
    • Cartesian product
      • Concatenate rows from two tables
    • Union
    • Difference
    • Intersection
    • Natural join
    • Division

Computer Science Database